After installing, do
SHOW VARIABLES LIKE 'max%';
If you don't like the values, then ad a line to my.cnf (my.ini) and restart.
For max_user_connections, I think "0" means "unlimited".
> -Original Message-
> From: Wayne Leutwyler [mailto:wleut...@columbus.rr.com]
> Sent: Friday, Septemb
Jeff Smelser wrote:
On Tuesday 08 February 2005 03:32 pm, Emmett Bishop wrote:
is it possible to force a field to be NOT NULL but not
have any default value (I.E the insert statement must
explicitly provide data for the field in question)?
of course: col1 int not null
Jeff
Except that ALL columns
On Tuesday 08 February 2005 03:32 pm, Emmett Bishop wrote:
> is it possible to force a field to be NOT NULL but not
> have any default value (I.E the insert statement must
> explicitly provide data for the field in question)?
of course: col1 int not null
Jeff
pgpKRoQG6Ktfo.pgp
Description: PGP
Mark writes:
> When I do a describe statement, I see some default values assigned
> automatically to columns in the table. What statement will assign a column
> to blank, so that there is no default value assigned?
Short answer: you can't. There was a long thread about this a week
or two ago,
On Tue, 6 Mar 2001, MikeBlezien wrote:
> >>Try giving a number instead of a string as a default for an int.
>
> Not sure I follow, it is a number??
>
> >>> refer_id int(10) UNSIGNED DEFAULT '100' NOT NULL,
Your '100' is a string. Try something like this:
refer_id int(10) UNSIGNED NOT NULL DEFAU
On Tue, 6 Mar 2001 11:14:36 +0100, Fred van Engen <[EMAIL PROTECTED]>
wrote:
Thanks Fred,
>>INSERT INTO referral
>> VALUES (NULL, 'xxx.yyy', 'xxx.yyy', '[EMAIL PROTECTED]');
>>
>>
>>But an INSERT like this:
This is where I was making the mistake! It works fine now. I was inserting an
blank empt
Try giving a number instead of a string as a default for an int.
Also, what do you mean by blank?
If you pass '' as a value, it will become 0 when converted to an int.
What happens if you omit the column completely on the insert?
"MikeBlezien" wrote:
>
> Hello All,
>
> I've created a table(usi
On Tue, 06 Mar 2001 09:18:34 -0600, "Gerald L. Clark"
<[EMAIL PROTECTED]> wrote:
Gerald,
>>Try giving a number instead of a string as a default for an int.
>>
Not sure I follow, it is a number??
>>"MikeBlezien" wrote:
>>>
>>> Hello All,
>>>
>>> I've created a table(using MySQL 3.23.33),
On Mon, Mar 05, 2001 at 10:26:58PM -0600, MikeBlezien wrote:
> Hello All,
>
> I've created a table(using MySQL 3.23.33), using default values:
>
> DROP TABLE IF EXISTS referral;
> CREATE TABLE referral (
> refer_id int(10) UNSIGNED DEFAULT '100' NOT NULL,
> refer_fname varchar(20) DEFAULT ''
