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.
Thanks alot,, you've solved my projects problem
Good to hear!
Thanks for the tutorial!
No problem!
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
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.
Did you ever find a good way to do this?
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.
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 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.
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 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.