businessjack
Programmer
how do I write the SQL query that I would use to input data into table
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
mysql query
- Thread starter businessjack
- Start date
- Status
TonyGroves
Programmer
If you want to load data from a file into a table, you would use something like:
[tt]
LOAD DATA INFILE 'c:/data/file1.csv'
INTO TABLE tbl1
[/tt]
To insert data directly, you could use something like:
[tt]
INSERT tbl1 (fld1,fld2)
VALUES ('abc',123),('def',456)
However, it's not always that simple, depending on your situation.
[tt]
LOAD DATA INFILE 'c:/data/file1.csv'
INTO TABLE tbl1
[/tt]
To insert data directly, you could use something like:
[tt]
INSERT tbl1 (fld1,fld2)
VALUES ('abc',123),('def',456)
However, it's not always that simple, depending on your situation.
- Thread starter
- #3
businessjack
Programmer
hi,
Is the delete method similar? thank you
Is the delete method similar? thank you
TonyGroves
Programmer
No, deletion is the exact opposite of insertion.
ericbrunson
Technical User
- Status