---
From: "ketvin" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, October 23, 2003 8:25 AM
Subject: integer field
Dear lists,
Simple question for geniuses outthere:
my database has an integer field where i created with CREATE table test
(first int(10));
so when i use
people in this world,
those who understand binary and those who don't" (Unknown)
- Original Message -
From: "ketvin" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, October 23, 2003 8:25 AM
Subject: integer field
Dear lists,
Simple question for
Dear lists,
Simple question for geniuses outthere:
my database has an integer field where i created with CREATE table test (first
int(10));
so when i use php to grab the "first" field and read it in $myrow["first"] , then try
to make the number increase by doing a
$incr
At 17:29 -0400 6/14/02, Tab Alleman wrote:
>Hi, can I do a sql query in MySQL that would do something like this:
>
>UPDATE table SET SomeInteger=SomeInteger+1 WHERE (Some Condition)
>
>I know that this exact syntax doesn't work, but is there a way to do
>what I'm trying to do, which is to do a mat
Hi, can I do a sql query in MySQL that would do something like this:
UPDATE table SET SomeInteger=SomeInteger+1 WHERE (Some Condition)
I know that this exact syntax doesn't work, but is there a way to do
what I'm trying to do, which is to do a math function on an integer in
the table with a SQL
{snip]
When I try and insert a string into an integer field, instead of throwing
an error MySQL accepts the insert and set that field's value to zero (I
assume default value). I am using the php mysql module by the way (not
PEAR). I would like to get an error when I insert the wrong data
When I try and insert a string into an integer field, instead of throwing
an error MySQL accepts the insert and set that field's value to zero (I
assume default value). I am using the php mysql module by the way (not
PEAR). I would like to get an error when I insert the wrong data type
