|
|||||
DROP TABLE A_bak Create table A_bak Select * from A ALTER TABLE A_merged ADD INDEX rownum (rownum); ALTER TABLE A ADD INDEX rownum (rownum); delete from A_merged where top1 is NULL; delete from A where top1 is NULL; INSERT INTO A (select * from (SELECT a.* FROM A_merged a LEFT JOIN A b ON a.rownum = b.rownum WHERE b.rownum IS NULL) c); DROP TABLE A_merged RENAME TABLE A TO A_merged Create table A Select * from A_merged WHERE 0=1; À§ ±¸¹®¿¡¼ INSERT INTO A (select * from (SELECT a.* FROM A_merged a LEFT JOIN A b ON a.rownum = b.rownum WHERE b.rownum IS NULL) c); À̺κÐÀÌ PHP·Î ÀÚµ¿È ÇÏ¸é ¾Èµ·´Ù´Âµ¥ ÀÌ°Ô ´çÃÖ ¹«½¼ ¸»ÀÎÁöµµ ¸ð¸¨´Ï´Ù. ¤Ð¤Ð ¹«¾ùÀÌ ¹®Á¦ Àϱî¿ä? ÅõÇÇ¿¡ »óÁÖ ÇÏ°í °è½Å °í¼ö´Ôµé²² ºÎŹµå¸³´Ï´Ù. ´ã´çÀÚ¸¸ ÇØ°á ÇÒ ¼ö ÀÖ´Â ¹®Á¦ Àϱî¿ä?
|
|
| ||
|
|