java mysql项目_java项目——mysql简单操作

Enter password: ******

Welcome to the MySQL monitor. Commands end with ; or \g.

Your MySQL connection id is 1

Server version: 5.6.26-log MySQL Community Server (GPL)

Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its

affiliates. Other names may be trademarks of their respective

owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> show databases;

+--------------------+

| Database |

+--------------------+

| information_schema |

| jrkj |

| jrkj_java |

| mysql |

| performance_schema |

| sakila |

| shop |

| test |

| world |

+--------------------+

9 rows in set (0.02 sec)

mysql> create database drp;

Query OK, 1 row affected (0.00 sec)

mysql> use drp;

Database changed

mysql> \

mysql> \. G:\SSH\user_create.sql

Query OK, 0 rows affected, 1 warning (0.00 sec)

Query OK, 0 rows affected (0.04 sec)

mysql> show tables;

+---------------+

| Tables_in_drp |

+---------------+

| t_user |

+---------------+

1 row in set (0.00 sec)

mysql> desc t_user;

+-------------+-------------+------+-----+-------------------+-----------------------------+

| Field | Type | Null | Key | Default | Extra |

+-------------+-------------+------+-----+-------------------+-----------------------------+

| user_id | varchar(10) | NO | PRI | NULL | |

| user_name | varchar(30) | NO | | NULL | |

| password | varchar(30) | YES | | NULL | |

| contact_tel | varchar(30) | YES | | NULL | |

| email | varchar(30) | YES | | NULL | |

| create_date | timestamp | NO | | CURRENT_TIMESTAMP | on update CURRENT_TIMESTAMP |

+-------------+-------------+------+-----+-------------------+-----------------------------+

6 rows in set (0.01 sec)

mysql>