English | 正體中文 | 简体中文

SQL insert


范例资料表 : Songs (以下范例皆用此表当作资料来源)
Artist SongTitle SongPlayCount
Scott Mckenzie San Francisco 30
Kiss Detroit rock city 120
R.E.M. Losing my religion 256
Pink Try 97


Example
插入一笔新资料到 'Songs' 资料表里

Sytax : INSERT INTO table_name (col_name1, col_name2..) VALUES (value1, value2..)
SQL
INSERT INTO Songs(Artist, SongTitle, SongPlayCount) VALUES('Coldplay', 'Paradise', 0)

会输出结果
Artist SongTitle SongPlayCount
Scott Mckenzie San Francisco 30
Kiss Detroit rock city 120
R.E.M. Losing my religion 256
Pink Try 97
Coldplay Paradise 0


© 2012 PureExample.com contact