$10 for a minute answer!
- Thread starter curiosity
- Start date
risefromdeath
BANNED
- Jul 1, 2009
- 651
- 107
there are many many ways
for example write a sql in this format
else use the import fucntion to import it from excel or other support formats like csv..just see which suits you most
for example write a sql in this format
PHP:
INSERT INTO `keywords` (`slno`, `keyword`) VALUES
(1, 'test'),
(2, 'test1');else use the import fucntion to import it from excel or other support formats like csv..just see which suits you most
cottontail
BANNED
- Oct 27, 2009
- 114
- 4
I have an idea!!!Paste your sample data here...There's a lot of sloution to it. You can use the built in "SQL" and paste your sql codes and click "Go"
risefromdeath
BANNED
- Jul 1, 2009
- 651
- 107
i doubt he is coming online again
there are many many ways
for example write a sql in this format
else use the import fucntion to import it from excel or other support formats like csv..just see which suits you mostPHP:INSERT INTO `keywords` (`slno`, `keyword`) VALUES (1, 'test'), (2, 'test1');
If you don't mind me asking further, how do I use the import function to import data from excel? How would I format the excel file?
justone
BANNED
- Oct 12, 2008
- 1,520
- 1,054
Code:
LOAD DATA INFILE 'exceldata.csv' INTO TABLE tablename
FIELDS TERMINATED BY ',' ENCLOSED BY '"' ESCAPED BY '\\'
LINES TERMINATED BY '\r\n'That code will load the file "exceldata.csv"
The file is CSV format, fields are separated by , and enclosed by "
One line is one entry
You can make excel export in that format (csv export), or adapt the sql query to match your excel export.
Play around you'll solve it now