Microsoft Windows [版本 6.1.7600]
版权所有 (c) 2009 Microsoft Corporation。保留所有权利。
C:\Users\Administrator>mysql -uroot -p
Enter password: ******
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.5.27 MySQL Community Server (GPL)
Copyright (c) 2000, 2011, 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> create database db_shop;(创建数据库)
Query OK, 1 row affected (0.02 sec)
mysql> show databases;(显示数据库)
+--------------------+
| Database |
+--------------------+
| information_schema |
| db_shop |
| mysql |
| performance_schema |
| test |
+--------------------+
5 rows in set (0.03 sec)
mysql> use db_shop;(选择数据库)
Database changed
mysql> drop database db_shop;(删除数据库)
Query OK, 0 rows affected (0.08 sec)
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| test |
+--------------------+
4 rows in set (0.01 sec)
mysql> create table tb_shangpin<
-> id int<4> auto_increment primary key,
-> mingcheng varchar<25>,
-> jianjie mediumtext,
-> addtime varchar<25>,
->
-> >
-> >;
ERROR 1046 (3D000): No database selected
mysql> tb_students<
-> id int<4> auto_increment primary key,
-> name varchar<25>,
-> age varchar<10>>;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near 'tb_st
udents<
id int<4> auto_increment primary key,
name varchar<25>,
age varchar' at line 1
mysql> tb_students<
-> id int<4> auto_increment primary key,
-> name varchar<25>,
-> age int<10>>;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near 'tb_st
udents<
id int<4> auto_increment primary key,
name varchar<25>,
age int<10>' at line 1
mysql> create table tb_shangpin<
-> id int<4> auto_increment primary key,
-> mingcheng varchar<25>,
-> jianjie mediumtext,
-> addtime varchar<25>,
-> dengji varchar<25>,
-> xinghao varchar<25>,
-> tupian varchar<200>,
-> shuliang int<4>,
-> typeid int<4>,
-> huiyuanjia varchar<25>,
-> pinpai varchar<25>>;
ERROR 1046 (3D000): No database selected
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| test |
+--------------------+
4 rows in set (0.00 sec)
mysql> create database db_student;
Query OK, 1 row affected (0.00 sec)
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| db_student |
| mysql |
| performance_schema |
| test |
+--------------------+
5 rows in set (0.00 sec)
mysql> use database db_student;
ERROR 1049 (42000): Unknown database 'database'
mysql> use db_student;
Database changed
mysql> create table tb_student<
-> id int auto_increment primary key,
-> name varchar<30>,
-> age int<4>>;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near '<
id int auto_increment primary key,
name varchar<30>,
age int<4>>' at line 1
mysql> create table tb_student<
-> id int auto_increment primary key,
-> name varchar<30>,
-> age int(4)>;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near '<
id int auto_increment primary key,
name varchar<30>,
age int(4)>' at line 1
mysql> create table tb_student<
-> id int auto_increment primary key,
-> name varchar(30),
-> age int(4),
-> class varchar(30)>;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near '<
id int auto_increment primary key,
name varchar(30),
age int(4),
class varchar' at line 1
mysql> create database db_admin;
Query OK, 1 row affected (0.01 sec)
mysql> use db_admin;
Database changed
mysql> create table tb_student(
-> id int auto_increment primary key,
-> name varchar(30),
-> age int(4),
-> class varchar(30)); (创建数据表结构)
Query OK, 0 rows affected (0.08 sec)
mysql> show columns from tb_atudent from db_admin;
ERROR 1146 (42S02): Table 'db_admin.tb_atudent' doesn't exist
mysql> show columns from tb_student from db_admin; (显示数据表结构)
+-------+-------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------+-------------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| name | varchar(30) | YES | | NULL | |
| age | int(4) | YES | | NULL | |
| class | varchar(30) | YES | | NULL | |
+-------+-------------+------+-----+---------+----------------+
4 rows in set (0.01 sec)
mysql> desc tb_student id; (显示数据表结构)
+-------+---------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------+---------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
+-------+---------+------+-----+---------+----------------+
1 row in set (0.03 sec)
mysql> alter table tb_student add email varchar(50) not null;(修改数据表结构)
Query OK, 0 rows affected (0.12 sec)
Records: 0 Duplicates: 0 Warnings: 0
mysql> desc tb_student email;
+-------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------+-------------+------+-----+---------+-------+
| email | varchar(50) | NO | | NULL | |
+-------+-------------+------+-----+---------+-------+
1 row in set (0.01 sec)
mysql> alter table tb_student modify name varchar(40); (修改数据表结构)
Query OK, 0 rows affected (0.12 sec)
Records: 0 Duplicates: 0 Warnings: 0
mysql> desc tb_student name;
+-------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------+-------------+------+-----+---------+-------+
| name | varchar(40) | YES | | NULL | |
+-------+-------------+------+-----+---------+-------+
1 row in set (0.01 sec)
mysql> show columns from tb_student from db_admin;
+-------+-------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------+-------------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| name | varchar(40) | YES | | NULL | |
| age | int(4) | YES | | NULL | |
| class | varchar(30) | YES | | NULL | |
| email | varchar(50) | NO | | NULL | |
+-------+-------------+------+-----+---------+----------------+
5 rows in set (0.01 sec)
mysql> desc tb_student; (显示表结构)
+-------+-------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------+-------------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| name | varchar(40) | YES | | NULL | |
| age | int(4) | YES | | NULL | |
| class | varchar(30) | YES | | NULL | |
| email | varchar(50) | NO | | NULL | |
+-------+-------------+------+-----+---------+----------------+
5 rows in set (0.01 sec)
mysql> rename table tb_student to tb_admin; (重命名)
Query OK, 0 rows affected (0.04 sec)
mysql> desc tb_admin;
+-------+-------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------+-------------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| name | varchar(40) | YES | | NULL | |
| age | int(4) | YES | | NULL | |
| class | varchar(30) | YES | | NULL | |
| email | varchar(50) | NO | | NULL | |
+-------+-------------+------+-----+---------+----------------+
5 rows in set (0.01 sec)
mysql> drop table tb_admin; (删除表)
Query OK, 0 rows affected (0.11 sec)
mysql> desc tb_admin;
ERROR 1146 (42S02): Table 'db_admin.tb_admin' doesn't exist
mysql>
本文来源:https://www.2haoxitong.net/k/doc/cd99750810661ed9ad51f3f3.html
文档为doc格式