Quizgum : MySQL command

MySQL command

kinds	command
creating database	CREATE DATABASE database name;
view database list	SHOW DATABASES;
Select database to work with	USE database name;
creating table	CREATE TABLE table name;
View all fields in the table	desc or describe table name
Add data to the table	INSERT INTO table name VALUES(data, data, data)
View all data in the table	SELECT * FROM table name;

Frequently Used Commands

kinds	command	meaning
Database commands	create	Creation of database
	drop	Deletion of the database
	use	Database selection
Table command	create	Create Table
	desc or describe	Table structure
	alter	Change field in table
	rename	Rename Table
	drop	Drop table
Data manipulation instruction	insert	Record input
	select	record search
	update	Record changes
	delete	Delete record
Database backup and restore	mysqldump	Database backup
Database backup and restore	mysql	Database restore