What does TIMESTAMP ON UPDATE CURRENT_TIMESTAMP data type
do?
Answer / amith
On initialization places a zero in that column, on future
updates puts the current value of the timestamp in.
Is This Answer Correct ? | 4 Yes | 0 No |
Can you tell the reasons for selecting lamp(linux, apache, mysql, php) instead of any other combination of software programs, servers, and operating system?
What is mysql optimization?
What is the diff. bwt. primary key and unique key?
How to Recover a MySQL root password. Stop the MySQL server process. Start again with no grant tables. Login to MySQL as root. Set new password. Exit MySQL and restart MySQL server.
what are the optimization techniques for Query optimization performance issues and faster execution of queries
2 Answers Infosys, Sierra Atlantica,
I have a table like this tblData (month int,Qty int) and i am inserting three rows in this table 1.tblData Values (1,100) 2.tblData Values (2,200) 3.tblData Values (3,300) The Result I want is the Running total of the field Qty that is 1 100 100 2 200 300 3 300 600 What is the Query for that ?
How to set mysql variable in php?
How to use regular expression in pattern match conditions?
How do you start MySQL on Linux?
How do I tune a mysql query?
How do I transfer data from one database to another in mysql?
Explain the difference between MyISAM Static and MyISAM Dynamic?