ansaurus

Question

Select columns of specific type in MySQL 4.1

Answer 1

+1 A:

Use the SHOW COLUMNS syntax to return the data you need.

Jim H. 2009-12-18 16:33:27

There doesn't seem to be a way of filtering the result eg. WHERE Type = 'x'

JKJKJK 2009-12-18 16:49:06

You can filter the results by the field name, but not by the type. However, since you can pull the results of SHOW COLUMNS out as if it were a SELECT query, you can just filter out the results in your code.

Rob Van Dam 2009-12-24 18:53:04

Answer 2

A:

I think it should work
SHOW TABLES; # Get list of all tables DESC [EACH TABLE]; # and then check "Type" column

a1ex07 2009-12-18 16:34:06

Answer 3

A:

If you are using PHP you could use the following functions to gain information about specific fields in your tables.

mysql_field_type
mysql_fetch_field
mysql_field_len
mysql_field_flags

mysql_fetch_field gives you the most info.

To give you an example of how you might use it:

$SQLquery = 'SELECT * FROM '.$tableName;
$arr;
$field_array = array();
$res = mysql_query($SQLquery);

$numOfCols = mysql_num_fields($res);

for($y=0;$y<=($numOfCols-1);$y++)
{
    $fieldName1 =  mysql_field_name($res, $y);
    $field = mysql_fetch_field($res, $y);
    if($field->max_length < 6 && $field->numeric = true)
    {
      $field_array[] = $fieldName1;
    }
}

I realize this is not a MySql answer but I hope it helps if there is no way to get the info you need via MySql in 4.1

mmundiff 2009-12-18 18:53:43

ansaurus

tags:

views:

answers:

Select columns of specific type in MySQL 4.1

related questions