what are the optimization techniques for Query optimization performance issues and faster execution of queries
2 12814what are the main differences between MyISAM and InnoDB table storage structures ? what are the advantages and disadvantages in usage of these ?
10 44270in a master-master replication with two masters and alternate slaves running on two systems.can i have a script or any mysql command to know which one is right now acting as master.
1 3766if we want to load data from a text file into a mysql table, but the columns in table are 1st: code(int) and 2nd: city(varchar), but in text file the format is 1st cityname and then code separeted by delimeters. how to load?
2 5081Ondelete clause is specified with a.)Drop table b.)Delete command c.)Create table d.)Select command
5 9462How we can copy one table data into another table whose name same as table but in differ database
8 18005please give me the answer for this: query which generates the second highest integer in the table?
8 9030
What is mysql common?
Why do we use mysql?
How to convert character strings to numeric values?
How do you determine the location of mysql data directory?
What is the latest mysql version?
If you wish to encrypt the username and password using php, how will you do that?
What is difference between Sql server and MySql database? It may be silly question but i really dont know.
What is mysql uuid?
What is general log in mysql?
What is difference between oracle and mysql?
What are the limitations of mysql?
What is the difference between mysql_fetch_assoc and mysql_fetch_array?
What is information_schema in mysql?
How to convert character strings to dates?
What is difference between statement and preparedstatement?