This is very basic mysql tutorial for the people who need to remember the workflow.
Create Database
Show Databases
Drop Database
Open Specific Database
Show Available Tables in Databases
Create Tabele
View Table Structure
Insert information or data into the mysql
View table Data
Update table
How to Add and Delete a Column
How to Delete a Row
Create Database
CREATE DATABASE name_of_the_database;
Show Databases
SHOW DATABASES;
Drop Database
DROP DATABASE database name;
Open Specific Database
USE name_of_database;
Show Available Tables in Databases
SHOW tables;
Create Tabele
CREATE TABLE tablename(id INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
name VARCHAR(20),
food VARCHAR(30),
confirmed CHAR(1),
signup_date DATE);
View Table Structure
DESCRIBE name_of_the_table;
Insert information or data into the mysql
INSERT INTO `potluck` (`id`,`name`,`food`,`confirmed`,`signup_date`) VALUES (NULL, "John", "Casserole","Y", '2012-04-11');
View table Data
SELECT * FROM tablename;
Update table
UPDATE tablename;
How to Add and Delete a Column
ALTER TABLE table_name DROP column_name;
ALTER TABLE table_name ADD column_name;
How to Delete a Row
DELETE from [table name] where [column name]=[field text];
