 |
|
|
 |
 |
|
update _table_ set field_b = 'somsri' where field_a = 'suvit';
|
 |
 |
 |
 |
| Date :
2009-06-11 23:37:16 |
By :
plakrim |
|
 |
 |
 |
 |
|
|
 |
 |
|
 |
 |
| |
|
|
|
| |
|
มันขึ้นแบบนี้อ่ะครับ
ผิดพลาด
คำค้น SQL:
UPDATE _customer_ SET field_b = 'somsri',
'somying,'somchai,
'somjit' WHERE field_a = 'suvit'
MySQL แสดง:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''somying,'somchai,'somjit' where field_a = 'suvit'' at line 1
|
| |
|
|
| |
| Date :
2009-06-11 23:54:37 |
By :
bermphp |
|
|
| |
|
|
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
ขึ้นแบบนี้ด้วยครับ ผมลองเปลี่ยนดู
UPDATE customer SET field_b = 'somsri',
'somying,'somchai,
'somjit' WHERE field_a = 'suvit'
MySQL แสดง:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''somying,'somchai,'somjit' WHERE field_a = 'suvit'' at line 1
|
| |
|
|
| |
| Date :
2009-06-11 23:56:43 |
By :
bermphp |
|
|
| |
|
|
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
UPDATE _customer_ SET field_b = 'somsri' WHERE field_a = 'suvit';
UPDATE _customer_ SET field_b = 'somying' WHERE field_a = 'supoj';
UPDATE _customer_ SET field_b = 'somchai' WHERE field_a = 'sujit';
UPDATE _customer_ SET field_b = 'somjit' WHERE field_a = 'surat';
|
| |
|
|
| |
| Date :
2009-06-11 23:57:29 |
By :
plakrim |
|
|
| |
|
|
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
วาว พี่ครับ ถ้าผมมีลูกค้าสัก 100 กว่าคน ผมก็ต้องมี 100 กว่าแถวหรอครับ แถมมีอีกหลายฟิลด์ด้วยอ่ะครับ
|
| |
|
|
| |
| Date :
2009-06-11 23:59:31 |
By :
bermphp |
|
|
| |
|
|
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
มีวิธีลัดไหมครับ เนี่ย ฮืออออออออออ เยอะเลย
|
| |
|
|
| |
| Date :
2009-06-12 00:06:39 |
By :
bermphp |
|
|
| |
|
|
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
UPDATE _customer_ SET field_b = 'somsri',field_c = 'aa' WHERE field_a = 'suvit';
UPDATE _customer_ SET field_b = 'somying',field_c = 'bb' WHERE field_a = 'supoj';
UPDATE _customer_ SET field_b = 'somchai',field_c = 'cc' WHERE field_a = 'sujit';
UPDATE _customer_ SET field_b = 'somjit',field_c = 'dd' WHERE field_a = 'surat';
ก็ไม่รู้จะทำยังไงแหละครับ โทษฐานออกแบบฐานข้อมูลไม่รอบคอบ หรือใครมีวิธี ผมจะมาเก็บความรู้
|
| |
|
|
| |
| Date :
2009-06-12 00:52:11 |
By :
plakrim |
|
|
| |
|
|
|
|
|
| |
|
|
|
|
