|
Replies:
6
-
Pages:
1
-
Last Post:
Oct 11, 2012 7:15 AM
by: iss42
|
|
|
Posts:
3
Registered:
4/15/12
|
|
|
|
Import wizzard fails key column
Posted:
Apr 15, 2012 11:31 AM
|
|
|
On toad 6.3, importing records to a table (id,name) fauls. Id is primary key, not null autoincrement. The file imported is excel file with one column, name.
On toad 6.0 works fine, import all recosd.
|
|
|
Posts:
1
Registered:
4/16/12
|
|
|
|
Re: Import wizzard fails key column
Posted:
Apr 16, 2012 10:38 AM
in response to: calete
|
|
|
I have same problem, just downloaded toad for mysql specifically to import data and now it just breaks on first days on something so broadly used. Is there a way that i can download the old version ?
|
|
|
Posts:
3
Registered:
4/15/12
|
|
|
|
Re: Import wizzard fails key column
Posted:
Apr 16, 2012 9:25 PM
in response to: DoniRS
|
|
|
Download from http://downloadall.net/16796/download-toad-for-mysql.html
|
|
|
Posts:
1
Registered:
9/29/10
|
|
|
|
Re: Import wizzard fails key column
Posted:
May 4, 2012 12:36 PM
in response to: calete
|
|
|
|
|
I am having the same issue. Reading the online help, it LOOKS like we should be able to use the checkbox of 'identity inserts', but as soon as I select a table, this option disappears, even if it was checked. I have checked that the column is the PK, not null, auto-increment.
This is in 6.3, this process used to work for me (same column and data) in 6.0.
"Null value cannot be inserted to not null column id"
|
|
|
Posts:
1
Registered:
5/15/12
|
|
|
|
Re: Import wizzard fails key column
Posted:
May 15, 2012 4:38 AM
in response to: calete
|
|
|
I am also suffering from this issue - and can confirm it worked perfectly back as far as version 4!
Anyone any ideas?
|
|
|
Posts:
1
Registered:
6/6/12
|
|
|
|
Re: Import wizzard fails key column
Posted:
Jun 6, 2012 9:45 AM
in response to: calete
|
|
|
import in the wizard without the key, then add the key in Alter Table. You can add a key column and autoincrement there also.
|
|
|
Posts:
1
Registered:
10/11/12
|
|
|
|
Re: Import wizzard fails key column
Posted:
Oct 11, 2012 7:15 AM
in response to: leep
|
|
|
I can't drop the key and recreate.
Is there a fix coming for this issue?
|
|
|
|
Legend
|
|
Guru: 2001
+
pts
|
|
Expert: 751
- 2000
pts
|
|
Enthusiast: 31
- 750
pts
|
|
Novice: 0
- 30
pts
|
|
Moderators
|
|
Helpful answer
(5 pts)
|
|
Answered
(10 pts)
|
|
