Hi
I am a newbie to DB concepts and have a basic idea about SQL can any one help me out to have a shell Script to insert around 100 records to a Table???

Thanks in Advance
Bye

yes, what's your question?

What I mean is how should i proceed or write a Shell Script to insert 100 or more( with a loop or with any thing else???) records to a table .

Thank you

Which shell, and what SQL engine?

-PatP

bash and MySQL

moving thread to Unix Shell Scripts forum

Hi, since I'm doing this stuff frequently I've got an example for you. It's done in script but usually I use awk for this, it looks more like a regular programming language.

#!/bin/bash

CNT=0

while [ $CNT -lt 100 ]; do
let CNT=${CNT}+1
INT=$CNT
STRING="${CNT}"
FLOAT=$CNT
printf "insert into table values(%d,\"%s\",%.2f);\n" "${INT}" "${STRING}" "${FLOAT}"
done

Of course the printf can be substituted by `echo`.

Grts.

BTW. I'm not familiar with MySQL but this code is standard SQL, of wich I believe MySQL will accept...