MySQL Cheatsheet Guide and Tutorial
Create Database:
create database yourdbname;
Show All Databases:
show databases;
Change Database:
use mysql;
Drop / Delete a MySQL Database:
drop database nameofyourdatabase;........
MySQL: table is marked as crashed solultion
myisamchk can fix it
But be careful and use the right options to avoid losing data. In fact if you haven't you should make a backup or at least manually copy /var/lib/mysql.
Replace "YourDB" with the name of your database
Replace "yourcrashedtable" with the name of your crashed table.
The -o option is the safest and should avoid dataloss whereas -r is more aggressive and is a last option (I have lost data using -r and........
MySQL Show Print List of Field Names only without other data or attributes
SELECT column_name
FROM information_schema.columns
W........