what are the optimization techniques for Query optimization performance issues and faster execution of queries
2 12794what are the main differences between MyISAM and InnoDB table storage structures ? what are the advantages and disadvantages in usage of these ?
10 44229in 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 3756if 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 5068Ondelete clause is specified with a.)Drop table b.)Delete command c.)Create table d.)Select command
5 9438How we can copy one table data into another table whose name same as table but in differ database
8 17968please give me the answer for this: query which generates the second highest integer in the table?
8 8990
What is join in mysql? What are the different types of join?
What is blob storage?
What is cursor in mysql?
How many mysql connections can handle?
What is the latest mysql?
How to shutdown mysql server?
Where is the mysql config file?
Is mysql a server?
How to decrement dates by 1 in mysql?
What is maximum table size in mysql?
What is acid in mysql?
Can we store images in mysql database?
How do you know the version of your mysql server?
How to escape special characters in sql statements?
How do you rename a table?