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
How to enter data into fields
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
Thanks for your help
Dan Landis
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.
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.