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

How to enter data into fields

landisd posted 8 years ago in General
I am new to Heidisql, so pardon if this seems like a stupid question.

1. Created the database and tables with fields

2. Now I want to enter a few records one row at a time, but I can't figure out how to do it...I clicked on the data tab and the fields are revealed. I enter data in the fields, but there is no save or enter button that would put the data in and then go to the next blank record so I could add data there.

Can someone provide me the answer to this, seemingly simple, question?

Thanks

Dan Landis
siMKin posted 8 years ago
just press the 'arrow-down' key; this will take you to the next row and automatically saves the one you had been editing
should you ever want to cancel inserting or updating a row, then press the escape key
landisd posted 8 years ago
Thanks for the quick reply...another question: what sql files should I upload to the IP server along with the php program to access the data? There is a folder (I am in Windows XP Pro) that has the name of the database and two files inside of it. Do I simply upload the folder (which would become a subdirectory in my directory at the IP server) or the two files separatly into the same directory as the php files?

Thanks for your help

Dan Landis
siMKin posted 8 years ago
what kind of files are they?
if they are files containing sql code (for creating the necessary tables and filling them with data), then you can use the import function in Heidi.
To do this go to Import > Load SQl-file
If they are files containing just data seperated by, for example, commas, then go to Import > Load CSV file. But then you need to create the tables first.

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