* Bogdan Stancescu
> No, I mean the type of the fields. When you create a table you
> have to define the field types -- char, varchar, stuff like
> that. Does your code take care of that?
It seems like it does:
mysql> use test
Database changed
mysql> create table test4 (a char(8),b int(9));
Query OK, 0 rows affected (0.37 sec)
mysql> insert into test4 values ('asd',1);
Query OK, 1 row affected (0.04 sec)
mysql> create table test5 select * from test4;
Query OK, 1 row affected (0.07 sec)
Records: 1 Duplicates: 0 Warnings: 0
mysql> desc test5;
+-------+---------+------+-----+---------+-------+--------------------------
-------+
| Field | Type | Null | Key | Default | Extra | Privileges
|
+-------+---------+------+-----+---------+-------+--------------------------
-------+
| a | char(8) | YES | | NULL | |
select,insert,update,references |
| b | int(9) | YES | | NULL | |
select,insert,update,references |
+-------+---------+------+-----+---------+-------+--------------------------
-------+
2 rows in set (0.06 sec)
I don't know if this is _allways_ the case... you can do a regular CREATE
TABLE and use INSERT ... SELECT if there is a problem with CREATE ...
SELECT.
> Thanks for the links!
Your welcome! :)
--
Roger
---------------------------------------------------------------------
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
