Re: integer

2008-05-24 Thread B J Ambrose
--- On Thu, 5/22/08, Norbert Tretkowski <[EMAIL PROTECTED]> wrote: From: Norbert Tretkowski <[EMAIL PROTECTED]> Subject: Re: integer To: mysql@lists.mysql.com Date: Thursday, May 22, 2008, 3:34 PM Am 22.05.2008, 14:04 +0530 schrieb Krishna Chandra Prajapati: I would to kn

Re: integer

2008-05-24 Thread Moon's Father
lt;[EMAIL PROTECTED]> wrote: > > > From: Norbert Tretkowski <[EMAIL PROTECTED]> > > Subject: Re: integer > > To: mysql@lists.mysql.com > > Date: Thursday, May 22, 2008, 3:34 PM > > Am 22.05.2008, 14:04 +0530 schrieb Krishna Chandra > > Prajapati: > >

Re: integer

2008-05-22 Thread Krishna Chandra Prajapati
If i am not using zerofill. Then is there any different between int(10) and int On Thu, May 22, 2008 at 2:23 PM, Glyn Astill <[EMAIL PROTECTED]> wrote: > int(10) will pad with zeros on return, i.e. if value = 59 > > int(10) 59 > int59 > > - Original Message > > Fr

Re: integer

2008-05-22 Thread Saravanan
what kind of datatype it is int(50) parent_id| int(50) is that big int? Saravanan --- On Thu, 5/22/08, Norbert Tretkowski <[EMAIL PROTECTED]> wrote: > From: Norbert Tretkowski <[EMAIL PROTECTED]> > Subject: Re: integer > To: mysql@lists.mysql.com > Date: T

Re: integer

2008-05-22 Thread Norbert Tretkowski
Am 22.05.2008, 14:04 +0530 schrieb Krishna Chandra Prajapati: > I would to know the difference between the two > > int(10) and int (Used in create table ) MySQL has an excellent documentation, which of course also answers your question: http://dev.mysql.com/doc/refman/5.1/en/numeric-types.html

Re: integer

2008-05-22 Thread Moon's Father
If you didn't define zerofill int is equal to int(11) if the actual variable is 59,then all display 59. On Thu, May 22, 2008 at 4:53 PM, Glyn Astill <[EMAIL PROTECTED]> wrote: > int(10) will pad with zeros on return, i.e. if value = 59 > > int(10) 59 > int59 > > - Orig

Re: integer

2008-05-22 Thread Glyn Astill
int(10) will pad with zeros on return, i.e. if value = 59 int(10) 59 int59 - Original Message > From: Krishna Chandra Prajapati <[EMAIL PROTECTED]> > To: MYSQL General List > Sent: Thursday, 22 May, 2008 9:34:55 AM > Subject: integer > > Hi, > > I would to know

RE: integer not being inserted correctly

2003-12-15 Thread Mike Brando
> > If an INT has a fixed range, then what is the point of giving it scale? As > in, "int(12)". > > In Oracle, a NUMBER(12) indicates how many digits you could have (in this > case, 999 would be the max value). > > Would an int(2) allow -99 to 99, or -2147483648 to 2147483647? That's bec

Re: integer not being inserted correctly

2003-12-14 Thread Paul DuBois
column that exceeds the size of an int? David. - Original Message - From: "Dan Nelson" <[EMAIL PROTECTED]> To: "A Pasetti" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Sunday, December 14, 2003 6:48 PM Subject: Re: integer not being inserte

Re: integer not being inserted correctly

2003-12-14 Thread Daniel Kasak
David Griffiths wrote: If an INT has a fixed range, then what is the point of giving it scale? As in, "int(12)". In Oracle, a NUMBER(12) indicates how many digits you could have (in this case, 999 would be the max value). Would an int(2) allow -99 to 99, or -2147483648 to 2147483647? Mayb

Re: integer not being inserted correctly

2003-12-14 Thread David Griffiths
ould throw an error if someone tries to create an int(xyz) column that exceeds the size of an int? David. - Original Message - From: "Dan Nelson" <[EMAIL PROTECTED]> To: "A Pasetti" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Sunday, December

RE: integer not being inserted correctly

2003-12-14 Thread Sweet, Charles E
A Pasetti wrote: > When attempting to insert an integer into an integer > column, a different value is being inserted for the > given row. Check out the sql below to see what I mean. > The integer 7819359281 is somehow changed to > 2147483647 when it's inserted. > > Perh

Re: integer not being inserted correctly

2003-12-14 Thread Paul DuBois
At 18:42 -0800 12/14/03, A Pasetti wrote: When attempting to insert an integer into an integer column, a different value is being inserted for the given row. Check out the sql below to see what I mean. The integer 7819359281 is somehow changed to 2147483647 when it's inserted. Have you considered w

Re: integer not being inserted correctly

2003-12-14 Thread Dan Nelson
In the last episode (Dec 14), A Pasetti said: > When attempting to insert an integer into an integer column, a > different value is being inserted for the given row. Check out the > sql below to see what I mean. The integer 7819359281 is somehow > changed to 2147483647 when it's inserted. > > Perh

Re: integer field

2003-10-23 Thread Gabriel Ricard
FYI, PHP will automatically convert the data type to an integer if to use increment it like that. Just like if you had $var = 123; and then did $var .= "foo" it would be converted into the string "123foo". If you're still unable to change the value of $myrow, then I would consult the PHP mailin

Re: integer field

2003-10-23 Thread Rory McKinley
Have you tried casting the $myrow element to integer e.g $increase = (int)$myrow['first'] + 1; I think PHP will return the field as text by default and hence the addition will fail.. Rory McKinley Nebula Solutions +27 82 857 2391 [EMAIL PROTECTED] "There are 10 kinds of people in this world

Re: Integer data types

2002-10-31 Thread ed
Thanks, I also found a way to do this via PHP which I'm using anyway to pass the values. Thanks again, Ed On Thu, 31 Oct 2002, Roger Baklund wrote: > * [EMAIL PROTECTED] > > Is there a MySQL data type to use in a column where I would like an > > integer to be comma delimited? Say someone e

Re: Integer data types

2002-10-31 Thread Roger Baklund
* [EMAIL PROTECTED] > Is there a MySQL data type to use in a column where I would like an > integer to be comma delimited? Say someone enters "100" as a value to > be written to the column. I would like it to be stored as "1,000,000". I > don't want trailing decimals either. Integers are sto

RE: integer&char problem

2001-08-08 Thread saraswathy saras
(compatible; MSIE 5.0; Windows 98; DigExt) Remote Address: 192.168.0.5 __ >From: "Chris Bolt" <[EMAIL PROTECTED]> >To: <[EMAIL PROTECTED]> >Subject: RE: integer&char problem >Date: Wed, 8 Aug 2001

Re: integer & char

2001-08-08 Thread Stefan Hinz
Dear Rsaras, your problem description is not very precise. >message.Then i try to change the type to char ,it's can but, >the max is until 9 only.is there anyone can help me. I guess what you did was to add a field with CHAR type to your table. If you do not specify the length, like CHAR(20), t

Re: integer&char problem

2001-08-08 Thread rsaras
(compatible; MSIE 5.0; Windows 98; DigExt) Remote Address: 192.168.0.5 __ - Original Message - From: Chris Bolt <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, August 08, 2001 2:15 PM Subject: RE: integer&

RE: integer&char problem

2001-08-07 Thread Chris Bolt
> i have a problem in query. My field type is integer. > The table is empty and i want to select max number from the > field but it display error message.Then i try to change the type > to char ,it's can but, > the max is until 9 only.is there anyone can help me. What query? What table? What er