For whatever it's worth, some years ago I wrote a database that kept track
of IPs. I found it very easy if I treated the IPs as numbers.
Each IP is a quartet of digits, each in the range 0-255. This really means
an IP is a 4-digit number in base 256 and you can use use standard
conversion functi
I'm curious if anyone has any thoughts on how I can handle a data
retention issue I've been facing with a larger dataset.
My process, roughtly is run mysqldump against the DB and gzip the
output. Then I transfer it off to a different machine for archival
onto optical media (yes I know the
This however is not an option at all when you run Apache in prefork
mode. Because the sum of your MaxClients will be equal to the
connections to your MySQL Server.
You can use connection pooling eg SQLrelay
--
Filip Krejci <[EMAIL PROTECTED]>
Linux - und Spass dabei!
--
MySQL General Ma
Hi,
An easier method may be to install mod_log_mysql on each of the Apache
servers and log directly to the central MySQL installation.
Regards
Ian
This however is not an option at all when you run Apache in prefork
mode. Because the sum of your MaxClients will be equal to the
connectio
On 9 Nov 2007 at 10:44, Shaun T. Erickson wrote:
> I pull Apache (combined format) logs, daily, from a number of mirrors,
> back to a central server for processing. I'd like to somehow load them
> in MySQL for analysis.
>
> 1) Does anyone know of a script that can parse the logs and load them?
>
Thanks for your help. I upgraded MyODBC 3.51.19 to 5.1 beta, and tried it
for Devnagari data entry and it worked well. But now a new problem of
showing newly added record as '#Deleted' is there. and even after adding a
time stamp field in the table, this problem exists,(this problem is solved
in 3.
Try upgrading to a version 5 of the ODBC connector. It worked for our
Chinese data.
Regards,
Jerry Schwartz
The Infoshop by Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
www.the-infoshop.com
www.giiexpress.com
www.etudes-marche.com
>
Celko also discusses them in SQL For Smarties.
Baron
Peter Brawley wrote:
Matt
>I'd like to store paths to specific destinations...
See
-- Tropashko's 'materialized modell' eg
http://www.dbazine.com/oracle/or-articles/tropashko4
-- the airports example at
http://www.artfulsoftware.com/mysq
Matt
>I'd like to store paths to specific destinations...
See
-- Tropashko's 'materialized modell' eg
http://www.dbazine.com/oracle/or-articles/tropashko4
-- the airports example at
http://www.artfulsoftware.com/mysqlbook/sampler/mysqled1ch20.html
PB
-
Matt Juszczak wrote:
Hi all,
I'
How about:
$id1 = 1;
$id2 = 0;
while ($id1) /** or ($id2 != 8) **/
{
$sql = "select * from table where id1=$id1";
$row=query($sql);
$id1=$row->id1;
$id2=$row->id2;
do_stuff();
$id1 = $id2
}
On Tue, June 19, 2007 10:58, Matt Juszczak wrote:
> Hi
Nathan,
>I ve recently been playing with storing trees in mysql using nested
>set, and I was wondering if anyone knows if this could be extended to
>forests (set of trees) to be stored in one table?
Dead simple, add a treeID smallint column to the table that holds the
nested sets, and add ... W
Hi,
In my honest opinion, uploading the image to a "preset" directory in the
code, and setting the code to submit the image name, extension, and if
needs be (it shouldnt, because you can set it in the HTML), the
directory. Google has a lot of useful resources on this.
But, if you are really
I've stored millions of images/files in mysql with minimal performance
hit, performance loss is mostly based on your storage implementation.
Checkout this article:
http://www.dreamwerx.net/phpforum/?id=1
On 10/11/06, Greg Donald <[EMAIL PROTECTED]> wrote:
On 10/10/06, Rodney Courtis <[EMAIL PRO
On 10/10/06, Rodney Courtis <[EMAIL PROTECTED]> wrote:
I want to store jpeg images in a mysql database from php in the form of 'blob'
types.
Is this possible and can you detail for me the steps to achieve this?
For a nice size performance hit, yup:
http://www.zend.com/zend/trick/tricks-sept-2
That is up to 64k bytes, not chars, which might not be the same thing if
UNICODE is used using utf-8/utf-16 or ucs-2 for example. Although this
is usually not an issue in the specific case of an URL.
/Karlsson
Johan Höök wrote:
Hi Peter,
I'd thought I'd just mention that the varchar length
dep
the urls never repeat. and it's a very active table so I don't wanna
compress right now.
And you're right, most URLs are < 255chars, but some are bigger, so
can't use varchar.
I guess I'll just use TEXT :)
Thanks!
Peter
On 9/12/06, Mike Wexler <[EMAIL PROTECTED]> wrote:
Peter Van Dijck wrote:
Peter Van Dijck wrote:
Hi,
URL's have a practical limit of 2083 characters it seems. To store
these in a space efficient way (I have 1,000,000s of url rows), what's
the best approach? varchar has a 255 maximum, right? Should I just use
TEXT? I'm not searching *in* the urls, I am selecting like th
Hi Peter,
I'd thought I'd just mention that the varchar length
depends on your MySQL version and character set.
5.0.3 and later handles upto 64k chars.
See: http://dev.mysql.com/doc/refman/5.0/en/char.html
/Johan
Peter Van Dijck skrev:
Hi,
URL's have a practical limit of 2083 characters it seem
Hello.
> If I retrive the same value with the slash (\), not able to display
> properly in the GUI. Do we need to use any MySQL specific functions to
> select such values?.
If you're retrieving the same values which have stored, that this is
rather a GUI problem, not MySQL.
> Is there any way in
--- [EMAIL PROTECTED] wrote:
> Please, please! read up on normalization. The way I
> would probably handle
> this design issue is by creating a separate table of
> taxonomic names (I
> know this is very different than my previous advice
> but I have had longer
> to think about it).
OK, I'll ha
David Blomstrom <[EMAIL PROTECTED]> wrote on 08/26/2005 01:32:08
AM:
> (Sorry if this is a repeat; I think my first post
> didn't go through.)
>
> I'm still stuck on the problem I asked about a day or
> two ago. I'm working on a page at
> http://www.geozoo.org/stacks/ that draws data from a
> ta
David Blomstrom wrote:
I'm still stuck on the problem I asked about a day or
two ago. I'm working on a page at
http://www.geozoo.org/stacks/ that draws data from a
table that lists animal taxons (orders, families,
species, etc.) in a child-parent relationship.
It works exactly the way it should
C.F. Scheidecker Antunes wrote:
I will have the password stored in the database with MD5.
What I actually need is a manual way to get the password back, that is
decoding it.
The whole point of MD5 is that you cannot decode it once encoded.
When someone enters their password, just MD5 what th
C.F. Scheidecker Antunes wrote:
I am sorry. I meant another thing and wrote something else.
If I issue: INSERT INTO table1 values ('username',MD5('password'))
I will have the password stored in the database with MD5.
What I actually need is a manual way to get the password back, that is
dec
I am sorry. I meant another thing and wrote something else.
If I issue: INSERT INTO table1 values ('username',MD5('password'))
I will have the password stored in the database with MD5.
What I actually need is a manual way to get the password back, that is
decoding it.
By using a software th
MySQL actually has an MD5() function:
mysql> select MD5('password');
+--+
| MD5('password') |
+--+
| 5f4dcc3b5aa765d61d8327deb882cf99 |
+--+
1 row in set (0.18 sec)
Partha
--
Partha
On Saturday 23 July 2005 09:05am, Gregory Machin wrote:
> Hi all.
> I'm writing a php script to store the contents of html and php pages
> in a data base, it works well until there are mysql queries in the
> pages source then give errors such as this one.
>
> Query failed: You have an error in your
Gregory Machin wrote:
Hi all.
I'm writing a php script to store the contents of html and php pages
in a data base, it works well until there are mysql queries in the
pages source then give errors such as this one.
Query failed: You have an error in your SQL syntax near 'temp'
how do stop mysq
Gregory Machin wrote:
Hi all.
I'm writing a php script to store the contents of html and php pages
in a data base, it works well until there are mysql queries in the
pages source then give errors such as this one.
Query failed: You have an error in your SQL syntax near 'temp'
how do stop mysq
Per Jessen wrote:
3. Again, as you can understand, I want to minimize the cost here. If
you don't think I can use mysql, do you think Microsoft SQL server is
good enough for this task?
I don't think so, no.
what are you basing this on?
SQL Server is a truly great database package, don't l
First of all, I heard that Mysql does not perform very well when
tablesize goes above 1 Gb. Is this a myth?
I don't have much experience with individual tables being that large,
though I have used MySQL databases with >100G total data with no
problems at all. Based on my experience, it's not th
Cabbar Duzayak wrote:
> So my questions are:
>
> 1. The main question is, do you guys have any experience with this
> much binary and regular data? Do you think Mysql can handle this much
> data in a reliable manner (without corrupting data and/or
> degrading/terrible performance) ?
I would say
Sometimes, the easiest way to do this is to use the file system of the linux
machine to store the files, and make reference to them in the DB...storing
not data in the DB and getting rid of all your possible problems.
Thanks,
Matt Babineau
Criticalcode
858.733.0160
[EMAIL PROTECTED]
http://www
hi,
have you tried to hack something with week, month and weekofyear ?
there is an interesting url at
http://dev.mysql.com/doc/mysql/en/date-and-time-functions.html
be aware that the week begins on sunday.
mysql> select weekofyear('2005-01-02');
+--+
| weekofyear('2005-01-0
Bob,
You should check out the Date::Manip module from CPAN, it will do what you
need to do. Here is a snippet from the docs about recurrence:
RECURRENCE
A recurrence is simply a notation for defining when a recurring event
occurs. For example, if an event occurs every other Friday or every 4
[EMAIL PROTECTED] wrote:
Uh-oh ;-)
I think you put the HEX in the wrong part. Shouldn't it be in the VALUES
clause?
snprintf(query_length,query,"INSERT INTO
idsmatch(sip,sport,dip,dport,payload)
VALUES('%s',%d,'%s',%d,HEX('%s'))",
inet_ntoa(ip->saddr),dbsport,inet_ntoa(ip->daddr),dbdport,t
Uh-oh ;-)
I think you put the HEX in the wrong part. Shouldn't it be in the VALUES
clause?
snprintf(query_length,query,"INSERT INTO
idsmatch(sip,sport,dip,dport,payload)
VALUES('%s',%d,'%s',%d,HEX('%s'))",
inet_ntoa(ip->saddr),dbsport,inet_ntoa(ip->daddr),dbdport,temp);
Shawn Green
Database A
Hi,
snprintf(query_length,query,
"INSERT INTO
idsmatch(sip,sport,dip,dport,HEX(payload))VALUES('%s',%d,'%s',%d,'%s')",
inet_ntoa(ip->saddr),dbsport,inet_ntoa(ip->daddr),dbdport,temp);
--
Philippe Poelvoorde
COS Trading Ltd.
--
MySQL General Mailing List
For list archives: http://lists.m
Not sure whether this is applicable to your version of mysql, or to PHP.
I had the same problem using Macromedia's Coldfusion, and adding this:
useUnicode=true&characterEncoding=UTF-8
to the db connection string solved the problem
chris
-Original Message-
From: MySQL [mailto:[EMAIL PROT
> From: [EMAIL PROTECTED]
> Date: Sun, 5 Sep 2004 22:39:39 -0500 (CDT)
> Subject: Re: Storing foreign characters in DB
>
> I am not using 3.xx versions anymore, but if I remember correctly they
> only allow a limited control for setting character sets.
>
> In order to
Hello Rhino,
(B
(BI am not sure how familiar you are with the character set settings.
(B
(BI am not using 3.xx versions anymore, but if I remember correctly they
(Bonly allow a limited control for setting character sets.
(B
(BYour best guess might be the documentation that comes with your in
- Original Message -
From: "MySQL" <[EMAIL PROTECTED]>
To: "MySQL" <[EMAIL PROTECTED]>
Sent: Sunday, September 05, 2004 2:05 AM
Subject: Storing foreign characters in DB
I'm having a problem figuring out how to deal with foreign characters in
text that was copied from an MS Word documen
Sheraz <[EMAIL PROTECTED]> wrote on 04/08/2004 13:14:26:
> Hi
> I need to store a globabl unique identifer value in
> mysql4.x database table.
>
> table field is varchar(16) as the string length is 16
> byte or 128 bitsmy string data is unsiged char
> type..
>
> how can i send that
thank you very much
On Tue, 3 Aug 2004 20:08:51 -0500 (CDT),
[EMAIL PROTECTED] <[EMAIL PROTECTED]>
wrote:
> Hello,
>
> I have made apresentation at MySQLs UC2004 about using Japanese character
> sets with MySQL. You may find this a good starting point. Links are below:
>
> http://dev.mysql.com/d
Hi Victor,
Thanks for your reply. Yes, I did mean to only replicate certain tables,
so your answer fits to a tee. Thanks!
On Wed, 2004-05-26 at 01:12, Victor Pendleton wrote:
> What do you mean by storing a subset? Are you only wanting to replication a
> portion of the tables? If so, you can conf
What do you mean by storing a subset? Are you only wanting to replication a
portion of the tables? If so, you can configure the master to ignore certain
databases or you can configure the slave to apply updates for certain
databases/tables or prohibit the master from replicating certain
databases/t
Have you tried insertig non-breaking space instead #160 or 0xA0 ...i think so
" " - this shoud be it /taken from here "3,02 KB (3 098 bytes)"-All
NON-Breaking/
HTH ;-)
John Mistler wrote:
> Is there a way to force an invisible "space" character to be stored at the
> END of a string in a column (e
At 1:54 -0700 4/30/04, John Mistler wrote:
Is there a way to force an invisible "space" character to be stored at the
END of a string in a column (either VARCHAR or CHAR), so that when it is
retrieved the space at the end is not cut off?
No. I suggest that you use one of the TEXT types instead, wh
Hi John,
I *think* VARCHAR is *supposed* to work that way, but doesn't in MySQL.
So you'll have to use TINYTEXT. Its storage requirements are the same
as VARCHAR(255) and it behaves the same way, except for, I think, 3
things: 1) the trailing space thing, obviously; 2) it can't have a
DEFAULT val
[EMAIL PROTECTED] wrote:
hi,
thanks for the info. I'm not very sure about mysql. but this is what ive
got.
ive got three tables with data in it.need to save the tables and run it on
another machine or rather view the tables and records in another machine.
1. if i use mysqldump query, it will
hi,
thanks for the info. I'm not very sure about mysql. but this is what ive
got.
ive got three tables with data in it.need to save the tables and run it on
another machine or rather view the tables and records in another machine.
1. if i use mysqldump query, it will prepare a backup right?
mysqldump when ensure consistency. If you are using InnoDB or DBD you run
the risk of data not being committed.
-Original Message-
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: 4/27/04 4:06 PM
Subject: storing
hi,
i have mysql on my local machine.and i have created tables in my
On Tue, 27 Apr 2004 17:06:59 -0400 (EDT), wrote:
>hi,
> i have mysql on my local machine.and i have created tables in my database.
>if i need to copy these tables onto a cd and transfer them , which folder to i
>copy? is it the data directory under mysql???
>
>i am not sure abt this.
>
>Thank
> Unfortunately there is no standard way, i use a
> directory called includes
> and within that include_top.php includes global
> stuff across pages and a
> functions.php for functions and defines.php for
> defining constants.
> parse_ini_file is ok , i have used a modified
> function to allow mult
>>
>> --Bruce
>>
>
> There are many different options. php-general list
> might have something in the archives.
>
> Usually my preferred method is storing application
> wide settings and commonly used functions in a file
> that is included on each page.
>
>
>
> You might also take a look at parse
--- Bruce Vander Werf wrote:
> I am developing a php/mysql web application, and I
> am facing the task of
> storing application settings. Because it is web
> based, I will need to
> read the app settings on a per-session basis.
>
> I see one of two choices here - store each setting
> as a separat
* Asbjørn Konstad
> Ive spent some day(s) probing the web to find a solution to this problem:
>
> A table-column for storing currency > float(10,2).
>
> As my users are punches the currency value like this 255,55,
> with a comma as decimal point, MySQL stores this value as zero (0.00).
>
> I qu
Just convert the format of the input in your program before saving the value. In
VB/ASP us can do: replace(255,55,",",".")
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi Asbjørn,
try to use "replace" function:
http://www.mysql.com/doc/en/String_functions.html
update YourTable set YourMoney = REPLACE('255,55', ',', '.') where ... ;
Best regards,
Mikhail.
- Original Message -
From: "Asbjørn Konstad" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: M
An unsigned int is probably more appropriate for timestamps than a
signed int.
Also note that the range for timestamps is 1970 until 2038 (or 2106? for
unsigned ints), where DATE and DATETIME have a much greater range. Using
a UNIX timestamp for birthdays might not be appropriate.
Fred,
> An unsigned int is probably more appropriate for timestamps than a
> signed int.
Thank you, that was the kind of advice I was looking for. And your point
about not using UNIX time stamps for birthdays and things that could
well be outside their date range is well taken. I'm only u
Dave,
On Thu, Jan 08, 2004 at 09:57:46AM +0900, Dave G wrote:
> Because of time zone differences between my web site's intended
> audience (Japan) and my server's location (Nevada), I've found that it's
> most efficient, or at least most simple, to do all my time calculations
> in PHP.
>
At 11:25 +0900 1/8/04, Dave G wrote:
Paul,
>(Unix timestamps are ten digits, aren't they?).
No, they're fourteen digits: CCYYMMDDhhmmss
I think we might be talking about different things. A UNIX time stamp is
ten digits long:
http://www.unixtimestamp.com/
How MySQL stores it's own TIMESTAMP col
Paul,
> >(Unix timestamps are ten digits, aren't they?).
> No, they're fourteen digits: CCYYMMDDhhmmss
I think we might be talking about different things. A UNIX time stamp is
ten digits long:
http://www.unixtimestamp.com/
How MySQL stores it's own TIMESTAMP column is the format you describe.
At 9:57 +0900 1/8/04, Dave G wrote:
MySQL Gurus,
Because of time zone differences between my web site's intended
audience (Japan) and my server's location (Nevada), I've found that it's
most efficient, or at least most simple, to do all my time calculations
in PHP.
Up to now, I've s
True initially... What I've done is use a java appserver frontend (orion)
that's a caching server.. It gets the request, checks if it has the image
in it's memory cache, if so serves it, otherwise goes to the backend and
gets it, stores in memory cache, serves it..
Very fast and aleviates alot o
16MB? you mean the max packet per query limit? If your storing data in
huge/large blob then you are making a big mistake in my opinion and taking
a huge performance hit... I've got files over 1GB in size in mysql now..
they went in and out at almost filesystem speed...
On Sun, 14 Dec 2003,
I'd agree with chris. I've got a ton of data/files in mysql for years
now and no problems... The thruput in/out is increadible if you implement
the storage handler correctly.
Plus it gives you certain advantages such as security/scalability/etc...
With storing the files on disk, the files nee
This page has sample article/code how to store any type/size of file in
mysql.. Depending on the appliation it could be a good idea (such as
revision control or something)
http://php.dreamwerx.net/forums/viewtopic.php?t=6
On Fri, 12 Dec 2003 [EMAIL PROTECTED] wrote:
> I am working with a pro
> With the NAS - what's to say that MySQL's retrieval and
> network protocol
> is not more efficient than whatever is running on your NAS boxes?
Well, currently we work like so:
Client <-> Webserver/Application Server <-> Database
The database returns file names to the application/webserver (y
Forgot something in my other reply.
With the NAS - what's to say that MySQL's retrieval and network protocol
is not more efficient than whatever is running on your NAS boxes?
Conversely, MySQL's current 16 MB per transfer limitation may very well
not allow it to act in this role at all.
Ah, the
Talk about a decent reply!
For web site stuff, having control over everything is pretty much a
requirement (if you want to do anything non-trivial). The way that I
serve images from the database is by parsing URLs and I've found that
the performance is very good. The fact that I can move stuff aro
Really? In both cases, it's just bits on a disk. In the case where you
don't have access to a shared file repository for your client apps, you
haven't got the option of just storing paths.
Regards,
Chris
On Sat, 2003-12-13 at 23:30, Sime wrote:
> Chris Nolan wrote:
> > Personally, I would have t
> you could very well do that, and frankly that is how alot of websites
> work.
Yep, including one I run. That site has to generate and links
for visitors, and it seems far easier to return "/pics/imagefoo.jpg" then
the image itself and decide how to embed that into the page.
> But storing th
Chris Nolan wrote:
> Personally, I would have to disagree. I have just completed a
> year-long
> uni project whereby we built some software that stored massive images
> in InnoDB tables. We found that the performance was (at very worst)
> comparable to the alternative method.
>
> Additionally, this
Personally, I would have to disagree. I have just completed a year-long
uni project whereby we built some software that stored massive images in
InnoDB tables. We found that the performance was (at very worst)
comparable to the alternative method.
Additionally, this method is better on many levels
On Fri, Dec 12, 2003 at 02:54:44PM -0600, [EMAIL PROTECTED] wrote:
> Hi all,
> I am new to mysql and I was wondering if someone could point me in the
> right direction on how to store .tar and .tar.gz (bzip2) files inside a
> mysql database. I have googled to try and find some help there but most
I am working with a project on sourceforge http://leopard.sourceforge.net
and this is one of the package management stratagies we are thinking about
trying. As I said I have almost no experience with mysql so I open to any
and all suggestions. Very good points being made about the size of the
rows.
On Fri, Dec 12, 2003 at 02:54:44PM -0600, [EMAIL PROTECTED] wrote:
I am new to mysql and I was wondering if someone could point me in the
right direction on how to store .tar and .tar.gz (bzip2) files inside a
mysql database. I have googled to try and find some help there but most
I believe the dat
Can I ask why?
Why not define a char(50) (or whatever size) with the relative or complete
path to the .tar file? Storing it in your database would create huge row
sizes.
Joshua Thomas
Network Operations Engineer
PowerOne Media, Inc.
tel: 518-687-6143
[EMAIL PROTECTED]
---
In theory there is no
In the last episode (Nov 29), David Garamond said:
> >It seems the string in CHAR/VARCHAR is stored as null-terminated ala
> >C. But why is record 3 rejected too?
>
> Ugh, never mind. I forgot about the automatic trailing blanks removal
> feature. Well, since trailing blanks are always removed, i
David Garamond wrote:
insert into t1 values (3,char(32));
Record 3, 5, and 7 is rejected due to duplicate value.
++--+--+
| id | length(code) | code |
++--+--+
| 1 |0 | |
| 2 |1 | 0|
| 4 |2 | 0 0 |
| 6 |
Hello ALL
(B
(B
(BHow can a dataset return the default value from the database(MySQL,
(BMSSQL, Interbase).
(BI have try in ADO, dbx, BDE, and the result is not,
(BHow Can I do?
(B
(B
(B--
(BMySQL General Mailing List
(BFor list archives: http://lists.mysql.com/mysql
(BTo unsubscrib
Hi Gabriel,
No, you can't currently modify compressed tables.
For in memory tables, are you aware of the HEAP type for non-critical
data?
You're probably talking regular permanent tables, though. For those, the
OS will use all free memory (that programs aren't using) to cache file
data after it'
In the last episode (Sep 09), Andrew Kuebler said:
> I need to store strings encrypted with TripleDES that sometimes
> contain unprintable characters (Hexidecimal values under 20). The
> values do not seem to properly store in CHAR columns and I don't see
> any other column types that might work.
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
[EMAIL PROTECTED] wrote:
> I'd be willing to bet if you implement serializable, serialize it and dump
> it to a binary column (blob) .. you should be able to restore...
>
If you use PreparedStatements, Connector/J will do it 'automagically'
for you a
I'd be willing to bet if you implement serializable, serialize it and dump
it to a binary column (blob) .. you should be able to restore...
On Fri, 29 Aug 2003, Dennis Knol wrote:
> Hello,
>
> Is it possible to store Java objects in the mysql database?
>
> Kind regards,
> Dennis
>
>
> _
I wonder if you could serialize your object, and then store it in a blob
column.
I'd be interested to know ...
Dennis Knol wrote:
>
> Hello,
>
> Is it possible to store Java objects in the mysql database?
>
> Kind regards,
> Dennis
>
> _
yes, some do end in 'x' as I just discovered. Thanks to everyone for
the input, I have decided to convert to varchar and re-index.
Keith C. Ivey wrote:
On 5 Aug 2003 at 9:49, Eben Goodman wrote:
The data type of the field I am
storing this info in is a bigint(16) unsigned. It appears tha
Eben.
Yes, use a character based data type as the leading zero's are insignificant
and will be removed.
HTH
Kev.
> --
> From: Eben Goodman
> Sent: Tuesday, August 5, 2003 14:49 PM
> To: [EMAIL PROTECTED]
> Subject: storing large integers properly
>
> I am storing
you can create/alter the particular column with 'zerofill' attribute set. i.e.:
create table books (isbn bigint(16) unsigned zerofill, somemore varchar(100));
-yves
-Ursprüngliche Nachricht-
Von: "Eben Goodman" <[EMAIL PROTECTED]>
An: <[EMAIL PROTECTED]>
Gesendet: Dienstag, 5. August
Eben Goodman wrote:
I am storing book isbn numbers in a table. isbn numbers are 10 digit
numbers and many start with 0. The data type of the field I am storing
this info in is a bigint(16) unsigned. It appears that isbns that start
with 0 are going in as 9 digit numbers, the 0 is being ignor
On 5 Aug 2003 at 9:49, Eben Goodman wrote:
> The data type of the field I am
> storing this info in is a bigint(16) unsigned. It appears that isbns
> that start with 0 are going in as 9 digit numbers, the 0 is being
> ignored or stripped. I have experienced this before with integer data
> types
* Eben Goodman
> I am storing book isbn numbers in a table. isbn numbers are 10 digit
> numbers and many start with 0. The data type of the field I am storing
> this info in is a bigint(16) unsigned.
Why not use "BIGINT(10) UNSIGNED ZEROFILL"?
> It appears that isbns that start
> with 0 are goi
How about BIGINT(10) ZEROFILL ?
Eben Goodman wrote:
I am storing book isbn numbers in a table. isbn numbers are 10 digit
numbers and many start with 0. The data type of the field I am
storing this info in is a bigint(16) unsigned. It appears that isbns
that start with 0 are going in as 9 di
ROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, 10 June, 2003 05:42
Subject: Re: Storing negative numbers in AUTO_INCREMENT
>I hate to be the one to ask, but what's the subject have to do with the
>rest of
>the message? I can't see how the two are related at all.
They are not
"rich johnson" <[EMAIL PROTECTED]> wrote:
>
> Short question: I understand that MySQL in some circumstances
> may decide that it's faster to do a full table scan rather than use
> the index to look up values.
>
> But I miss some information on *when* this happens. Is there some
> way, short of re
I hate to be the one to ask, but what's the subject have to do with the
rest of
the message? I can't see how the two are related at all.
They are not :-( I started out using an old draft (which was never sent,
because I figured it out in the meantime). Didn't want to blast away at the
list once a
I hate to be the one to ask, but what's the subject have to do with the rest of
the message? I can't see how the two are related at all.
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: "rich johnson" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tue
"Themis Kafetzopoulos" <[EMAIL PROTECTED]> wrote:
> How can I store procedures in mysql?
Stored procedures will come only in 5.0 version of MySQL server.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
1 - 100 of 184 matches
Mail list logo
