Hello William,
Tuesday, September 24, 2002, 9:56:49 AM, you wrote:
William, don't send me your questions in private mail. We provide support in
public list. For commercial support, go to https://order.mysql.com/.
WM> Thank you for your responses. How do I delete a table if I do not need to
WM> use it anymore??
DROP TABLE helps you :-)
http://www.mysql.com/doc/en/DROP_TABLE.html
WM> ----- Original Message -----
WM> From: "Victoria Reznichenko" <[EMAIL PROTECTED]>
WM> To: <[EMAIL PROTECTED]>
WM> Sent: Tuesday, September 24, 2002 10:34 AM
WM> Subject: re: Create Tables Dynamically
>> William,
>> Tuesday, September 24, 2002, 4:52:54 AM, you wrote:
>>
>> WM> I am building a web robot in perl that will find equipment from
WM> various
>> WM> manufacturers and will get information about that equipments
WM> specifications.
>>
>> WM> Can you build tables in MySQL 4.0 dynamically with some type of
WM> script.
>>
>> WM> Example. If if have 10 parts in my database and my robot checks with
WM> the
>> WM> manufacturers for new parts everyday. One day the robot says yes I
WM> found a
>> WM> new part that is not in our database. Can I write a script that will
WM> build
>> WM> a table in mySQL and will load the appropriate information.
>>
>> Sure, you can do it with CREATE TABLE statement:
>> http://www.mysql.com/doc/en/CREATE_TABLE.html
>>
>> Don't forget that that user must have CREATE privilege on the database
>> to do it.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Victoria Reznichenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.com
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
