[PHP] Create table .. script
Hello When I need to create table I have to login into mysql and run the query. Is there a way to create some sort of scipt that can create all my tables?.So If I need create a table in new database I just run the script. I know that I can do mysql_query(QUERY OF TABLE); But is there another way of doing this? Thanks _ One-click access to Hotmail from any Web page download MSN Toolbar now! http://clk.atdmt.com/AVE/go/onm00200413ave/direct/01/ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Create table .. script
On Mar 13, 2004, at 5:24 PM, Mike Mapsnac wrote: Hello When I need to create table I have to login into mysql and run the query. Is there a way to create some sort of scipt that can create all my tables?.So If I need create a table in new database I just run the script. I know that I can do mysql_query(QUERY OF TABLE); But is there another way of doing this? $sql = CREATE TABLE `rss_cat` ( `id` int(11) NOT NULL auto_increment, `cat` varchar(50) NOT NULL default '', PRIMARY KEY (`id`) ) TYPE=MyISAM AUTO_INCREMENT=1; mysql_query($sql); Just use general SQL to create tables in PHP. This isn't the correct list for these kind of questions, since we have php-db for database related stuff. Regards, Filip de Waard -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Create table .. script[via LSMTP - see www.lsoft.com]
Hi Mike, Try using phpMyAdmin, but sorry I forgot the site :( try google. Regards, Firman - Original Message - From: Mike Mapsnac [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, March 13, 2004 11:24 PM Subject: [PHP] Create table .. script Hello When I need to create table I have to login into mysql and run the query. Is there a way to create some sort of scipt that can create all my tables?.So If I need create a table in new database I just run the script. I know that I can do mysql_query(QUERY OF TABLE); But is there another way of doing this? Thanks _ One-click access to Hotmail from any Web page - download MSN Toolbar now! http://clk.atdmt.com/AVE/go/onm00200413ave/direct/01/ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php