"Daevid Vincent" <daevid@stripped> wrote:
> I have my schema set so that a field in a table has a default value of 16.
>
> I also have a script that "initializes" the database, but I don't want to
> delete the record since I want the other fields' data preserved. Is there a
> way to find out what the default schema value is so that I can issue an
> UPDATE and set it back?
You can use SHOW COLUMNS or SHOW CREATE TABLE statements.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Victoria Reznichenko
/ /|_/ / // /\ \/ /_/ / /__ Victoria.Reznichenko@stripped
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.com
