Novo curso! Todo programador deveria aprender IA generativa!
Experimente uma aula grƔtis0
How to convert excel to mysql
Hello guys, does anyone have an idea of how to convert an excel data file into a mysql database?
2 Respostas
+ 1
Export it into some text format. The easiest will probably be a tab-delimited version, but CSV can work as well.
Use the load data capability.
Look half way down the page, as it will gives a good example for tab separated data:
FIELDS TERMINATED BY '\t' ENCLOSED BY '' ESCAPED BY '\'
Check your data. Sometimes quoting or escaping has problems, and you need to adjust your source, import command-- or it may just be easier to post-process via SQL.
0
Thanks Lopez. let me try that out.