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 Show Print List of Field Names only without other data or attributes
SELECT column_name
FROM information_schema.columns
W........
Create Table with structure of another existing table
Create Table with structure of another existing tableOk, this has many valid uses such as if you need to create backups or the ability to undo changes, you would want to create new tables with the same structure as another. Here is how you do it.
[i:7ed9581493]
Also remember Indexes such as PRIMARY KEYS [b:7ed9581493]will not be preserved[/b:7ed9581493] so you will have to readd them manually.[/i:7ed9581493]
[code:1:7ed9581493]CREATE TABLE NewName AS SEL........
ADD PRIMARY KEY to Table
ADD PRIMARY KEY to TableHere is an example of readding a PRIMARY KEY with an AUTO_INCREMENT field:
[b:40986c2a8b]First make the field NOT NULL[/b:40986c2a8b]
[code:1:40986c2a8b]
ALTER TABLE tableName MODIFY FieldNAME INT(18) NOT NULL;
[/code:1:40986c2a8b]
[b:40986c2a8b]Create The Primary Key[/b:40986c2a8b]
[code:1:40986c2a8b]ALTER TABLE tableName ADD CONSTRAINT PRIMARY KEY(FieldName);[/code:1:40986c2a8b........
MySQL Restoring And Dumping/Backing UP MySQL Data/Tables/Databases
Backing MySQL Databases
Backing Up/Dumping All Mysql Databases To A Single File
mysqldump --all-databases -u admin -p > allmysqldatabases.sql
The "-all-databases" clause is pretty obvious isn't it? It means that it will backup all databases.
The "-u admin" means login using the user "admin", if you h........