黑马程序员技术交流社区

标题: 07 [打印本页]

---

作者: emmm...    时间: 2018-1-14 21:57
标题: 07
~~~~~~~~~~~~~~~~~~~~~~~~~~·
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)

---

作者: xiongliu    时间: 2018-1-15 10:48
越来越看不懂了，，但期待你的更新

---

作者: 1414225997    时间: 2018-1-16 10:01
其实我也看不懂

---

作者: 陈文老师    时间: 2018-1-16 15:39
期待每天都看到你的进步~~~

---

作者: 渝小妹    时间: 2018-1-21 17:03
期待你每天的进步   温故而知新

---

欢迎光临 黑马程序员技术交流社区 (http://bbs.itheima.com/)

黑马程序员IT技术论坛 X3.2