Seetha has Published 110 Answers

How can we distinguish between MySQL CROSS JOIN and INNER JOIN?

seetha
seetha
Published on 20-Feb-2018 16:14:13
We can distinguish between MySQL CROSS JOIN and INNER JOIN only on the basis of join-predicate i.e. the condition specified. While writing the query for INNER JOIN we need to specify the condition but in contrast, we do not need to specify the condition while writing a query for CROSS ... Read More

What is the similarity between prepared statements and MySQL user variables?

seetha
seetha
Published on 20-Feb-2018 15:28:00
As we know that MySQL user variables are specific to client connection within which they are used and exist only for the duration of that connection. When a connection ends, all its user variables are lost. Similarly, the prepared statements also exist only for the duration of the session in ... Read More

How can we transfer information between MySQL and data files through command line?

seetha
seetha
Published on 20-Feb-2018 14:13:20
Transferring the information between MySQL and data files mean importing data from data files into our database or exporting data from our database into files. MySQL is having two commands that can be used to import or export data between MySQL and data files through the command line −mysqlimport Actually, mysqlimport ... Read More

How can we MySQL LOAD DATA INFILE statement with ‘ENCLOSED BY’ option to import data from text file into MySQL table?

seetha
seetha
Published on 20-Feb-2018 12:02:17
Sometimes the input text files have the text fields enclosed by double quotes and to import data from such kind of files we need to use the ‘ENCLOSED BY’ option with LOAD DATA INFILE statement. We are considering the following example to make it understand −ExampleFollowings are the comma-separated values ... Read More

How MySQL handles the empty and null values for enumerations?

seetha
seetha
Published on 20-Feb-2018 10:47:14
MySQL accepts empty values for enumeration only if SQL mode is not set as TRADITIONAL, STRICT_TRANS_TABLES or STRICT_ALL_TABLES. Otherwise, MySQL would not accept empty values and throws an error. As we know that each enumeration value is having an index value, the empty value would have 0 index value.Examplemysql> SET ... Read More

How can we change MySQL AUTO_INCREMENT starting number?

seetha
seetha
Published on 19-Feb-2018 17:54:17
MySQL AUTO_INCREMENT value starts from 1 but we can change it with the help of following two ways −With the help of ALTER TABLE query We can use ALTER TABLE query to change the staring value of AUTO_INCREMENT as follows −ALTER TABLE table_name AUTO_INCREMENT = value;ExampleSuppose we have created a ... Read More

What MySQL will return on adding microseconds in the timestamp value for converting it into an integer?

seetha
seetha
Published on 19-Feb-2018 15:53:02
As we know that the value of timestamp can be converted to a number of seconds with the help of UNIX_TIMESTAMP() function. MySQL would ignore the microseconds added to the value of timestamp because the value of UNIX_TIMESTAMP is only 10digits long.Examplemysql> SELECT UNIX_TIMESTAMP('2017-10-22 04:05:36')AS 'Total Number of Seconds'; +-------------------------+ ... Read More

What are the different ways in MySQL to add ‘half year interval’ in date?

seetha
seetha
Published on 19-Feb-2018 15:05:40
We can add ‘half year interval’ in date ith the following ways −(A) By adding interval of 6 Monthsmysql> Select '2017-06-20' + INTERVAL 6 Month AS 'After Half Year Interval'; +--------------------------+ | After Half Year Interval | +--------------------------+ |  2017-12-20              | +--------------------------+ 1 row ... Read More

How will addition, subtraction, multiplication and division operator work with date values stored in MySQL table?

seetha
seetha
Published on 19-Feb-2018 11:50:23
When we try to do such kind of operations with date values stored in the table then MySQL is assuming the date values as the number and perform the arithmetic.Suppose we have a table named ‘example’ having a date value in ‘orderdate’ column then following arithmetic operation will clarify the ... Read More

Why we cannot use MySQL DATE data type along with time value?

seetha
seetha
Published on 19-Feb-2018 10:34:36
The default format for MySQL DATE data type is “YYYY-MM-DD” and in this format, there is no possibility to store the time value. Hence, we can say that we cannot use DATE data type along with time value.As we can see in the following example MySQL returns only date value ... Read More
Previous 1 ... 3 4 5 6 7 8 9 ... 11 Next
Advertisements