storing months in mysql 4

Hello, I'm using PHP 4 and MySQL 4. I want to store the month and year
as a single row but I am having difficulty figuring out the best data
type to use. I suppose I could use 'DATE' and then always have the day
value be equal fto 1, but I figure there's a more elegant approach. I
leave it to on e of you experts to recommend one.

Thanks in advance, - Dave

.

Relevant Pages

  • Re: storing months in mysql 4
    ... I'm using PHP 4 and MySQL 4. ... I want to store the month and year ... >as a single row but I am having difficulty figuring out the best data ...
    (comp.lang.php)
  • Re: storing months in mysql 4
    ... > I'm using PHP 4 and MySQL 4. ... I want to store the month and ... > year as a single row but I am having difficulty figuring out ...
    (comp.lang.php)
  • Re: why would i want to put my mysql password in the yml fil
    ... having "correct file permissions". ... Typically the server component (like MySQL) doesn't store your ... database connection. ...
    (comp.lang.ruby)
  • Re: how do I store a binary file in a MySql database, as a string?
    ... a string, and then store in a MySql database, in, say, a MediumText ... I realize that MySql supports binary fields, ... can store the file without changing my current schema. ... Can I recreate the file later, if I wish, just be grabbing the string ...
    (comp.lang.php)
  • Re: how do I store a binary file in a MySql database, as a string?
    ... I realize that MySql supports binary fields, ... current MySql schema does not have any binary fields, ... wondering if I can store the file without changing my current schema. ... AFAIK you need to use blob fields as your data is binary (or is it, ...
    (comp.lang.php)