生活随笔
收集整理的這篇文章主要介紹了
MySQL Commons
小編覺得挺不錯的,現在分享給大家,幫大家做個參考.
2019獨角獸企業重金招聘Python工程師標準>>>
mysqldump?
Usage:?mysqldump?[OPTIONS]?database?[tables]
OR?????mysqldump?[OPTIONS]?--databases?[OPTIONS]?DB1?[DB2?DB3...]
OR?????mysqldump?[OPTIONS]?--all-databases?[OPTIONS]
mysql>?create??table?t_test?(?i?int?primary?key?auto_increment?,?j?int?,?k?int?)?;
Query?OK,?0?rows?affected?(0.15?sec)mysql>?
mysql>?
mysql>?insert??into??t_test?values(1,1,1)?ON?DUPLICATE?KEY?UPDATE?j?=?j+1?,?k=k+1?;
Query?OK,?1?row?affected?(0.21?sec)mysql>?
mysql>?insert??into??t_test?values(1,1,1)?ON?DUPLICATE?KEY?UPDATE?j?=?j+1?,?k=k+1?;
Query?OK,?2?rows?affected?(0.04?sec)mysql>?select?*?from?t_test?;
+---+------+------+
|?i?|?j????|?k????|
+---+------+------+
|?1?|????2?|????2?|
+---+------+------+
1?row?in?set?(0.00?sec)mysql>?insert??into??t_test?values(1,1,1)?ON?DUPLICATE?KEY?UPDATE?j?=?j+1?,?k=k+1?;
Query?OK,?2?rows?affected?(0.00?sec)mysql>?select?*?from?t_test?;
+---+------+------+
|?i?|?j????|?k????|
+---+------+------+
|?1?|????3?|????3?|
+---+------+------+
1?row?in?set?(0.00?sec)
建立連接的時候指定?useUnicode=true ?characterEncoding=utf-8 參數可防止亂碼
轉載于:https://my.oschina.net/darionyaphet/blog/226470
總結
以上是生活随笔為你收集整理的MySQL Commons的全部內容，希望文章能夠幫你解決所遇到的問題。
如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。
