๐ Before
I resolved character corruption problem in previous article, but still couldn't execute .sql file!
Why?
";" was not existed in this file
INSERT INTO Shain(Id,CreateDate,Sei,Mei,Tel,Bikou) VALUES(1,'2010/07/23 12:19:45','ono1','shinichi1','1-a-1','ๅ่AAAAAA1') //* here I need to add ";" !!
INSERT INTO Shain(Id,CreateDate,Sei,Mei,Tel,Bikou) VALUES(2,'2010/07/23 12:20:45','ono2','shinichi2','1-a-2','ๅ่AAAAAA2')
INSERT INTO Shain(Id,CreateDate,Sei,Mei,Tel,Bikou) VALUES(3,'2010/07/23 12:21:45','ono3','shinichi3','1-a-3','ๅ่AAAAAA3')
INSERT INTO Shain(Id,CreateDate,Sei,Mei,Tel,Bikou) VALUES(4,'2010/07/23 12:22:45','ono4','shinichi4','1-a-4','ๅ่AAAAAA4')
๐ How to solve it?
โผ Execute this command on vim
$ %s/ยฅn/;^M/
(^M โ ctrl+v and Enter)
| command | Explanation |
|---|---|
| %s | whole file |
| ยฅn | replace ยฅn(new line) |
| ;^M | to ;ยฅn (; and new line) |
๐ After
INSERT INTO Shain(Id,CreateDate,Sei,Mei,Tel,Bikou) VALUES(1,'2010/07/23 12:19:45','ono1','shinichi1','1-a-1','ๅ่AAAAAA1');
INSERT INTO Shain(Id,CreateDate,Sei,Mei,Tel,Bikou) VALUES(2,'2010/07/23 12:20:45','ono2','shinichi2','1-a-2','ๅ่AAAAAA2');
INSERT INTO Shain(Id,CreateDate,Sei,Mei,Tel,Bikou) VALUES(3,'2010/07/23 12:21:45','ono3','shinichi3','1-a-3','ๅ่AAAAAA3');
INSERT INTO Shain(Id,CreateDate,Sei,Mei,Tel,Bikou) VALUES(4,'2010/07/23 12:22:45','ono4','shinichi4','1-a-4','ๅ่AAAAAA4');
Top comments (0)