最新版 |
編集中の文章 |
234行目: |
234行目: |
| | | |
| <nowiki>update clients_old set ie_id = 1264 where id = 515; | | <nowiki>update clients_old set ie_id = 1264 where id = 515; |
| + | |
| update clients_old set ie_id = 1264 where id = 1463; | | update clients_old set ie_id = 1264 where id = 1463; |
− | update clients_old set nusi = false where id = 515;</nowiki>
| |
− |
| |
− | delete from clients_old where id = 217;
| |
− | update clients_old set nusi = false where id = 218;
| |
− | update clients_old set ie_id = 204 where id = 218;
| |
− |
| |
− | delete from clients_old where id = 811;
| |
− |
| |
− | update clients_old set nusi = true where id = 1792;
| |
− |
| |
− | delete from clients_old where id = 810;
| |
− |
| |
− | delete from clients_old where ie_id = 22653;
| |
| | | |
− | <nowiki>delete from clients_old where ie_id = 22653;
| + | update clients_old set nusi = false where id = 515; |
− | DELETE 3
| + | </nowiki> |
− | tep5_development=# insert into others
| |
− | (
| |
− | id, name, yomi, client_id, client_name, user_id, note_id, created_at, updated_at, memo, line, generation
| |
− | )
| |
− | select
| |
− | id, name, yomi, ie_id, nusi, user_id, jiin_id, created_at, updated_at, memo, each_order, generation
| |
− | from
| |
− | clients_old;
| |
− | INSERT 0 4747</nowiki>
| |
| | | |
| === 指定行を作る === | | === 指定行を作る === |