MySQL's a few basic commands

Here are a few common basic SQL statements:

1. Start and stop the database service:

net start mysql_namenet stop Mysql_name

2. Log in to MySQL command:

- - p Enter Password

3. View all databases in the current system:

SHOW DATABASES;

4. Create and delete databases:

CREATE DATABASE database_name; DROP DATABASE database_name;

5. View the data tables in the current database:

SHOW TABLES;

6. Create and delete data tables:

CREATE TABLE table_name; DROP TABLE table_name;

MySQL's a few basic commands