Getting MySQL field type

Anon

I want to be able to make a duplicate MySQL table (one with identical field types). The only way I know of how to do this is to determine the field types of the original table, then use that to create a new table. The problem is that I can't figure out how to get enough detail about the fields. mysql_field_type() and mysql_field_flags() does not give me enough information. It needs to be more specific (such as distingushing btw "int" and "bool").

On the other hand, if there is a simpler way of creating an identical table, that would be even better.

Anon

With command line MySQL, you can type in "show create table tbl_name" and it will give you the CREATE TABLE query that was used to create the table. I'm not sure if you can pass that command to mysql_query() though...try it.

Diego

Anon

Thanks a lot! It works.

I'm just wondering if I'm using the most efficient methord of extracting the 'resource' returned by "SHOW CREATE TABLE tbl_name"...Currently, I'm using "mysql_result($Result, 0, 1)". Is this an efficient methord? I guess this question is more curiosity than of any pratical significance (give the size of the query in this case).

Anon

Well, according to the documentation:
http://www.php.net/manual/en/function.mysql-result.php
, "when working on large result sets, you should consider using one of the functions that fetch an entire row". But yeah, I guess since your result set is just one row, that should be fine.

Diego