无意义的存在,只是记录学习MySQL的经历:)
Windows PowerShell
版权所有 (C) 2009 Microsoft Corporation。保留所有权利。
PS C:\Users\kiwi> mysql -h localhost -uroot -p
Enter password: ****
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 29
Server version: 5.5.16 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> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| cdcol |
| kiwi |
| loaddata |
| login |
| mysql |
| performance_schema |
| phpmyadmin |
| rmisdb |
| user |
| usermanage |
| webauth |
+--------------------+
12 rows in set (0.07 sec)
mysql> create database ssbit;
Query OK, 1 row affected (0.06 sec)
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| cdcol |
| kiwi |
| loaddata |
| login |
| mysql |
| performance_schema |
| phpmyadmin |
| rmisdb |
| ssbit |
| user |
| usermanage |
| webauth |
+--------------------+
13 rows in set (0.00 sec)
mysql> use ssbit;
Database changed
mysql> show characterset;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the r
ight syntax to use near 'characterset' at line 1
mysql> show character set;
+----------+-----------------------------+---------------------+--------+
| Charset | Description | Default collation | Maxlen |
+----------+-----------------------------+---------------------+--------+
| big5 | Big5 Traditional Chinese | big5_chinese_ci | 2 |
| dec8 | DEC West European | dec8_swedish_ci | 1 |
| cp850 | DOS West European | cp850_general_ci | 1 |
| hp8 | HP West European | hp8_english_ci | 1 |
| koi8r | KOI8-R Relcom Russian | koi8r_general_ci | 1 |
| latin1 | cp1252 West European | latin1_swedish_ci | 1 |
| latin2 | ISO 8859-2 Central European | latin2_general_ci | 1 |
| swe7 | 7bit Swedish | swe7_swedish_ci | 1 |
| ascii | US ASCII | ascii_general_ci | 1 |
| ujis | EUC-JP Japanese | ujis_japanese_ci | 3 |
| sjis | Shift-JIS Japanese | sjis_japanese_ci | 2 |
| hebrew | ISO 8859-8 Hebrew | hebrew_general_ci | 1 |
| tis620 | TIS620 Thai | tis620_thai_ci | 1 |
| euckr | EUC-KR Korean | euckr_korean_ci | 2 |
| koi8u | KOI8-U Ukrainian | koi8u_general_ci | 1 |
| gb2312 | GB2312 Simplified Chinese | gb2312_chinese_ci | 2 |
| greek | ISO 8859-7 Greek | greek_general_ci | 1 |
| cp1250 | Windows Central European | cp1250_general_ci | 1 |
| gbk | GBK Simplified Chinese | gbk_chinese_ci | 2 |
| latin5 | ISO 8859-9 Turkish | latin5_turkish_ci | 1 |
| armscii8 | ARMSCII-8 Armenian | armscii8_general_ci | 1 |
| utf8 | UTF-8 Unicode | utf8_general_ci | 3 |
| ucs2 | UCS-2 Unicode | ucs2_general_ci | 2 |
| cp866 | DOS Russian | cp866_general_ci | 1 |
| keybcs2 | DOS Kamenicky Czech-Slovak | keybcs2_general_ci | 1 |
| macce | Mac Central European | macce_general_ci | 1 |
| macroman | Mac West European | macroman_general_ci | 1 |
| cp852 | DOS Central European | cp852_general_ci | 1 |
| latin7 | ISO 8859-13 Baltic | latin7_general_ci | 1 |
| utf8mb4 | UTF-8 Unicode | utf8mb4_general_ci | 4 |
| cp1251 | Windows Cyrillic | cp1251_general_ci | 1 |
| utf16 | UTF-16 Unicode | utf16_general_ci | 4 |
| cp1256 | Windows Arabic | cp1256_general_ci | 1 |
| cp1257 | Windows Baltic | cp1257_general_ci | 1 |
| utf32 | UTF-32 Unicode | utf32_general_ci | 4 |
| binary | Binary pseudo charset | binary | 1 |
| geostd8 | GEOSTD8 Georgian | geostd8_general_ci | 1 |
| cp932 | SJIS for Windows Japanese | cp932_japanese_ci | 2 |
| eucjpms | UJIS for Windows Japanese | eucjpms_japanese_ci | 3 |
+----------+-----------------------------+---------------------+--------+
39 rows in set (0.00 sec)
mysql> show tables;
+-----------------+
| Tables_in_ssbit |
+-----------------+
| 专利 |
| 专著 |
| 论文 |
| 软件著作权 |
| 进出款 |
+-----------------+
5 rows in set (0.04 sec)
mysql> desc 进出款
-> ;
-> ;
Empty set (0.06 sec)
mysql> desc 进出款;
+------------+------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+------------+------------------+------+-----+---------+-------+
| 进出款ID | int(10) unsigned | NO | PRI | 0 | |
| 进出款时间 | datetime | NO | | NULL | |
| 进出款属性 | tinyint(1) | NO | | NULL | |
| 金额 | double | NO | | NULL | |
+------------+------------------+------+-----+---------+-------+
4 rows in set (0.01 sec)
mysql> insert into 进出款 values(2095,20121224120000,0,1000.00);
Query OK, 1 row affected (0.09 sec)
mysql> select * from 进出款;
-> ;
ERROR 1146 (42S02): Table 'ssbit.进出款;' doesn't exist
mysql> select * from 进出款;
->
-> ;
->
-> ;
ERROR 1146 (42S02): Table 'ssbit.进出款;' doesn't exist
mysql> select * from 进出款;
+----------+---------------------+------------+------+
| 进出款ID | 进出款时间 | 进出款属性 | 金额 |
+----------+---------------------+------------+------+
| 2095 | 2012-12-24 12:00:00 | 0 | 1000 |
+----------+---------------------+------------+------+
1 row in set (0.00 sec)
mysql> select * from 进出款;
+----------+---------------------+------------+------+
| 进出款ID | 进出款时间 | 进出款属性 | 金额 |
+----------+---------------------+------------+------+
| 2095 | 2012-12-24 12:00:00 | | 1000 |
+----------+---------------------+------------+------+
1 row in set (0.00 sec)
mysql> alter table 进出款 delete where 进出款ID=2095;
-> ;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the r
ight syntax to use near 'delete where 进出款ID=2095;' at line 1
mysql> alter table 进出款 delete where 进出款ID=2095;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the r
ight syntax to use near 'delete where 进出款ID=2095' at line 1
mysql> delete from 进出款 where 进出款ID='2095';
Query OK, 1 row affected (0.11 sec)
mysql> select * from 进出款;
Empty set (0.00 sec)
mysql> insert into 进出款 values(2095, 20121224120000, 0, 10000);
Query OK, 1 row affected, 1 warning (0.07 sec)
mysql> select * from 进出款;
+----------+---------------------+------------+-------+
| 进出款ID | 进出款时间 | 进出款属性 | 金额 |
+----------+---------------------+------------+-------+
| 2095 | 2012-12-24 12:00:00 | | 10000 |
+----------+---------------------+------------+-------+
1 row in set (0.00 sec)
mysql> insert into 进出款 values(2095, 20121224120000, '进款', 10000);
ERROR 1062 (23000): Duplicate entry '2095' for key 'PRIMARY'
mysql> insert into 进出款 values(2096, 20121224120000, '进款', 10000);
Query OK, 1 row affected (0.04 sec)
mysql> select * from 进出款;
-> ;
ERROR 1146 (42S02): Table 'ssbit.进出款;' doesn't exist
mysql> select * from 进出款;
+----------+---------------------+------------+-------+
| 进出款ID | 进出款时间 | 进出款属性 | 金额 |
+----------+---------------------+------------+-------+
| 2095 | 2012-12-24 12:00:00 | | 10000 |
| 2096 | 2012-12-24 12:00:00 | 进款 | 10000 |
+----------+---------------------+------------+-------+
2 rows in set (0.00 sec)
mysql> show tables;
+-----------------+
| Tables_in_ssbit |
+-----------------+
| 专利 |
| 专著 |
| 论文 |
| 软件著作权 |
| 进出款 |
+-----------------+
5 rows in set (0.00 sec)
mysql> desc 专利;
-> ;
ERROR 1017 (HY000): Can't find file: '.\ssbit\@4e13@5229@ff1b.frm' (errno: 22)
mysql> desc 专利;
+------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+------------+-------------+------+-----+---------+-------+
| 专利成果ID | varchar(50) | NO | PRI | NULL | |
| 授权号 | varchar(50) | NO | | NULL | |
| 专利名称 | varchar(50) | NO | | NULL | |
| 持有人 | varchar(20) | NO | | NULL | |
| 申请号 | varchar(20) | NO | | NULL | |
| 公告日 | date | NO | | NULL | |
| 申请日 | date | NO | | NULL | |
+------------+-------------+------+-----+---------+-------+
7 rows in set (0.02 sec)
mysql> insert into 专利 values('1120102000', 'SSBIT082110022095', 'SSBIT科研管理系统', 'kiwi95', 'kiwi2095', 20121224220000,201212
24000000);
Query OK, 1 row affected, 1 warning (0.06 sec)
mysql> select * from 专利;
+------------+-------------------+-------------------+--------+----------+------------+------------+
| 专利成果ID | 授权号 | 专利名称 | 持有人 | 申请号 | 公告日 | 申请日 |
+------------+-------------------+-------------------+--------+----------+------------+------------+
| 1120102000 | SSBIT082110022095 | SSBIT科研管理系统 | kiwi95 | kiwi2095 | 2012-12-24 | 2012-12-24 |
+------------+-------------------+-------------------+--------+----------+------------+------------+
1 row in set (0.00 sec)
mysql> show tables;
+-----------------+
| Tables_in_ssbit |
+-----------------+
| 专利 |
| 专著 |
| 论文 |
| 软件著作权 |
| 进出款 |
+-----------------+
5 rows in set (0.00 sec)
mysql> desc 专著;
+----------+------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+----------+------------------+------+-----+---------+-------+
| 成果ID | varchar(20) | NO | PRI | NULL | |
| 专著名称 | varchar(50) | NO | | NULL | |
| 主编 | varchar(20) | NO | | NULL | |
| 编写人员 | varchar(50) | NO | | NULL | |
| 出版单位 | varchar(50) | NO | | NULL | |
| 字数 | int(10) unsigned | NO | | NULL | |
| 出版时间 | datetime | NO | | NULL | |
| 备注 | text | NO | | NULL | |
| 材料提供 | text | NO | | NULL | |
+----------+------------------+------+-----+---------+-------+
9 rows in set (0.01 sec)
mysql> insert into 专著 values( 'SSBIT001', '北理工科研管理系统', '单纯', '**', 'SSBIT', '10000', 20121224000000,'数据库设计','
材料由北提供');
Query OK, 1 row affected (0.08 sec)
mysql> select * from 专著;
+----------+--------------------+------+----------+----------+-------+---------------------+------------+-------------------------
-+
| 成果ID | 专著名称 | 主编 | 编写人员 | 出版单位 | 字数 | 出版时间 | 备注 | 材料提供
|
+----------+--------------------+------+----------+----------+-------+---------------------+------------+-------------------------
-+
| SSBIT001 | 北理工科研管理系统 | 单纯 | ** | SSBIT | 10000 | 2012-12-24 00:00:00 | 数据库设计 | 材料由北提供
|
+----------+--------------------+------+----------+----------+-------+---------------------+------------+-------------------------
-+
1 row in set (0.00 sec)
mysql> show tables;
+-----------------+
| Tables_in_ssbit |
+-----------------+
| 专利 |
| 专著 |
| 论文 |
| 软件著作权 |
| 进出款 |
+-----------------+
5 rows in set (0.00 sec)
mysql> desc 论文;
+------------+------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+------------+------------------+------+-----+---------+-------+
| 论文成果ID | varchar(50) | NO | PRI | NULL | |
| 刊名 | varchar(50) | NO | | NULL | |
| 第一作者 | varchar(20) | NO | | NULL | |
| 第二作者 | varchar(20) | NO | | NULL | |
| 卷 | varchar(20) | NO | | NULL | |
| 期 | varchar(20) | NO | | NULL | |
| 页 | int(10) unsigned | NO | | NULL | |
| 备注 | text | NO | | NULL | |
| 材料提供 | text | NO | | NULL | |
+------------+------------------+------+-----+---------+-------+
9 rows in set (0.01 sec)
mysql> insert into 论文 values('DB20121224', '北京理工大学学报', 'WUXU', null, 'VOL1', 'TERM1', 'PAGE1','数据库系统原理','SSBIT');
ERROR 1048 (23000): Column '第二作者' cannot be null
mysql> insert into 论文 values('DB20121224', '北京理工大学学报', 'WUXU', '无', 'VOL1', 'TERM1', 'PAGE1','数据库系统原理','SSBIT');
Query OK, 1 row affected, 1 warning (0.04 sec)
mysql> select * from 论文;
+------------+------------------+----------+----------+------+-------+----+----------------+----------+
| 论文成果ID | 刊名 | 第一作者 | 第二作者 | 卷 | 期 | 页 | 备注 | 材料提供 |
+------------+------------------+----------+----------+------+-------+----+----------------+----------+
| DB20121224 | 北京理工大学学报 | WUXU | 无 | VOL1 | TERM1 | 0 | 数据库系统原理 | SSBIT |
+------------+------------------+----------+----------+------+-------+----+----------------+----------+
1 row in set (0.00 sec)
mysql> show tables;
+-----------------+
| Tables_in_ssbit |
+-----------------+
| 专利 |
| 专著 |
| 论文 |
| 软件著作权 |
| 进出款 |
+-----------------+
5 rows in set (0.00 sec)
mysql> select * from 软件著作权;
Empty set (0.00 sec)
mysql> insert into 软件著作权 values();
Query OK, 1 row affected, 5 warnings (0.07 sec)
mysql> select * from 软件著作权;
+--------+--------+----------+----------+--------------+
| 成果ID | 登记号 | 软件名称 | 著作权人 | 首次发表日期 |
+--------+--------+----------+----------+--------------+
| | | | | 0000-00-00 |
+--------+--------+----------+----------+--------------+
1 row in set (0.00 sec)
mysql> select from 软件著作权;
-> ;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the r
ight syntax to use near 'from 软件著作权;' at line 1
mysql> select from 软件著作权;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the r
ight syntax to use near 'from 软件著作权' at line 1
mysql> delete from 软件著作权;
Query OK, 1 row affected (0.06 sec)
mysql> select * from 软件著作权;
Empty set (0.00 sec)
mysql> insert into 软件著作权 values('SSBIT000001', 'SSBIT0000000001', '科研管理系统', 'kiwi95', '20121224');
Query OK, 1 row affected (0.06 sec)
mysql> select * from 软件著作权;
+-------------+-----------------+--------------+----------+--------------+
| 成果ID | 登记号 | 软件名称 | 著作权人 | 首次发表日期 |
+-------------+-----------------+--------------+----------+--------------+
| SSBIT000001 | SSBIT0000000001 | 科研管理系统 | kiwi95 | 2012-12-24 |
+-------------+-----------------+--------------+----------+--------------+
1 row in set (0.01 sec)
mysql> show tables;
+-----------------+
| Tables_in_ssbit |
+-----------------+
| 专利 |
| 专著 |
| 论文 |
| 软件著作权 |
| 进出款 |
+-----------------+
5 rows in set (0.00 sec)
mysql> desc 专利:
-> ;
ERROR 1017 (HY000): Can't find file: '.\ssbit\@4e13@5229@ff1a.frm' (errno: 22)
mysql> desc 专利;
+------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+------------+-------------+------+-----+---------+-------+
| 专利成果ID | varchar(50) | NO | PRI | NULL | |
| 授权号 | varchar(50) | NO | | NULL | |
| 专利名称 | varchar(50) | NO | | NULL | |
| 持有人 | varchar(20) | NO | | NULL | |
| 申请号 | varchar(20) | NO | | NULL | |
| 公告日 | date | NO | | NULL | |
| 申请日 | date | NO | | NULL | |
+------------+-------------+------+-----+---------+-------+
7 rows in set (0.01 sec)
mysql> select * from 专利;
+------------+-------------------+-------------------+--------+----------+------------+------------+
| 专利成果ID | 授权号 | 专利名称 | 持有人 | 申请号 | 公告日 | 申请日 |
+------------+-------------------+-------------------+--------+----------+------------+------------+
| 1120102000 | SSBIT082110022095 | SSBIT科研管理系统 | kiwi95 | kiwi2095 | 2012-12-24 | 2012-12-24 |
+------------+-------------------+-------------------+--------+----------+------------+------------+
1 row in set (0.00 sec)
mysql> desc 专著;
+----------+------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+----------+------------------+------+-----+---------+-------+
| 成果ID | varchar(20) | NO | PRI | NULL | |
| 专著名称 | varchar(50) | NO | | NULL | |
| 主编 | varchar(20) | NO | | NULL | |
| 编写人员 | varchar(50) | NO | | NULL | |
| 出版单位 | varchar(50) | NO | | NULL | |
| 字数 | int(10) unsigned | NO | | NULL | |
| 出版时间 | datetime | NO | | NULL | |
| 备注 | text | NO | | NULL | |
| 材料提供 | text | NO | | NULL | |
+----------+------------------+------+-----+---------+-------+
9 rows in set (0.01 sec)
mysql> alter table 专著 modify 出版时间 date;
Query OK, 1 row affected (0.22 sec)
Records: 1 Duplicates: 0 Warnings: 0
mysql> desc 专著;
+----------+------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+----------+------------------+------+-----+---------+-------+
| 成果ID | varchar(20) | NO | PRI | NULL | |
| 专著名称 | varchar(50) | NO | | NULL | |
| 主编 | varchar(20) | NO | | NULL | |
| 编写人员 | varchar(50) | NO | | NULL | |
| 出版单位 | varchar(50) | NO | | NULL | |
| 字数 | int(10) unsigned | NO | | NULL | |
| 出版时间 | date | YES | | NULL | |
| 备注 | text | NO | | NULL | |
| 材料提供 | text | NO | | NULL | |
+----------+------------------+------+-----+---------+-------+
9 rows in set (0.01 sec)
mysql> select * from 专著;
+----------+--------------------+------+----------+----------+-------+------------+------------+--------------------------+
| 成果ID | 专著名称 | 主编 | 编写人员 | 出版单位 | 字数 | 出版时间 | 备注 | 材料提供 |
+----------+--------------------+------+----------+----------+-------+------------+------------+--------------------------+
| SSBIT001 | 北理工科研管理系统 | 单纯 | ** | SSBIT | 10000 | 2012-12-24 | 数据库设计 | 材料由北提供 |
+----------+--------------------+------+----------+----------+-------+------------+------------+--------------------------+
1 row in set (0.00 sec)
mysql> desc 论文;
+------------+------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+------------+------------------+------+-----+---------+-------+
| 论文成果ID | varchar(50) | NO | PRI | NULL | |
| 刊名 | varchar(50) | NO | | NULL | |
| 第一作者 | varchar(20) | NO | | NULL | |
| 第二作者 | varchar(20) | NO | | NULL | |
| 卷 | varchar(20) | NO | | NULL | |
| 期 | varchar(20) | NO | | NULL | |
| 页 | int(10) unsigned | NO | | NULL | |
| 备注 | text | NO | | NULL | |
| 材料提供 | text | NO | | NULL | |
+------------+------------------+------+-----+---------+-------+
9 rows in set (0.01 sec)
mysql> desc 进出款;
+------------+---------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+------------+---------------------+------+-----+---------+-------+
| 进出款ID | int(10) unsigned | NO | PRI | 0 | |
| 进出款时间 | datetime | NO | | NULL | |
| 进出款属性 | enum('进款','出款') | NO | | NULL | |
| 金额 | double | NO | | NULL | |
+------------+---------------------+------+-----+---------+-------+
4 rows in set (0.01 sec)
mysql> insert into 进出款 values('SSBIT20121224', '201212241200', '出款', 1234567.890);
Query OK, 1 row affected, 2 warnings (0.06 sec)
mysql> select * from 进出款;
+----------+---------------------+------------+------------+
| 进出款ID | 进出款时间 | 进出款属性 | 金额 |
+----------+---------------------+------------+------------+
| 0 | 0000-00-00 00:00:00 | 出款 | 1234567.89 |
| 2095 | 2012-12-24 12:00:00 | | 10000 |
| 2096 | 2012-12-24 12:00:00 | 进款 | 10000 |
+----------+---------------------+------------+------------+
3 rows in set (0.00 sec)
mysql> select from 进出款 where 进出款ID=0;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the r
ight syntax to use near 'from 进出款 where 进出款ID=0' at line 1
mysql> delete from 进出款 where 进出款ID=0;
Query OK, 1 row affected (0.07 sec)
mysql> select * from 进出款;
+----------+---------------------+------------+-------+
| 进出款ID | 进出款时间 | 进出款属性 | 金额 |
+----------+---------------------+------------+-------+
| 2095 | 2012-12-24 12:00:00 | | 10000 |
| 2096 | 2012-12-24 12:00:00 | 进款 | 10000 |
+----------+---------------------+------------+-------+
2 rows in set (0.00 sec)
mysql> update 进出款 set 进出款属性='进款' where 进出款ID=2095;
Query OK, 1 row affected (0.05 sec)
Rows matched: 1 Changed: 1 Warnings: 0
mysql> select * from 进出款;
+----------+---------------------+------------+-------+
| 进出款ID | 进出款时间 | 进出款属性 | 金额 |
+----------+---------------------+------------+-------+
| 2095 | 2012-12-24 12:00:00 | 进款 | 10000 |
| 2096 | 2012-12-24 12:00:00 | 进款 | 10000 |
+----------+---------------------+------------+-------+
2 rows in set (0.00 sec)
mysql> insert into 进出款 values(20121224, '201212241200', '出款', 1234567.890);
Query OK, 1 row affected, 1 warning (0.06 sec)
mysql> select * from 进出款;
+----------+---------------------+------------+------------+
| 进出款ID | 进出款时间 | 进出款属性 | 金额 |
+----------+---------------------+------------+------------+
| 2095 | 2012-12-24 12:00:00 | 进款 | 10000 |
| 2096 | 2012-12-24 12:00:00 | 进款 | 10000 |
| 20121224 | 0000-00-00 00:00:00 | 出款 | 1234567.89 |
+----------+---------------------+------------+------------+
3 rows in set (0.00 sec)
mysql> select * from 专利;
+------------+-------------------+-------------------+--------+----------+------------+------------+
| 专利成果ID | 授权号 | 专利名称 | 持有人 | 申请号 | 公告日 | 申请日 |
+------------+-------------------+-------------------+--------+----------+------------+------------+
| 1120102000 | SSBIT082110022095 | SSBIT科研管理系统 | kiwi95 | kiwi2095 | 2012-12-24 | 2012-12-24 |
+------------+-------------------+-------------------+--------+----------+------------+------------+
1 row in set (0.00 sec)
mysql> select * from 论文;
+------------+------------------+----------+----------+------+-------+----+----------------+----------+
| 论文成果ID | 刊名 | 第一作者 | 第二作者 | 卷 | 期 | 页 | 备注 | 材料提供 |
+------------+------------------+----------+----------+------+-------+----+----------------+----------+
| DB20121224 | 北京理工大学学报 | WUXU | 无 | VOL1 | TERM1 | 0 | 数据库系统原理 | SSBIT |
+------------+------------------+----------+----------+------+-------+----+----------------+----------+
1 row in set (0.00 sec)
mysql> selcet * from 软件著作权;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the r
ight syntax to use near 'selcet * from 软件著作权' at line 1
mysql> select * from 软件著作权;
+-------------+-----------------+--------------+----------+--------------+
| 成果ID | 登记号 | 软件名称 | 著作权人 | 首次发表日期 |
+-------------+-----------------+--------------+----------+--------------+
| SSBIT000001 | SSBIT0000000001 | 科研管理系统 | kiwi95 | 2012-12-24 |
+-------------+-----------------+--------------+----------+--------------+
1 row in set (0.00 sec)
mysql> select * from 专著;
+----------+--------------------+------+----------+----------+-------+------------+------------+--------------------------+
| 成果ID | 专著名称 | 主编 | 编写人员 | 出版单位 | 字数 | 出版时间 | 备注 | 材料提供 |
+----------+--------------------+------+----------+----------+-------+------------+------------+--------------------------+
| SSBIT001 | 北理工科研管理系统 | 单纯 | ** | SSBIT | 10000 | 2012-12-24 | 数据库设计 | 材料由北提供 |
+----------+--------------------+------+----------+----------+-------+------------+------------+--------------------------+
1 row in set (0.00 sec)
mysql>