what are the optimization techniques for Query optimization performance issues and faster execution of queries2 11229
what are the main differences between MyISAM and InnoDB table storage structures ? what are the advantages and disadvantages in usage of these ?10 39899
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 2834
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 3759
Ondelete clause is specified with a.)Drop table b.)Delete command c.)Create table d.)Select command5 6990
how to find missing numbers between two order numbers; and dates ?1 5154
How to get full name of monthname ?4 7231
about join2 3547
about foregine2 2823
How to find out the second largest element from mysql table15 22431
How we can copy one table data into another table whose name same as table but in differ database8 14961
please give me the answer for this: query which generates the second highest integer in the table?8 6012
How many tables will create when we create table, what are they?5 7571
Do you need a license for mysql?
Is mysql same as mariadb?
What is the datatype for password in mysql?
Is mysql same as sql?
What is the default port for MySQL Server?
How many rows can be inserted in mysql at a time?
How to get last inserted id after insert data from a table in mysql?
What is the maximum number of columns per table?
What is int unsigned?
How do you use auto increment?
What is a join? Explain the different types of mysql joins.
What is ntext?
What are the common mysql functions?
How can you make a database as your current database?
What are the limitations of mysql?