無(wú)意義的存在，只是記錄學(xué)習(xí)MySQL的經(jīng)歷：）
Windows PowerShell
版權(quán)所有 (C) 2009 Microsoft Corporation。保留所有權(quán)利。
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 |
+-----------------+
| 專利 |
| 專著 |
| 論文 |
| 軟件著作權(quán) |
| 進(jìn)出款 |
+-----------------+
5 rows in set (0.04 sec)
mysql> desc 進(jìn)出款
-> ；
-> ;
Empty set (0.06 sec)
mysql> desc 進(jìn)出款;
+------------+------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+------------+------------------+------+-----+---------+-------+
| 進(jìn)出款I(lǐng)D | int(10) unsigned | NO | PRI | 0 | |
| 進(jìn)出款時(shí)間 | datetime | NO | | NULL | |
| 進(jìn)出款屬性 | tinyint(1) | NO | | NULL | |
| 金額 | double | NO | | NULL | |
+------------+------------------+------+-----+---------+-------+
4 rows in set (0.01 sec)
mysql> insert into 進(jìn)出款 values(2095,20121224120000,0,1000.00);
Query OK, 1 row affected (0.09 sec)
mysql> select * from 進(jìn)出款；
-> ;
ERROR 1146 (42S02): Table 'ssbit.進(jìn)出款；' doesn't exist
mysql> select * from 進(jìn)出款；
->
-> ；
->
-> ;
ERROR 1146 (42S02): Table 'ssbit.進(jìn)出款；' doesn't exist
mysql> select * from 進(jìn)出款;
+----------+---------------------+------------+------+
| 進(jìn)出款I(lǐng)D | 進(jìn)出款時(shí)間 | 進(jìn)出款屬性 | 金額 |
+----------+---------------------+------------+------+
| 2095 | 2012-12-24 12:00:00 | 0 | 1000 |
+----------+---------------------+------------+------+
1 row in set (0.00 sec)
mysql> select * from 進(jìn)出款;
+----------+---------------------+------------+------+
| 進(jìn)出款I(lǐng)D | 進(jìn)出款時(shí)間 | 進(jìn)出款屬性 | 金額 |
+----------+---------------------+------------+------+
| 2095 | 2012-12-24 12:00:00 | | 1000 |
+----------+---------------------+------------+------+
1 row in set (0.00 sec)
mysql> alter table 進(jìn)出款 delete where 進(jìn)出款I(lǐng)D=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 進(jìn)出款I(lǐng)D=2095；' at line 1
mysql> alter table 進(jìn)出款 delete where 進(jìn)出款I(lǐng)D=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 進(jìn)出款I(lǐng)D=2095' at line 1
mysql> delete from 進(jìn)出款 where 進(jìn)出款I(lǐng)D='2095';
Query OK, 1 row affected (0.11 sec)
mysql> select * from 進(jìn)出款;
Empty set (0.00 sec)
mysql> insert into 進(jìn)出款 values(2095, 20121224120000, 0, 10000);
Query OK, 1 row affected, 1 warning (0.07 sec)
mysql> select * from 進(jìn)出款;
+----------+---------------------+------------+-------+
| 進(jìn)出款I(lǐng)D | 進(jìn)出款時(shí)間 | 進(jìn)出款屬性 | 金額 |
+----------+---------------------+------------+-------+
| 2095 | 2012-12-24 12:00:00 | | 10000 |
+----------+---------------------+------------+-------+
1 row in set (0.00 sec)
mysql> insert into 進(jìn)出款 values(2095, 20121224120000, '進(jìn)款', 10000);
ERROR 1062 (23000): Duplicate entry '2095' for key 'PRIMARY'
mysql> insert into 進(jìn)出款 values(2096, 20121224120000, '進(jìn)款', 10000);
Query OK, 1 row affected (0.04 sec)
mysql> select * from 進(jìn)出款；
-> ;
ERROR 1146 (42S02): Table 'ssbit.進(jìn)出款；' doesn't exist
mysql> select * from 進(jìn)出款;
+----------+---------------------+------------+-------+
| 進(jìn)出款I(lǐng)D | 進(jìn)出款時(shí)間 | 進(jìn)出款屬性 | 金額 |
+----------+---------------------+------------+-------+
| 2095 | 2012-12-24 12:00:00 | | 10000 |
| 2096 | 2012-12-24 12:00:00 | 進(jìn)款 | 10000 |
+----------+---------------------+------------+-------+
2 rows in set (0.00 sec)
mysql> show tables;
+-----------------+
| Tables_in_ssbit |
+-----------------+
| 專利 |
| 專著 |
| 論文 |
| 軟件著作權(quán) |
| 進(jìn)出款 |
+-----------------+
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 | |
| 授權(quán)號(hào) | varchar(50) | NO | | NULL | |
| 專利名稱 | varchar(50) | NO | | NULL | |
| 持有人 | varchar(20) | NO | | NULL | |
| 申請(qǐng)?zhí)? | varchar(20) | NO | | NULL | |
| 公告日 | date | NO | | NULL | |
| 申請(qǐng)日 | date | NO | | NULL | |
+------------+-------------+------+-----+---------+-------+
7 rows in set (0.02 sec)
mysql> insert into 專利 values('1120102000', 'SSBIT082110022095', 'SSBIT科研管理系統(tǒng)', 'kiwi95', 'kiwi2095', 20121224220000,201212
24000000);
Query OK, 1 row affected, 1 warning (0.06 sec)
mysql> select * from 專利;
+------------+-------------------+-------------------+--------+----------+------------+------------+
| 專利成果ID | 授權(quán)號(hào) | 專利名稱 | 持有人 | 申請(qǐng)?zhí)? | 公告日 | 申請(qǐng)日 |
+------------+-------------------+-------------------+--------+----------+------------+------------+
| 1120102000 | SSBIT082110022095 | SSBIT科研管理系統(tǒng) | kiwi95 | kiwi2095 | 2012-12-24 | 2012-12-24 |
+------------+-------------------+-------------------+--------+----------+------------+------------+
1 row in set (0.00 sec)
mysql> show tables;
+-----------------+
| Tables_in_ssbit |
+-----------------+
| 專利 |
| 專著 |
| 論文 |
| 軟件著作權(quán) |
| 進(jìn)出款 |
+-----------------+
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 | |
| 字?jǐn)?shù) | int(10) unsigned | NO | | NULL | |
| 出版時(shí)間 | datetime | NO | | NULL | |
| 備注 | text | NO | | NULL | |
| 材料提供 | text | NO | | NULL | |
+----------+------------------+------+-----+---------+-------+
9 rows in set (0.01 sec)
mysql> insert into 專著 values( 'SSBIT001', '北理工科研管理系統(tǒng)', '單純', '**', 'SSBIT', '10000', 20121224000000,'數(shù)據(jù)庫(kù)設(shè)計(jì)','
材料由北提供');
Query OK, 1 row affected (0.08 sec)
mysql> select * from 專著;
+----------+--------------------+------+----------+----------+-------+---------------------+------------+-------------------------
-+
| 成果ID | 專著名稱 | 主編 | 編寫人員 | 出版單位 | 字?jǐn)?shù) | 出版時(shí)間 | 備注 | 材料提供
|
+----------+--------------------+------+----------+----------+-------+---------------------+------------+-------------------------
-+
| SSBIT001 | 北理工科研管理系統(tǒng) | 單純 | ** | SSBIT | 10000 | 2012-12-24 00:00:00 | 數(shù)據(jù)庫(kù)設(shè)計(jì) | 材料由北提供
|
+----------+--------------------+------+----------+----------+-------+---------------------+------------+-------------------------
-+
1 row in set (0.00 sec)
mysql> show tables;
+-----------------+
| Tables_in_ssbit |
+-----------------+
| 專利 |
| 專著 |
| 論文 |
| 軟件著作權(quán) |
| 進(jìn)出款 |
+-----------------+
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 | |
| 頁(yè) | int(10) unsigned | NO | | NULL | |
| 備注 | text | NO | | NULL | |
| 材料提供 | text | NO | | NULL | |
+------------+------------------+------+-----+---------+-------+
9 rows in set (0.01 sec)
mysql> insert into 論文 values('DB20121224', '北京理工大學(xué)學(xué)報(bào)', 'WUXU', null, 'VOL1', 'TERM1', 'PAGE1','數(shù)據(jù)庫(kù)系統(tǒng)原理','SSBIT');
ERROR 1048 (23000): Column '第二作者' cannot be null
mysql> insert into 論文 values('DB20121224', '北京理工大學(xué)學(xué)報(bào)', 'WUXU', '無(wú)', 'VOL1', 'TERM1', 'PAGE1','數(shù)據(jù)庫(kù)系統(tǒng)原理','SSBIT');
Query OK, 1 row affected, 1 warning (0.04 sec)
mysql> select * from 論文;
+------------+------------------+----------+----------+------+-------+----+----------------+----------+
| 論文成果ID | 刊名 | 第一作者 | 第二作者 | 卷 | 期 | 頁(yè) | 備注 | 材料提供 |
+------------+------------------+----------+----------+------+-------+----+----------------+----------+
| DB20121224 | 北京理工大學(xué)學(xué)報(bào) | WUXU | 無(wú) | VOL1 | TERM1 | 0 | 數(shù)據(jù)庫(kù)系統(tǒng)原理 | SSBIT |
+------------+------------------+----------+----------+------+-------+----+----------------+----------+
1 row in set (0.00 sec)
mysql> show tables;
+-----------------+
| Tables_in_ssbit |
+-----------------+
| 專利 |
| 專著 |
| 論文 |
| 軟件著作權(quán) |
| 進(jìn)出款 |
+-----------------+
5 rows in set (0.00 sec)
mysql> select * from 軟件著作權(quán);
Empty set (0.00 sec)
mysql> insert into 軟件著作權(quán) values();
Query OK, 1 row affected, 5 warnings (0.07 sec)
mysql> select * from 軟件著作權(quán);
+--------+--------+----------+----------+--------------+
| 成果ID | 登記號(hào) | 軟件名稱 | 著作權(quán)人 | 首次發(fā)表日期 |
+--------+--------+----------+----------+--------------+
| | | | | 0000-00-00 |
+--------+--------+----------+----------+--------------+
1 row in set (0.00 sec)
mysql> select from 軟件著作權(quán)；
-> ;
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 軟件著作權(quán)；' at line 1
mysql> select from 軟件著作權(quán);
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 軟件著作權(quán)' at line 1
mysql> delete from 軟件著作權(quán);
Query OK, 1 row affected (0.06 sec)
mysql> select * from 軟件著作權(quán);
Empty set (0.00 sec)
mysql> insert into 軟件著作權(quán) values('SSBIT000001', 'SSBIT0000000001', '科研管理系統(tǒng)', 'kiwi95', '20121224');
Query OK, 1 row affected (0.06 sec)
mysql> select * from 軟件著作權(quán);
+-------------+-----------------+--------------+----------+--------------+
| 成果ID | 登記號(hào) | 軟件名稱 | 著作權(quán)人 | 首次發(fā)表日期 |
+-------------+-----------------+--------------+----------+--------------+
| SSBIT000001 | SSBIT0000000001 | 科研管理系統(tǒng) | kiwi95 | 2012-12-24 |
+-------------+-----------------+--------------+----------+--------------+
1 row in set (0.01 sec)
mysql> show tables;
+-----------------+
| Tables_in_ssbit |
+-----------------+
| 專利 |
| 專著 |
| 論文 |
| 軟件著作權(quán) |
| 進(jìn)出款 |
+-----------------+
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 | |
| 授權(quán)號(hào) | varchar(50) | NO | | NULL | |
| 專利名稱 | varchar(50) | NO | | NULL | |
| 持有人 | varchar(20) | NO | | NULL | |
| 申請(qǐng)?zhí)? | varchar(20) | NO | | NULL | |
| 公告日 | date | NO | | NULL | |
| 申請(qǐng)日 | date | NO | | NULL | |
+------------+-------------+------+-----+---------+-------+
7 rows in set (0.01 sec)
mysql> select * from 專利;
+------------+-------------------+-------------------+--------+----------+------------+------------+
| 專利成果ID | 授權(quán)號(hào) | 專利名稱 | 持有人 | 申請(qǐng)?zhí)? | 公告日 | 申請(qǐng)日 |
+------------+-------------------+-------------------+--------+----------+------------+------------+
| 1120102000 | SSBIT082110022095 | SSBIT科研管理系統(tǒng) | 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 | |
| 字?jǐn)?shù) | int(10) unsigned | NO | | NULL | |
| 出版時(shí)間 | datetime | NO | | NULL | |
| 備注 | text | NO | | NULL | |
| 材料提供 | text | NO | | NULL | |
+----------+------------------+------+-----+---------+-------+
9 rows in set (0.01 sec)
mysql> alter table 專著 modify 出版時(shí)間 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 | |
| 字?jǐn)?shù) | int(10) unsigned | NO | | NULL | |
| 出版時(shí)間 | date | YES | | NULL | |
| 備注 | text | NO | | NULL | |
| 材料提供 | text | NO | | NULL | |
+----------+------------------+------+-----+---------+-------+
9 rows in set (0.01 sec)
mysql> select * from 專著;
+----------+--------------------+------+----------+----------+-------+------------+------------+--------------------------+
| 成果ID | 專著名稱 | 主編 | 編寫人員 | 出版單位 | 字?jǐn)?shù) | 出版時(shí)間 | 備注 | 材料提供 |
+----------+--------------------+------+----------+----------+-------+------------+------------+--------------------------+
| SSBIT001 | 北理工科研管理系統(tǒng) | 單純 | ** | SSBIT | 10000 | 2012-12-24 | 數(shù)據(jù)庫(kù)設(shè)計(jì) | 材料由北提供 |
+----------+--------------------+------+----------+----------+-------+------------+------------+--------------------------+
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 | |
| 頁(yè) | int(10) unsigned | NO | | NULL | |
| 備注 | text | NO | | NULL | |
| 材料提供 | text | NO | | NULL | |
+------------+------------------+------+-----+---------+-------+
9 rows in set (0.01 sec)
mysql> desc 進(jìn)出款;
+------------+---------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+------------+---------------------+------+-----+---------+-------+
| 進(jìn)出款I(lǐng)D | int(10) unsigned | NO | PRI | 0 | |
| 進(jìn)出款時(shí)間 | datetime | NO | | NULL | |
| 進(jìn)出款屬性 | enum('進(jìn)款','出款') | NO | | NULL | |
| 金額 | double | NO | | NULL | |
+------------+---------------------+------+-----+---------+-------+
4 rows in set (0.01 sec)
mysql> insert into 進(jìn)出款 values('SSBIT20121224', '201212241200', '出款', 1234567.890);
Query OK, 1 row affected, 2 warnings (0.06 sec)
mysql> select * from 進(jìn)出款;
+----------+---------------------+------------+------------+
| 進(jìn)出款I(lǐng)D | 進(jìn)出款時(shí)間 | 進(jìn)出款屬性 | 金額 |
+----------+---------------------+------------+------------+
| 0 | 0000-00-00 00:00:00 | 出款 | 1234567.89 |
| 2095 | 2012-12-24 12:00:00 | | 10000 |
| 2096 | 2012-12-24 12:00:00 | 進(jìn)款 | 10000 |
+----------+---------------------+------------+------------+
3 rows in set (0.00 sec)
mysql> select from 進(jìn)出款 where 進(jìn)出款I(lǐng)D=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 進(jìn)出款 where 進(jìn)出款I(lǐng)D=0' at line 1
mysql> delete from 進(jìn)出款 where 進(jìn)出款I(lǐng)D=0;
Query OK, 1 row affected (0.07 sec)
mysql> select * from 進(jìn)出款;
+----------+---------------------+------------+-------+
| 進(jìn)出款I(lǐng)D | 進(jìn)出款時(shí)間 | 進(jìn)出款屬性 | 金額 |
+----------+---------------------+------------+-------+
| 2095 | 2012-12-24 12:00:00 | | 10000 |
| 2096 | 2012-12-24 12:00:00 | 進(jìn)款 | 10000 |
+----------+---------------------+------------+-------+
2 rows in set (0.00 sec)
mysql> update 進(jìn)出款 set 進(jìn)出款屬性='進(jìn)款' where 進(jìn)出款I(lǐng)D=2095;
Query OK, 1 row affected (0.05 sec)
Rows matched: 1 Changed: 1 Warnings: 0
mysql> select * from 進(jìn)出款;
+----------+---------------------+------------+-------+
| 進(jìn)出款I(lǐng)D | 進(jìn)出款時(shí)間 | 進(jìn)出款屬性 | 金額 |
+----------+---------------------+------------+-------+
| 2095 | 2012-12-24 12:00:00 | 進(jìn)款 | 10000 |
| 2096 | 2012-12-24 12:00:00 | 進(jìn)款 | 10000 |
+----------+---------------------+------------+-------+
2 rows in set (0.00 sec)
mysql> insert into 進(jìn)出款 values(20121224, '201212241200', '出款', 1234567.890);
Query OK, 1 row affected, 1 warning (0.06 sec)
mysql> select * from 進(jìn)出款;
+----------+---------------------+------------+------------+
| 進(jìn)出款I(lǐng)D | 進(jìn)出款時(shí)間 | 進(jìn)出款屬性 | 金額 |
+----------+---------------------+------------+------------+
| 2095 | 2012-12-24 12:00:00 | 進(jìn)款 | 10000 |
| 2096 | 2012-12-24 12:00:00 | 進(jìn)款 | 10000 |
| 20121224 | 0000-00-00 00:00:00 | 出款 | 1234567.89 |
+----------+---------------------+------------+------------+
3 rows in set (0.00 sec)
mysql> select * from 專利;
+------------+-------------------+-------------------+--------+----------+------------+------------+
| 專利成果ID | 授權(quán)號(hào) | 專利名稱 | 持有人 | 申請(qǐng)?zhí)? | 公告日 | 申請(qǐng)日 |
+------------+-------------------+-------------------+--------+----------+------------+------------+
| 1120102000 | SSBIT082110022095 | SSBIT科研管理系統(tǒng) | kiwi95 | kiwi2095 | 2012-12-24 | 2012-12-24 |
+------------+-------------------+-------------------+--------+----------+------------+------------+
1 row in set (0.00 sec)
mysql> select * from 論文;
+------------+------------------+----------+----------+------+-------+----+----------------+----------+
| 論文成果ID | 刊名 | 第一作者 | 第二作者 | 卷 | 期 | 頁(yè) | 備注 | 材料提供 |
+------------+------------------+----------+----------+------+-------+----+----------------+----------+
| DB20121224 | 北京理工大學(xué)學(xué)報(bào) | WUXU | 無(wú) | VOL1 | TERM1 | 0 | 數(shù)據(jù)庫(kù)系統(tǒng)原理 | SSBIT |
+------------+------------------+----------+----------+------+-------+----+----------------+----------+
1 row in set (0.00 sec)
mysql> selcet * from 軟件著作權(quán);
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 軟件著作權(quán)' at line 1
mysql> select * from 軟件著作權(quán);
+-------------+-----------------+--------------+----------+--------------+
| 成果ID | 登記號(hào) | 軟件名稱 | 著作權(quán)人 | 首次發(fā)表日期 |
+-------------+-----------------+--------------+----------+--------------+
| SSBIT000001 | SSBIT0000000001 | 科研管理系統(tǒng) | kiwi95 | 2012-12-24 |
+-------------+-----------------+--------------+----------+--------------+
1 row in set (0.00 sec)
mysql> select * from 專著;
+----------+--------------------+------+----------+----------+-------+------------+------------+--------------------------+
| 成果ID | 專著名稱 | 主編 | 編寫人員 | 出版單位 | 字?jǐn)?shù) | 出版時(shí)間 | 備注 | 材料提供 |
+----------+--------------------+------+----------+----------+-------+------------+------------+--------------------------+
| SSBIT001 | 北理工科研管理系統(tǒng) | 單純 | ** | SSBIT | 10000 | 2012-12-24 | 數(shù)據(jù)庫(kù)設(shè)計(jì) | 材料由北提供 |
+----------+--------------------+------+----------+----------+-------+------------+------------+--------------------------+
1 row in set (0.00 sec)
mysql>
更多文章、技術(shù)交流、商務(wù)合作、聯(lián)系博主
微信掃碼或搜索：z360901061
微信掃一掃加我為好友
QQ號(hào)聯(lián)系： 360901061
您的支持是博主寫作最大的動(dòng)力，如果您喜歡我的文章，感覺(jué)我的文章對(duì)您有幫助，請(qǐng)用微信掃描下面二維碼支持博主2元、5元、10元、20元等您想捐的金額吧，狠狠點(diǎn)擊下面給點(diǎn)支持吧，站長(zhǎng)非常感激您！手機(jī)微信長(zhǎng)按不能支付解決辦法：請(qǐng)將微信支付二維碼保存到相冊(cè)，切換到微信，然后點(diǎn)擊微信右上角掃一掃功能，選擇支付二維碼完成支付。
【本文對(duì)您有幫助就好】元
