Database Operation example for MySQL learning notes for beginners

LearningMySQL databaseIt is necessary that many PHP-based applications use the MySQL database for development. ForBeginnersIt is not that difficult to learn MySQL databases. This article introduces several articles suitable for beginners to learn MySQL databases. Next we will introduce this part.

Basic Database Operations:

1. Create a database

Command: create database <database Name>

For example, create a database named xhkdb.

Mysql> create database xhkdb;

2. display all databases

Command: show databases Note: There is a last s)

Mysql> show databases;

3. delete a database

Command: drop database <database Name>

For example, delete a database named xhkdb.

Mysql> drop database xhkdb;

4. Connect to the database

Command: use <Database Name>

For example, if the xhkdb database exists, try to access it:

Mysql> use xhkdb;

On-screen prompt: Database changed

5. view the currently used database

Mysql> select database ();

6. Table information contained in the current database:

Mysql> show tables; Note: There is a last s)

Database Import and export operations:

1. Export the entire database

Mysqldump-u username-p -- default-character-set = latin1 Database Name> exported file name (the default database encoding is latin1)

Mysqldump-u wcnc-p smgp_rj_wcnc> wcnc. SQL

2. Export a table

Mysqldump-u user name-p database name Table Name> exported file name

Mysqldump-u wcnc-p smgp_rj_wcnc users> wcnc_users. SQL

3. Export a database structure

Mysqldump-u wcnc-p-d-add-drop-table smgp_apps_wcnc> d: wcnc_db. SQL

-D no data-add-drop-table add a drop table before each create statement

4. Import the database

A: common source commands

Log on to the mysql Database Console, such as mysql-u root-p.

Mysql> use Database

Then run the source command. The following parameter is the script file (for example,. SQL used here)

Mysql> source wcnc_db. SQL

B: Use the mysqldump command.

Mysqldump-u username-p dbname <filename. SQL

C: Use the mysql Command

Mysql-u username-p-D dbname <filename. SQL

The following is an introduction to the database operation example for MySQL learning notes for beginners. I hope this introduction will be helpful to you!