MySQL Forums
Forum List  »  Newbie

using mysql inside a ksh script
Posted by: Dennis Dunlap
Date: November 02, 2004 03:27PM

this is undoubtedly a really newby thing to ask but.....

I am trying to run mysql from inside a ksh (shown below)

========================
#!/usr/bin/ksh
mysql <<!!
use 'test'
create table blocktypes (typeid SERIAL not null, typename (char20) );
\q
!!
exit
========================

It seems to work but I get screens of data that looks like header files of the mysql source, i.e. copyright statement usage: etc etc

How do I turn this off??? :-{

related question:
how can I print info to screen to show it worked like SHOW TABLES command.

Thanks in advance...

dsquared

Options: ReplyQuote


Subject
Written By
Posted
using mysql inside a ksh script
November 02, 2004 03:27PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.