Error witht the db_course_conversions file
Hello there,
I am trying to upload the db_course_conversions.sql file that is found in the "Calculating Free-to-Paid Conversion Rate with SQL Project".
I am trying to upload the db_course_conversions.sql file that is found in the "Calculating Free-to-Paid Conversion Rate with SQL Project".
However, it shows this message when I try to upload it: "Number of columns 65535 is too many for table 'course_conversions_46cb7d39_8d20_412c_93da_d0bc466de18f_source'. "
Maybe the file needs to have a reduced amount of columns. If so, could you pleae help with this, or to offer another option?
Thank you,
Jorge
Maybe the file needs to have a reduced amount of columns. If so, could you pleae help with this, or to offer another option?
Thank you,
Jorge
2 answers ( 0 marked as helpful)
Hey Jorge,
Thank you for reaching out!
The database provided consists of 3 tables - the first and second having 2 columns and the third having 3 columns. Could you please do the following:
1. Drop all schemas related to this project.
2. Open the db_course_conversions.sql file in MySQL.
3. Press Ctr+A to select the entire code.
4. Select the button marked on the screenshot to execute the selected portion of the code.
Once you refresh your schemas, you should find the database to the project.
Let me know if you still experience the same issue. If you do, please attach a screenshot so I can assist you better.
Kind regards,
365 Hristina
Thank you Christina, I will do this and will let you know if I have any other issues.