Menu
I just started designing a database in MySQLWorkbench 6.0. I created a few tables but now when I click the "Add table" button it shows a message: "Index out of range" and the program crashes.
Any idea what is wrong or what could I have done to get this error ?
None of the tables have any values, they just have the fields and field type, with their primary keys and foreign keys (something tells me it's something I did when connecting tables via the foreign keys, I'm new to this software).
Any help appreciated!
879
You can easily change this limit by going to MySQL Workbench >> Edit >> Preferences >> SQL Queries tab. Over here you will option to Limit Rows. You can set this to very high value or uncheck the option. When you uncheck that option, it will retrieve all the rows from a query (equivalent to no limits).
To add an index, click the last row in the index list. Enter a name for the index and select the index type from the list. Select the column or columns that you wish to index by checking the column name in the Index Columns list.
The following are steps that you want to import data into a table: Open table to which the data is loaded. Review the data, click Apply button. MySQL workbench will display a dialog “Apply SQL Script to Database”, click Apply button to insert data into the table.
To change the name, data type, default value, or comment of a column, double-click the value to edit it. You can also add column comments to the Column Comment field. It is also possible to set the column collation, using the list in the Column Details panel.
Once the alert popped up, I hit ok and then clicked on the little wrench icon above the utf selection. I had to change how it would separate the columns from ';' to ',' This fixed my issue without having to change any of the content in the csv.
86
I just ran into this, Some of the fields in my CSV contained " and ' characters. Removing those fixed it.
31
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
