mysql-hlocalhost-uroot-pEnterpassword:****WelcometotheMySQLmonitor.Commandsendwith;or\g.YourMySQLconnectionidis29Serverversion:5.5.16My" />

亚洲免费在线-亚洲免费在线播放-亚洲免费在线观看-亚洲免费在线观看视频-亚洲免费在线看-亚洲免费在线视频

熟悉MySQL數(shù)據(jù)庫(kù)操作

系統(tǒng) 1845 0
      無(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>

熟悉MySQL數(shù)據(jù)庫(kù)操作


更多文章、技術(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ì)您有幫助就好】

您的支持是博主寫作最大的動(dòng)力,如果您喜歡我的文章,感覺(jué)我的文章對(duì)您有幫助,請(qǐng)用微信掃描上面二維碼支持博主2元、5元、10元、自定義金額等您想捐的金額吧,站長(zhǎng)會(huì)非常 感謝您的哦!!!

發(fā)表我的評(píng)論
最新評(píng)論 總共0條評(píng)論
主站蜘蛛池模板: 黄片毛片免费在线观看 | 99久久99久久 | 最新99国产成人精品视频免费 | 精品综合久久久久97 | 国语自产偷拍精品视频偷最新 | 亚洲产在线精品第一站不卡 | 在线欧美激情 | 四虎免费入口 | 日本在线亚州精品视频在线 | 中文字幕 日韩有码 | 欧美国产日韩在线播放 | 日韩精品影视 | 日韩在线色 | 亚洲美女在线视频 | 久久老色鬼天天综合网观看 | 精品视频一二三区 | 免费观看日本a毛片 | 午夜在线社区视频 | 午夜日韩视频 | 毛片免费在线观看 | 四虎影院在线观看免费 | 四虎在线网站 | 麻豆精品成人免费国产片 | 狠狠亚洲丁香综合久久 | 免费一级黄色录像 | 午夜在线视频网站 | 国产成人一区二区三区 | 国产羞羞视频在线播放 | 久久精品一区二区三区日韩 | 久久综合视频网 | 成人在线精品视频 | 国内精品久久久久久久久久久久 | 欧美日韩中文在线观看 | 亚洲国产精品久久久久久 | 高清国产精品久久久久 | 奇米第四777 | 欧美末成年videos在线观看 | 中文字幕日韩一区二区三区不 | 91久久精品国产免费一区 | 91精品国产品国语在线不卡 | 香蕉午夜|