I have not had a need to use that feature in my projects, but sometimes
people have an integer field that must have uniform length, so they
prefer to have the leading portion fill with zeroes.
For instance:
http://groups-beta.google.com/group...090b6cac8da980/
Regards,
Bill K.
billkarwin | Sun, 30 Dec 2007 22:16:00 GMT |
regards,
Khazret Sapenov
"Bill Karwin" <bill...karwin.com> wrote in message
news:cub4ol02ksa...enews3.newsguy.com...
> Khazret Sapenov wrote:
> > What is the practical use of ZEROFILL in your case?
> I have not had a need to use that feature in my projects, but sometimes
> people have an integer field that must have uniform length, so they
> prefer to have the leading portion fill with zeroes.
> For instance:
http://groups-beta.google.com/group...090b6cac8da980/
> Regards,
> Bill K.
khazretsapenov | Sun, 30 Dec 2007 22:17:00 GMT |
The link just demonstrates that there exists a person who has that
requirement to pad integers with zeroes, and the ZEROFILL attribute was
the solution.
I think it's just a convenience. A programmer could format the value
that way after fetching it from the database, but apparently it's a
common enough task that MySQL can do it for you if you need it.
As for why someone would want this, it can help in some documents to
make integers of uniform length, so that they align with each other
regardless of being right- or left-justified.
Regards,
Bill K.
billkarwin | Sun, 30 Dec 2007 22:18:00 GMT |
I know very little SQL and I am using phpMyAdmin to upload a text file to my database.The text file contains dates in the format d/m/yy (so 1st feb would be 1/2/04 without any leading zeros). And it appears that they have to be in yyyy-mm-dd format in the database.How can I upload this text fil...
Im creating a website which is a online text based game... i was wondering what is more logical out of these options:should i create a table for example to do with user's info like:A) All of it in one tableorB)Registration details under one tableGame exp under anotherstats under another etc...
Hi, Ok.. Im about to start a work placement soon and part of my job is to develop a site for estate agents and various agencies. This will use data held on a server which is queried via Php. All the data will be held on a server in the office. Now how many simultanious connections could the MySQ...
Hi,From the manual:You should generally not have any conditions in the ON part that are used to restrict which rows you want in the result set, but rather specify these conditions in the WHERE clause. There are exceptions to this rule.DROP TABLE IF EXISTS `x`.`members`;CREATE TABLE `x`.`members...
Can anybody give a newbie some guidance on how to create an interactive database like Yahoogroup's? (I've set up a test Yahoogroup database if you want to play around with it: http://groups.yahoo.com/group/2004testing/database )Some things I love in particular:1. It's interactive...
I have the zip codes from the USPS in an Access 2000 database available forimmediate download for $2.50 via PayPal. Visithttp://www.digital-recovery.com/zip_code_database.htm for additional infoand to download a demo of the database....
Hello,Greetings!...How would you like to learn the SECRETS of the most powerful"TRUE POWERLINE BUILDING SYSTEM!"that would generate a substantial monthly income in a short period of time.Complete with E-TRAINING, TECHNICAL SUPPORT, AFFILIATES, SEARCH ENGINE AND MUCHMORE.Watch in REAL TIME as hun...
--B458F236ED34C2840E6Content-Type: text/html;charset="iso-6AD1-A"Content-Transfer-Encoding: quoted-printable<HTML><HEAD><TITLE>blochfeel you got ripped off in university? What? no di=ploma?B</TITLE><META http-equiv=3DContent-Language content=3Den-us><META content...
--._B8C434_.F0CA_DE__172_Content-Type: text/html;Content-Transfer-Encoding: quoted-printable<center><font face=3D"verdana" size=3D+3>The only solution to Penis Enlarg=ement</font><br><font color=3D"#FFFFFF></font><br><font face=3D"arial" size=3D+2 col...
Hi,Is it possible to do a exclusive OR (XOR) in MySQL?If I have a table that contains an integer column, I want to get eiterentries with the value 8, 9 *OR* 1 and *only the first* that isfound: if the entry with key 8 is not found, return the result for therow with key '9' - if this on...
Hi AllIve just finished my trial with XmlSpy 2004 and I really liked the way thetable view worked in that and was wondering if there is another cheaperprogram out there that also offers a friendly table view of the info in anxml file. I only need to view Xml data not edit or create any so I dont...
Hello,Is there any program that takes database schema in some decent formatlike XML (or html or plain-text) and generates the following:1. C++ classes that represent each table.2. C++ methods that let me get/set database records of each table.Thanks,KP....
If I'm going to be displaying products from a MySQL database, why shouldn't I just create a while() loop into a table with a pre-determined template/css sheet? Is there a benefit to pushing the files into XML format and injecting them into the XHTML page? I'm trying to see the ben...
Hello,can you please help me. I need to get a hierarchical xml output with just one table and 3 columns. Table looks like thiscontinent country stateEurope Germany BavariaEurope Germany SaxonyEurope Switzerland BaselNorthAmerica USA TexasNor...
--_E779C8.8B.28806E5FContent-Type: text/html;Content-Transfer-Encoding: quoted-printable<html<head><meta http-equiv=3D"Content-Language" content=3D"en-us"><meta name=3D"GENERATOR" content=3D"Microsoft FrontPage 5.0"><meta name=3D"ProgId" content=3D"FrontPage.Editor.Docume...