what are the optimization techniques for Query optimization performance issues and faster execution of queries
2 12675what are the main differences between MyISAM and InnoDB table storage structures ? what are the advantages and disadvantages in usage of these ?
10 43820in 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 3676if 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 4965Ondelete clause is specified with a.)Drop table b.)Delete command c.)Create table d.)Select command
5 9231How we can copy one table data into another table whose name same as table but in differ database
8 17711please give me the answer for this: query which generates the second highest integer in the table?
8 8693
What is mysql database server?
How we can see all indexes defined for a table in mysql?
How to delete a column and add a new column to database
What is mysql database used for?
What are the types of queries?
What is a storage engine?
What is mysql slow query?
How set mysql root password?
What is general log in mysql?
Why phpmyadmin is used for mysql?
What you can use regular expression for in mysql?
How do I restore a mysql database dump file in linux?
What are the different column comparison operators in mysql?
What is foreign key in mysql?
How do I connect to mysql database?