MySQL Archives - Page 5 of 14

How to Generate Random String in MySQL

Sometimes you may need to generate random string in MySQL. Here are the steps to do this.

Sometimes you may need to import Excel spreadsheet into MySQL. Here are the steps to do so.

Often database developers need to view MySQL log files. Here is how to view MySQL log files.

MySQLdump command locks tables while taking backup. Here is how to run MySQLdump without locking tables.

It is a good practice to test if MySQL database exists before using it. Here are the steps to check if MySQL database exists.

Sometimes you may need to get MySQL date format in DD/MM/YYYY in SELECT query. Here are the steps to do so.

Sometimes you may need to fix MySQL error 1153. Here is how to do it.

Sometimes you may need to create temporary table from SELECT query in MySQL. Here are the steps to do it.

Often you may need to import SQL file in MySQL using command line. Here are the steps to do it.

Sometimes you may get an error ‘Server quit without updating PID file’ in MySQL. Here is how to fix this problem.