problem with read default value

[soasi]

Please help me if you can

I have table with simple data. all of fields have default value

how to read this default value, using php

thanks for help

 

[rac2]

The values used for defaults are stored in the data dictionary, also known as the INFORMATION_SCHEMA. See

http://dev.mysql.com/doc/mysql/en/columns-table.html

From that resource I learned that you can find the default for a column with this query.

SELECT COLUMN_NAME, COLUMN_DEFAULT
  FROM INFORMATION_SCHEMA.COLUMNS
  WHERE table_name = 'tbl_name'
  [AND schema_name = 'db_name']
  [AND column_name LIKE 'wild']

The clauses in brackets are optional. Also there should be a way to get the same information from the SHOW command.

SHOW COLUMNS
  FROM tbl_name
  [FROM db_name]
  [LIKE wild]

Hope I understood your question and that this is helpful.