Re: How create a MySQL db & table using PHP
| From: | Daniel Convissor | Date: | Fri, 06 Oct 2000 14:46:05 +0000 |
| Subject: | Re: How create a MySQL db & table using PHP | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-18888@lists.php.net to get a copy of this message | ||
Hi Krzysztof:
> Could anyone put (or send e-mail) an example to create
> a MySQL database with table with a numeric, string and datatime
> field.
You'd use exactly the same query string you'd use from a command line except
you don't need to put the ";" in. Then, run that query through PHP's
mysql_query() function. Something like this:
mysql_query("CREATE TABLE Test (Foo char(1), Fluff tinyint)");
--Dan
--
T H E A N A L Y S I S A N D S O L U T I O N S C O M P A N Y
More than just answers. Solutions. (SM)
http://www.analysisandsolutions.com/
4015 7 Av #4, Brooklyn NY 11232 v: 718-854-0335 f: 718-854-0409