Giri Raju, asked on 19th Feb, 2018

In MySQL, what is the difference between SERIAL and AUTO_INCREMENT?

As I know about AUTO_INCREMENT but how it is technically distinguished from SERIAL?
Sreemaha, asked on 19th Feb, 2018

How can I store the fixed length string as well as variable length string in the same MySQL table?

I have two sorts of character data, one is fixed length and other is variable length and want to store both in the same MySQL table.
Sharon Christine, asked on 19th Feb, 2018

What MySQL returns if sub-query, used to assign new values in the SET clause of UPDATE statement, returns multiple rows?

Suppose if I am using sub-query for giving new values in the table that returns more than one row. Then I want to know how MySQL will react on this.
Arushi, asked on 19th Feb, 2018

What MySQL returns if sub-query, used to assign new values in the SET clause of UPDATE statement, returns no rows?

Suppose if I am using sub-query for giving new values in the table that returns no rows. Then I want to know how MySQL will react on this.
Isha, asked on 19th Feb, 2018

How can we update the values in one MySQL table by using the values of another MySQL table?

I want to change the existing values of a table but I want to use the values of another MySQL table for this purpose. Is it possible to do so?
varma, asked on 19th Feb, 2018

What is the use of ALLOW_INVALID_DATES SQL mode?

I want to store invalid dates in MySQL table. Do I need to use any SQL mode for doing the same?
usharani, asked on 19th Feb, 2018

How can we search a record from MySQL table having a date as a value in it?

I have a MySQL table storing the date values. I want to search the records based on those date values.
Chandu yadav, asked on 19th Feb, 2018

What is the importance of the order of Columns in the SET clause of UPDATE statement? Will it make big difference in result set returned by MySQL?

I am using MySQL UPDATE statement to change the existing values in table. I want to that will it make any difference if I’ll change the order of columns written in SET clause of UPDATE statement.
Samual Sam, asked on 19th Feb, 2018

How can we use existing values of the rows to provide new values in the SET clause of UPDATE statement?

I am using a MySQL UPDATE statement to change the existing values in the table. I want to use the values, which are already existed in the table, in SET clause, to endow with new values.
varun, asked on 19th Feb, 2018

How MySQL evaluates if I store date along with time value in a column having DATE data type?

I am storing the date and time value both in a DATE datatype but MySQL is evaluating only the date part along with a warning.
Prabhas, asked on 19th Feb, 2018

What is the difference between MySQL NOW() and SYSDATE()?

NOW() and SYSDATE() gives the different output. Which factor affects their result?
seetha, asked on 19th Feb, 2018

How GET_FORMAT() function can combine with DATE_FORMAT() and STR_TO_DATE() function?

I have the value in datatype like DATE, TIME, DATETIME, and TIMESTAMP but want to convert that value in another format like EUR, ISO, JIS etc. I am using GET_FORMAT() function for this purpose but want to know that can I combine this with other functions like DATE_FORMAT() and STR_TO_DATE() function.
vanithasree, asked on 19th Feb, 2018

What is the use of MySQL GET_FORMAT() function?

I have the value in data types like DATE, TIME, DATETIME and TIMESTAMP but want to convert that value in other format like EUR, ISO, JIS etc. How can it be done by using a MySQL function?
Paul Richard, asked on 19th Feb, 2018

How can we update columns values on multiple rows with a single MySQL UPDATE statement?

I have inserted some values in MySQL table but now I want to change the value of more than one row of that table. Which MySQL statement would be useful?
radhakrishna, asked on 19th Feb, 2018

How can we create a MySQL function to find out the duration of years, months, days, hours, minutes and seconds?

I want to create a function that can find out the duration of years, months, days, hours, minutes and seconds.
Advertisements
Loading...
Unanswered Questions View All