Mailing List
Home
MySQL General - General MySQL discussion
MaxDB - Everything about MaxDB, formerly known as SAP DB
MySQL on Win32 - Runing MySQL on Windows 9x/Me/NT/2000/XP
Java Help - Mostly related to the MySQL Connector/J driver
ODBC - ODBC with the MySQL Connector/ODBC driver
Perl - Perl support for MySQL with DBI and DBD::mysql
MySQL++ - Programming with the C++ API to MySQL
Subjects
• mysql openssl Question
• mysql:it 's a db not a dbms how it 's possible?!
• Does the binary log enabling affect the MySQL performances?
• Strange behavior, Table Level Permission
• FULLTEXT query format question
• Preventing Duplicate Entries
• Comparing and writing out BLOBS
• Executing MySQL Commands From Within C Program
• Can 't access mysql after kernel upgrade
• Mysql 4 0 Oracle Stored Procedure Trigger Conversion
• Downgrade Mysql from 4 to 3 23
• MySQL Cluster Software
• mysql test 4 1 fails with the gis test
• ERROR 2002: Can 't connect to local MySQL server through socket
• Getting Identity after INSERT
• Update one field with more fields from another table
• ERROR 1045: Access denied for user: 'root@localhost ' (Using
password: NO)
• mysql have same function mthod as Oracle decode()
 
Search:  
Power your search with and, or, +, -, or "some phrase" operators.
Asterisks in Integer Columns

Asterisks in Integer Columns

2004-06-07       - By Michael Stassen

 Back
Reply:     1     2     3  

David,

Daniel is exactly right. In general, it is not a good idea to try to cram
two pieces of data into one column. Your questions at the end of your post
are good examples of why you don 't do it that way. With a population column
and a separate population_note column, you can easily answer those
questions. The population column is an integer column which only contains
integers. If you don 't want to show the notes, simply select and display
the population values. If you do want to display the notes, then you select
them as well. Once selected, you can display them as you see fit: an extra
"note " column in table form, with superscripts which refer to footnotes, etc.

If you try to put both in the same column, you won 't have integers anymore,
which will screw up sorting by population, will require note-stripping code
when you don 't want to display them, difficulty finding which rows have
notes and which don 't, and so on.

In general, if it answers a different question, it goes in a separate column.

Michael

Daniel Clark wrote:

> One simple option would be to add a footnote column. And add in your
> code, if footnote column is NOT NULL then add a * on to population and
> show footnote at the bottom.
>
> population   footnote
> 100      null
> 200*      yada yada
>
>
> > >Suppose I have several columns of numerals - area,
> > >popoulation, etc. - and I want to include asterisks
> > >and footnotes, as in below:
> > >
> > >200
> > >4200
> > >258*
> > >234
> > >
> > >24
> > >258 <superscript >1 </superscsript >
> > >2400
> > >
> > >What are some good strategies for doing this? You
> > >really aren 't supposed to include asterisks in integer
> > >columns, right?
> > >
> > >It would also be nice to have a strategy that would
> > >give you the option of masking asterisks and footnotes
> > >when you don 't want them displayed.
>
>
>
>
>


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=mysql @(protected)