Re: defaults for net_read_timeout and net_write_timeout?

Marten Lehmann <[EMAIL PROTECTED]> wrote: > what are the defaults for the following options? > > net_read_timeout 30 seconds. > net_write_timeout 60 seconds. See http://dev.mysql.com/doc/mysql/en/Server_system_variables.html for details. -- For technical support contracts, goto https

Re: defaults in MySQL

/etc/my.cnf: Global options DATADIR/my.cnf: Server-specific options defaults-extra-file: The file specified with --defaults-extra-file=# ~/.my.cnf: User-specific options By default, data is in /var/lib/mysql. Jon Miller wrote: Can someone tell me how do I find the default settings in MySQL. Mainl

RE: defaults

You can just add DEFAULT keyword followed by the default value in the column definition and use it either when creating a new table or altering a table to add/set a default value to its column(s).. See: http://www.mysql.com/doc/C/R/CREATE_TABLE.html http://www.mysql.com/doc/A/L/ALTER_TABLE.htm