SEOW v7 Planning
Moderator: SEOW Developers
-
- Posts: 302
- Joined: Fri 13 Apr 2007 1:13 pm
- Location: Italy
your pilot_photos table seems empty.
What you posted is the table structure, could you post the table data view?
Adding data:
if you want to add data to a MySql table you have one of these options:
1. manually insert data if the browser allows you.
2. import data from a csv or sql file
3. execute a sql script
By phpmyadmin choose the database and the pilot_photos table and:
1. select the Insert option, fill the "Value" for both fields (Pilot_Name and Photo_Name) and click on Execute;
2. select Import option, choose the file to load you must have prepared before;
3. select SQL option, type:
then click on execute
Note the difference between ` (qualifying database objects) and ' (qualifying strings)
What you posted is the table structure, could you post the table data view?
Adding data:
if you want to add data to a MySql table you have one of these options:
1. manually insert data if the browser allows you.
2. import data from a csv or sql file
3. execute a sql script
By phpmyadmin choose the database and the pilot_photos table and:
1. select the Insert option, fill the "Value" for both fields (Pilot_Name and Photo_Name) and click on Execute;
2. select Import option, choose the file to load you must have prepared before;
3. select SQL option, type:
Code: Select all
INSERT INTO `pilot_photos`(`Pilot_Name`,`Photo_Name`)VALUES ('JAGER_Knoke','JAGER_Knoke.jpg');
Note the difference between ` (qualifying database objects) and ' (qualifying strings)
22GCT_Gross
-
- Posts: 12
- Joined: Sat 18 Feb 2012 1:29 pm
- Location: Catalunya
I'm using HeidiSQL, free and good enougth IMO.IV/JG7_4Shades wrote:Don't use phpMyAdmin, it is horrible.
Try to get a free version of Navicat or SQLyog, these are much easier to use.
Cheers,
4S
Salut!