no more than 5000 records

User, date	Message
Written by gilgal 5 years ago Category: General 32 posts since Wed, 12 Dec 07	I want to insert 31102 records. Why does it hold no more than 5000 records?
Written by ansgar 5 years ago 3952 posts since Fri, 07 Apr 06	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...
Written by gilgal 5 years ago 32 posts since Wed, 12 Dec 07	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?
Written by ansgar 5 years ago 3952 posts since Fri, 07 Apr 06	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.
Written by gilgal 5 years ago 32 posts since Wed, 12 Dec 07	ok thanks
	Please login to leave a reply, or register at first. Username: Password: Remember me