Hello, thank you so much for the video, unfortunately I tried to import a csv file and i got this error "Unhandled exception: 'ascii' codec can't decode byte 0xc3 in position 24: ordinal not in range(128) Check the log for more details." I will appreciate if you can give more insight, I have tried all the solutions on stack overflow but nothing seems to work
Thanks! I'm guessing that error refers to a character in position 24 in your file that can't be read. I would suggest opening the file in a text editor such as Atom or VS Code to see what is in that position.
I'm guessing there's a character that's being imported that MySQL Workbench doesn't like. Perhaps there's a way to change the character set in the import process, or when saving the file.
Hi Victor, I add new courses about once every two months. I've just recently re-released the Introduction to SQL course which includes Postgres and MySQL, and I'm working on updating the course that comes after that. I've got a couple of other upcoming courses that include Postgres and MySQL as well.
Hola, tengo un archivo .CSV de 143MB. Va a tardar días en hacer el import, no? Lo dejé un rato y la barra de carga no se movió nada haha
Hi, you could use the text command which may be faster. It's called LOAD DATA INFILE. I'd suggest looking up a tutorial or article on how to use that.
Thanks alot,, you've solved my projects problem
Good to hear!
Great way of teaching ! Love from India
Thanks!
Hello, thank you so much for the video, unfortunately I tried to import a csv file and i got this error "Unhandled exception: 'ascii' codec can't decode byte 0xc3 in position 24: ordinal not in range(128)
Check the log for more details." I will appreciate if you can give more insight, I have tried all the solutions on stack overflow but nothing seems to work
I am using a MAC OS
Thanks! I'm guessing that error refers to a character in position 24 in your file that can't be read. I would suggest opening the file in a text editor such as Atom or VS Code to see what is in that position.
@@DatabaseStar Thank you so much for your reply
i have big csv file
it is taking lot of time to import data
do you have any other way to import big csv file in mysql workbench
There's a command in MySQL called Load Data which you could look into using. It may perform better for importing large CSV files.
Is there's a way to auto sync between MYSQL and the csv file?
I'm not sure, there might be a way. Maybe a regular scheduled job could be set up to re-import the CSV every so often.
hello, I canons, I got this message:
Unhandled exception: 'ascii' codec can't decode byte 0xef in position 0: ordinal not in range(128)
I'm guessing there's a character that's being imported that MySQL Workbench doesn't like. Perhaps there's a way to change the character set in the import process, or when saving the file.
I was really hoping you'd show how to do it in actual SQL code
I can create another video on doing this using SQL code, or specifically the MySQL command to import a file.
Thanks for the tutorial!
No problem!
Thanks a lot
You’re welcome
yet to see any update for postgres or mysql related section in your paid course
Hi Victor, I add new courses about once every two months. I've just recently re-released the Introduction to SQL course which includes Postgres and MySQL, and I'm working on updating the course that comes after that. I've got a couple of other upcoming courses that include Postgres and MySQL as well.