msqlinsert.c
Right after downloading mSQL, I wanted to import into a table more than
1000 lines. While waiting for an answer from the mSQL list, I
wrote this
simple C program that does this.
Command line options:
- -h: host running msqld.
- -f: file where input is read. If -f is not specified,
stdin is assumed.
- -d: database to connect.
- -t: table to insert data.
- -v: current version.
msqlinsert assumes newline as a record separator and does not know
anything about field separators. So if you input a line say `xxxx' it
connects to msqld and sends the SQL command:
INSERT INTO table VALUES(xxxx)
msqlinsert was developed before I got the response from the msql-list
for msql-import
.
mSQL stands for mini-SQL and is developed by
David Hughes.
- Web site.
- FTP site.
- Mailing list: msql-list@bunyip.com. To subcribe mail to
msql-list-request@bunyip.com with a message body containing
`subscribe'.
-- adamo@dblab.ntua.gr -.