otak info official Logo   
OTAK.INFO
Personal Blog

Hariyanto Lim

정길상 / 鄭吉祥
Home   Last Posts  
 
Please login to see more topics and discussion categories.
 
goto main category list >> Database >> SQLite

Title : How to import the SQL file from exported sql from adminer 4.3.0
Total Reply : 0
Total View : 438


Harry
Harry
Total thread: 131
Total reply: 50

Post #182
How to import the SQL file from exported sql from adminer 4.3.0
Adminer has export function, I normally use it to read SQLite3 file and export it to normal SQL file.

Problem: MySQL Workbench complain (execute error) the double quote use by Adminer.

Solution: add "SET SQL_MODE=ANSI_QUOTES;" in the first line before execute all the query statements.
Falling in love with the world

Write : 2017-04-12 17:01:28

If you want to create a new reply then please login first.



www.OTAK.INFO
Since 19 January 2007
Page hit : 664,205

Code update 24th June 2013
Brain is a very capable to solve big problems
but requires constant reminders about how to.
peace bird