Do you want to save time while using MySQL Workbench? Get my Timesaver Guide to MySQL Workbench here: databasestar.mykajabi.com/lpkj-timesaver-mysql-wb/?
Yes, the video is for perfect circumstances w/perfect results, Good !!. It does't addesse when the imported .cvs yields all fields on all columns as NULLs on a newly created table. All params: Checked. Project due 01/03/25. I am stuck. Any ideas please? Thanks.
Thanks for the feedback! As mentioned on your comment on the other video, if you're having problems importing a CSV file, there are several things I can suggest. First, try importing it into a table with all fields set as a text value. They are less restrictive than numbers, and oftne let values in that other columns don't. Also, check how quotes are handled, sometimes values with single quotes are not handled correctly. I'll create a video on this in the future.
Hi, I tried importing a csv file on MySQL workbench with more than 10 columns. While importing, it doesn't allow me to check the data types of all the columns and change them before hand. Do you have any solution for that?
Hmm that makes it tricky. I would probably try to import the CSV into a table with a text or varchar data type, as this will likely import the data as-is. Then you can convert it into the type you need.
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.
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.
Do you want to save time while using MySQL Workbench? Get my Timesaver Guide to MySQL Workbench here: databasestar.mykajabi.com/lpkj-timesaver-mysql-wb/?
Thanks alot,, you've solved my projects problem
Good to hear!
Yes, the video is for perfect circumstances w/perfect results, Good !!. It does't addesse when the imported .cvs yields all fields on all columns as NULLs on a newly created table. All params: Checked. Project due 01/03/25. I am stuck. Any ideas please? Thanks.
Thanks for the feedback! As mentioned on your comment on the other video, if you're having problems importing a CSV file, there are several things I can suggest. First, try importing it into a table with all fields set as a text value. They are less restrictive than numbers, and oftne let values in that other columns don't.
Also, check how quotes are handled, sometimes values with single quotes are not handled correctly. I'll create a video on this in the future.
Thanks for the tutorial!
No problem!
Hi, I tried importing a csv file on MySQL workbench with more than 10 columns. While importing, it doesn't allow me to check the data types of all the columns and change them before hand. Do you have any solution for that?
Hmm that makes it tricky. I would probably try to import the CSV into a table with a text or varchar data type, as this will likely import the data as-is. Then you can convert it into the type you need.
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?
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.
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.
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.
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.
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 a lot
You’re welcome