what are the optimization techniques for Query optimization performance issues and faster execution of queries2 10526
what are the main differences between MyISAM and InnoDB table storage structures ? what are the advantages and disadvantages in usage of these ?10 38386
in 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 2606
if 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 3433
Ondelete clause is specified with a.)Drop table b.)Delete command c.)Create table d.)Select command5 6108
how to find missing numbers between two order numbers; and dates ?1 4885
How to get full name of monthname ?4 6703
about join2 3009
about foregine2 2402
How to find out the second largest element from mysql table15 20763
How we can copy one table data into another table whose name same as table but in differ database8 13836
please give me the answer for this: query which generates the second highest integer in the table?8 5080
How many tables will create when we create table, what are they?5 6925
How do I stop a mysql command?
How do I tune a mysql query?
What is the date format in mysql?
What are the disadvantages of stored procedures?
What is the difference between char and varchar in mysql?
What is the query to display top 20 rows?
What is key in mysql?
What is mysql server?
What is the difference between heap table and temporary table?
What is mysql sleep process?
What's the difference between mysql and sql server?
Explain the difference between mysql_fetch_array(), mysql_fetch_object()?
What is procedure in mysql?
What is the command used to create a database using php and mysql?
What are the features of mysql?