A股上市公司传智教育(股票代码 003032)旗下技术交流社区北京昌平校区

 找回密码
 加入黑马

QQ登录

只需一步,快速开始

© emmm... 中级黑马   /  2018-1-14 21:57  /  1335 人查看  /  4 人回复  /   0 人收藏 转载请遵从CC协议 禁止商业使用本文

~~~~~~~~~~~~~~~~~~~~~~~~~~·
C:\Users\Administrator>mysql -u root -p
Enter password: ******
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 9
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 a1;
Query OK, 1 row affected (0.00 sec)

mysql> use a1;
Database changed
mysql> create table a(
    -> uid int primary key auto_increment,
    -> mname varchar (40)not null,
    -> age int ,
    -> school varchar (20)not null,
    -> hobby varchar (30)not null,
    -> speciality varchar (25)not null
    -> );
Query OK, 0 rows affected (0.13 sec)

mysql> insert into a(name,age,school,hobby,speciality)value('额',1,'呃','の','鄂');
ERROR 1054 (42S22): Unknown column 'name' in 'field list'
mysql> insert into a(mname,age,school,hobby,speciality)value('额',1,'呃','の','鄂');
Query OK, 1 row affected (0.03 sec)

mysql> drop database a1;
Query OK, 1 row affected (0.11 sec)

4 个回复

倒序浏览
越来越看不懂了,,但期待你的更新
回复 使用道具 举报
其实我也看不懂
回复 使用道具 举报
期待每天都看到你的进步~~~
回复 使用道具 举报
期待你每天的进步   温故而知新
回复 使用道具 举报
您需要登录后才可以回帖 登录 | 加入黑马