Recently after a backup restore MySql server failed to start with the following error message: start: Job failed to start To fix start: Job failed to start I had to re-install the MySQL server. I hope you have a backup of your data because you will lose all your MySQL data running the following commands
Tag Archives: MySql
Get column names from table in MySql > 5
The following query will get column names from table in MySql > 5 SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = ‘database_name’ AND TABLE_NAME = ‘table_name’; where database_name is your database table_name is your table