無意義的存在，只是記錄學習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>
更多文章、技術交流、商務合作、聯系博主
微信掃碼或搜索：z360901061
微信掃一掃加我為好友
QQ號聯系： 360901061
您的支持是博主寫作最大的動力，如果您喜歡我的文章，感覺我的文章對您有幫助，請用微信掃描下面二維碼支持博主2元、5元、10元、20元等您想捐的金額吧，狠狠點擊下面給點支持吧，站長非常感激您！手機微信長按不能支付解決辦法：請將微信支付二維碼保存到相冊，切換到微信，然后點擊微信右上角掃一掃功能，選擇支付二維碼完成支付。
【本文對您有幫助就好】元
