Hi,
On Jan 16, 2008 5:13 AM, Richard Heyes <[EMAIL PROTECTED]> wrote:
> > I think it's the same.
>
> I seem to remember that a BIGINT id two INTs tacked together, so how is
> that possible?
MySQL uses BIGINT for most internal math. The data types influence
only how the data is stored, not how My
I think it's the same.
I seem to remember that a BIGINT id two INTs tacked together, so how is
that possible?
--
Richard Heyes
http://www.websupportsolutions.co.uk
Mailing list management service allowing you to reach your Customers
and increase your sales.
** NOW OFFERING FREE ACCOUNTS TO
I think it's the same.
On Jan 16, 2008 6:03 PM, Richard Heyes <[EMAIL PROTECTED]> wrote:
> Performance wise, what is a BIGINT like in comparison to an INT on a 32
> bit machine?
>
> Thanks.
>
> --
> Richard Heyes
> http://www.websupportsolutions.co.uk
>
> Mailing list management service allowing
Hello.
The behaviour of UNSIGNED BIGINT was correct on my Win2k Professional.
Do you use a mysql command line client or other client software?
mysql> create table bu(a bigint unsigned);
Query OK, 0 rows affected (0.20 sec)
mysql> insert into bu values('18446744073709551615');
Query OK
sorry, I don't know that one. Never have used any version of mysql lower
than 4.04. a suggestion might be to call your 4.0 column an unsigned
bigint, or if possible an unsigned int if the numbers can fit in 32
bits. unsigned means its always positive.
jeff
ps. you may want top "reply all" so t
yes it does. we use a bigint(20) for example.
[EMAIL PROTECTED] wrote:
Hi,
I would like to know whether MySql 4.0 supports bigint. If not what
is the corresponding data type that I ccould use if I am imoprting
tables from MySql 3.2 to MySql 4.0
Thanks,
Sharath
--
Jeff Mathis, Ph.D.
Someone has a pretty lousy filter installed
At 02:56 PM 07/16/2002, you wrote:
>Your message cannot be posted because it appears to be either spam or
>simply off topic to our filter. To bypass the filter you must include
>one of the following words in your message:
>
>sql,query
>
>If you just rep
of unsigned big ints (as keys)and this is the only
problem we've ever had.
Eric Pickup
http://buildacommunity.com
- Original Message -
From: "Fred van Engen" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, February 20, 2001 9:41 AM
Subject: Re: BigInt
On Tue, Feb 20, 2001 at 06:56:28PM +0800, chchen wrote:
> hi all
>
> i use mysql-3.23.32
>
> my project need to use unsigned Bigint as a primary key.
> but when i insert many rows in this table.
> sometimes it will error with Duplicate such like
>
> insert into Table
>values('92318521725269771
First, i am really sorry about that.
my fields is quite simple.
CREATE TABLE TEST (
A bigint(20) unsigned DEFAULT '0' NOT NULL,
C0 bigint(20) unsigned DEFAULT '0' NOT NULL,
C1 bigint(20) unsigned DEFAULT '0' NOT NULL,
C2 bigint(20) unsigned DEFAULT '0' NOT NULL,
C3 bigint(20) unsig
Firstly, why do you have quotes around the numbers? I thought you said it
was bigint, not a string?
Secondly, if you are going reply/repost to the list, could you please
simplify it a bit. Provide field names, etc. Your insert is very difficult
to figure out especially with unmatched brackets,
11 matches
Mail list logo
