Fourth Woods Wiki

User Tools

Site Tools

Trace:
mysql

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
mysql [2013/04/17 03:16] – javapimpmysql [2023/08/18 18:15] (current) – external edit 127.0.0.1
Line 77: Line 77:
 <code sql> <code sql>
 mysql> alter table <table> drop index <index>; mysql> alter table <table> drop index <index>;
 +</code>
 +
 +====== Insert ======
 +
 +===== Insert or Update =====
 +
 +<code sql>
 +mysql> INSERT INTO <table> (field1, field2, field3) VALUES ('value1', 'value2','value3') ON DUPLICATE KEY UPDATE field1='value1', field2='value2', field3='value3';
 </code> </code>
  
mysql.1366168608.txt.gz · Last modified: 2023/08/18 18:15 (external edit)