what are the optimization techniques for Query optimization performance issues and faster execution of queries
2 12264what are the main differences between MyISAM and InnoDB table storage structures ? what are the advantages and disadvantages in usage of these ?
10 42601in 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 3411if 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 4538Ondelete clause is specified with a.)Drop table b.)Delete command c.)Create table d.)Select command
5 8438How we can copy one table data into another table whose name same as table but in differ database
8 16830please give me the answer for this: query which generates the second highest integer in the table?
8 7745
How to create a trigger in mysql?
Is the syntax correct? Explain the meaning of the syntax given below: $dbc = mysqli_connect('data.aliensabductedme.com', 'owen', 'aliensrool', 'aliendatabase');
What is acid in mysql?
Is mysql good for large database?
What is inner join in mysql?
How to store binary data in mysql?
Can I install mysql on mac?
Explain Access Control Lists.
What is localhost in mysql?
What is the innodb in mysql?
Can you tell few best practices to be followed for optimization in sql?
Suppose you have to collect the first name, middle name and the last name of students from the below table. But, you observe that there few missing values either in the first name, middle name and the last name columns. How will you return the first non-null values?
How can I remotely connect to mysql database?
How do I enable mysqli extension?
How to run a sql statement?