mysql client will read from standard input, so you can just
pipe in the sql
e.g.
echo "insert into ..... ;" | mysql -p -u root test
or from a shell script you can use "here is" syntax e.g.
mysql -p -u root test <<endmysql
insert into ....
endmysql
Johan Vikerskog (ECS) wrote:
>
> If i want to add something into a table with just the mysql command.
> Is this possible.
>
> Like
> /mysql -p -u root test "insert into..."
>
> Something like this.Is that possible and how in that case.
>
> Johan Vikerskog
> Technician - CAE Tools Support
> Research & Technology Development
>
>'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
> Ericsson Mobile Communications AB
> Mobile Phones & Terminals Telephone: +46 46 19 33 38
> Nya Vattentornet Telefax: +46 46 19 32 36
> SE-221 83 Lund, Sweden
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]