Create Database:

create database yourdbname;

Show All Databases:

show databases;

Change Database:

use mysql;

Drop / Delete a MySQL Database:

drop database nameofyourdatabase;

mysql> drop database cardb;
Query OK, 1 row affected (0.10 sec)

How To Delete a Table in MySQL:

DROP table yourtablename;

How To Delete All Data From a Table in MySQL:

DELETE FROM tablename;

How To Delete Selective Data From A Table in MySQL:

DELETE FROM tablename WHERE ID > 25;

Just add the where clause according to a column inside the table EG ID, or WHERE username = "someuser@hello.com"
 

How To Dump The Table Structure SQL Code:

show create table yourtablename;

View tables in database:

show tables;

View table structure:

describe yourtablename;

How To Change a Column Field:

Make sure you edit what is in bold to suit your table name, column name and type (eg. int, varchar, text).

alter table yourtable modify column columname int;

Create a new user and password for your database:

myfirstdb is the name of your database and the .* grants the same privileges to all tables (you could fine tune this by replacing the * with a table name).

yourusername is the username

yourpassword is the password

After grant are the privileges, if you want to give them full access you could just use "GRANT ALL" or if you want to restrict them to only reading you could just use "GRANT SELECT" and any other number of options that meet your needs for security.

GRANT SELECT, INSERT, DELETE on myfirstdb.* to yourusername@localhost IDENTIFIED BY 'yourpassword';

mysql, cheatsheet, tutorialcreate, database, yourdbname, databases, delete, nameofyourdatabase, cardb, query, ok, sql, yourtablename, column, edit, bold, eg, int, varchar, text, alter, yourtable, modify, columname, user, password, myfirstdb, grants, privileges, replacing, yourusername, username, yourpassword, quot, restrict, select, insert, localhost, identified,

Latest Articles