Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

Error "Index out of range" in MySQL Workbench 6.0.8.11354 (6.0), what is wrong?

Tags:

sql

mysql

mysql-workbench

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!

like image 879
salsadeanguila Avatar asked Jan 10 '14 01:01

salsadeanguila

People also ask

How do I change the limit of a workbench in MySQL?

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).

How do I index a table in MySQL workbench?

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.

How do I import a csv file into MySQL?

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.

How do I change the default value in workbench?

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.

2 Answers

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.

like image 86
hardScrabble Avatar answered Nov 05 '22 15:11

hardScrabble

I just ran into this, Some of the fields in my CSV contained " and ' characters. Removing those fixed it.

like image 31
dryicebomb Avatar answered Nov 05 '22 15:11

dryicebomb
Sign in to Comment

Related questions

A SQL query to select until SUM(users_count) reaches 1000
MYSQL how to declare a datetime variable?
Should SQL JOINs be placed in particular order for performance reasons?
Cannot return results from stored procedure using Python cursor
How to see table partition size in MySQL ( is it even possible? )
MYSQL restrict user access to information_schema
How to Import Excel file into mysql Database from PHP
Select value from table only if exist in another
MySql connection, can I leave it open?
mysql LOAD DATA INFILE with auto-increment primary key
What are MySQL foreign keys?
How to reset mysql root password?
Which is more efficient for a one or two-character string: CHAR(2) or VARCHAR(2)?
SELECT N rows before and after the row matching the condition?
Select count for each distinct row (mysql and php)
Left-joining the same table multiple times
MySQL LOAD DATA INFILE: works, but unpredictable line terminator
What does INT(1) stand for in MySQL?
Fatal error: Call to undefined function mysqli_result()
How to load date data in MySQL when using LOAD DATA

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!