mysql -p<password> -u <username> -e <shell commands for sql like select>
that can be runned from any shell script. use enum to check Y/N TRUE/FALSE etc. CREATE TABLE testtest ( test ENUM( 'TRUE', 'FALSE' ) NOT NULL ); it automaticly sets true as default value with me. otherwise add: DEFAULT 'FALSE' after not null Hope this helps -- Kind regards, Remko Lodder Elvandar.org/DSINet.org www.mostly-harmless.nl Dutch community for helping newcomers on the hackerscene mrtg.grunn.org Dutch mirror of MRTG -----Oorspronkelijk bericht----- Van: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Seena Blace Verzonden: maandag 9 februari 2004 22:14 Aan: [EMAIL PROTECTED] Onderwerp: [Mysql-discussions] HOW TO RUN SQL and default value ? Hi, How to run script at mysql prompt? Like if i want to create a table or select some query and I want to put those sql statement into one file ,how to run that and what would be the extention of that query? I want to create on column which contains only default value TRUE or False.how to do that? Create table test1 (no int, flag char (6) default ................... thx -seena --------------------------------- Do you Yahoo!? Yahoo! Finance: Get your refund fast by filing online -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]