distal-attribute
distal-attribute
distal-attribute
distal-attribute

no more than 5000 records

gilgal posted 7 years ago in General
I want to insert 31102 records. Why does it hold no more than 5000 records?
ansgar posted 7 years ago
Just have a look at the very top, there is a "spin-editor", which is calculating this LIMIT for the datagrid so you don't load a too large amount of data over the net. Your table is not cut. I always thought this is obvious enough...
gilgal posted 7 years ago
oh ok. I'm adapting from MS Access 2000. That was something I wouldn't expect. There are probably so many tools added that could be useful. But for even MS Access 2000 I've seen people do so many things which until today I cannot figure out like coding SELECT statements in the db itself that will automatically create another table. That I would like to learn.

Oh and how do I set a primary key for id. Do I need to insert the id column from the MS Access 2000? or can Heidi create it automatically?
ansgar posted 7 years ago
You can use the field- and index-editor in HeidiSQL to create a primary or other key. Just doubleclick a fieldname in the "Table" tab and there we go.
gilgal posted 7 years ago
ok thanks

Please login to leave a reply, or register at first.