Displaying Default Values

2002-10-09 Thread Lawrence S. Stephens III
I am useing mysql Ver 11.18 Distrib 3.23.52, for pc-linux-gnu (i686). I have set up a table in which one of the fields have a default value (i.e. New York). When I INSERT a record, that field is empty so that the default value is inserted into the field automatically (at least that's what I

Re: Displaying Default Values

2002-10-09 Thread Keith C. Ivey
On 9 Oct 2002, at 13:14, Lawrence S. Stephens III wrote: When I INSERT a record, that field is empty so that the default value is inserted into the field automatically (at least that's what I think). If your query is setting the column to the empty string, then you're setting it to the