Vanithasree has Published 101 Articles

Web Fonts in CSS

vanithasree

vanithasree

Updated on 20-Jun-2020 13:51:17

90 Views

Web fonts are used to allow the fonts in CSS, which are not installed on a local system. ExampleThe following code shows the sample code of font face:Live Demo                    @font-face {             font-family: myFirstFont;     ... Read More

How can we create a new database by using mysqladmin?

vanithasree

vanithasree

Updated on 20-Jun-2020 13:40:02

117 Views

We would need special privileges to create or to delete a MySQL database. Following is the syntax for creating a new database using mysqladmin binary −Syntax[root@host]# mysqladmin -u root -p create db_name Enter password:******Here, db_name is the name of the database we want to create.ExampleFollowing is a simple example to ... Read More

How can I check the list of MySQL tables, in a different database than we are using currently, along with table type in the result set?

vanithasree

vanithasree

Updated on 20-Jun-2020 12:57:10

44 Views

It can be done with the SHOW FULL TABLES statement. Its Syntax would be as follows −SyntaxSHOW FULL TABLES FROM db_nameHere, db_name is the name of the database from which we want to see the list of tables.ExampleWe are currently using the database named ‘query’ and the MySQL query below ... Read More

How to allow a MySQL user account to connect from any host?

vanithasree

vanithasree

Updated on 20-Jun-2020 11:50:03

2K+ Views

It is quite possible to allow a user account to connect from any host. To do so we need to create the user with the help of ‘%’ wild card character after @ character. Its syntax would be as follows −Use mysql; CREATE USER user_name@’%’ IDENTIFIED BY password;Here user_name is the ... Read More

What are the properties of MySQL user variables?

vanithasree

vanithasree

Updated on 20-Jun-2020 10:47:34

102 Views

Followings are the properties of MySQL user variables −Not Case-SensitiveA user variable is not case-sensitive. They are case-sensitive before version MySQL 5. It can be illustrated in the following example −Examplemysql> SET @A = 'MySQL'; Query OK, 0 rows affected (0.00 sec) mysql> Select @A, @a; +-------+-------+ | @A ... Read More

What kind of settings can we do to a text file by query while exporting the values from MySQL table into a text file?

vanithasree

vanithasree

Updated on 20-Jun-2020 09:26:54

58 Views

While exporting the data from MySQL table to a text file we can use ‘FIELDS TERMINATED BY’, ‘ENCLOSED BY’, ‘LINES TERMINATED BY’ and other options too to put the values of fields in different settings of the text file. It can be illustrated with the help of the following example ... Read More

How can we import data from .CSV file into MySQL table?

vanithasree

vanithasree

Updated on 20-Jun-2020 09:14:57

489 Views

Actually.CSV is also a text file in which the values are separated by commas or in other words we can say that text file with CSV(comma separated values). We need to use FIELDS SEPARATED OPTION with LOAD DATA INFILE statement while importing the data from .CSV file to MySQL table. ... Read More

what are the different attributes of MySQL ENUM data type?

vanithasree

vanithasree

Updated on 20-Jun-2020 08:44:48

358 Views

MySQL ENUM types can be defined with following attributes that affect the allowed values −NOT NULL  − In ENUM type, by default NULL values are allowed. To disallow NULL values, we need to use the NOT NULL attribute while describing the ENUM column.NULL  − The NULL attribute is a synonym ... Read More

What is the difference between UNIX TIMESTAMPS and MySQL TIMESTAMPS?

vanithasree

vanithasree

Updated on 20-Jun-2020 06:29:55

917 Views

In MySQL, UNIX TIMESTAMPS are stored as 32-bit integers. On the other hand MySQL TIMESTAMPS are also stored in similar manner but represented in readable YYYY-MM-DD HH:MM:SS format.Examplemysql> Select UNIX_TIMESTAMP('2017-09-25 02:05:45') AS 'UNIXTIMESTAMP VALUE'; +---------------------+ | UNIXTIMESTAMP VALUE | +---------------------+ | 1506285345          | +---------------------+ 1 row ... Read More

What is onkeyup event in JavaScript?

vanithasree

vanithasree

Updated on 19-Jun-2020 11:18:47

279 Views

The onkeyup event triggers when a key is released.ExampleYou can try to run the following code to learn how to work with onkeyup event in JavaScript −                                         Enter subject below in upper case and see what happpens.          

Advertisements