http://cfi.iflywestwind.com/nEACWal3iJ.html
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
ere date>=somedate AND date <= tosomedate
>
> /Henrik
>
You could use a single date column for (year, Julian date) but if you are
constantly querying on the Julian date (based on your application or other
needs) then having that column would be a good thing. Without a colum
The solution is to redesign your tables. You need to split into separate
columns the values you want to maintain. You do not want to keep the "flat
file" design you are currently trying to use.
CREATE TABLE calendar (
objectid,
year,
dayofyear,
... other fields...
)
CREATE TABLE price
"H L" <[EMAIL PROTECTED]> wrote on 04/02/2006 11:51:48 AM:
> Hi, i have a problem to select sum from same table using UNION. The
key
> question is there a way of combining two questions in one so the
resulting
> objectid in query1 is only used in query 2 in a smart way. Eg. if only
one
> o
Hi, i have a problem to select sum from same table using UNION. The key
question is there a way of combining two questions in one so the resulting
objectid in query1 is only used in query 2 in a smart way. Eg. if only one
object is avaliable in a search first year then only check that objectid
- Original Message -
From: "B Wiley Snyder" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, August 26, 2004 10:31 PM
Subject: another newb question for you help...
> Hi again, I'm inserting some test products into my new mysql database but
>
Hi again, I'm inserting some test products into my new mysql database but
it only lets me enter so much? I thought BLOB would allow alot more
characters? Anyway, this was how I constructed the database.
CREATE TABLE jspCart_products (
ProductID int primary key,
CategoryID int,
ModelNumber va
At 05:16 PM 10/17/03 -0700, you wrote:
I desperately need everyone's help.
I normally build database driven websites on NT Servers with an MS Access
database, using perl 5 to read/write the database.
Now I need to build a website that can handle a database with almost a
gigabyte worth of images
On Fri, 2003-10-17 at 20:16, Mike Bailey wrote:
> I desperately need everyone's help.
>
> I normally build database driven websites on NT Servers with an MS Access database,
> using perl 5 to read/write the database.
>
> Now I need to build a website that can handle a database with almost a gi
I desperately need everyone's help.
I normally build database driven websites on NT Servers with an MS Access database,
using perl 5 to read/write the database.
Now I need to build a website that can handle a database with almost a gigabyte worth
of images to catalog (no it's not porn).
Id
On Wednesday 30 January 2002 13:02, Marjolein Katsma wrote:
> At 01:13 2002-01-30, Engr Duke Paul [EMAIL PROTECTED] wrote:
> >NIGERIAN NATIONAL PETROLEUM CORPORATION
> >(DEPARTMENT OF PETROLEUM RESOURCES)
> And he subscribed to this list, right?
> Grrr: database,sql,query,table
Stop griping. I'm
At 01:13 2002-01-30, Engr Duke Paul [EMAIL PROTECTED] wrote:
>NIGERIAN NATIONAL PETROLEUM CORPORATION
>(DEPARTMENT OF PETROLEUM RESOURCES)
And he subscribed to this list, right?
Grrr: database,sql,query,table
--
Marjolein Katsma
HomeSite Help - http://hshelp.com/ - Extensions, Tips and Tools
laszlo wrote:
> Looks like we will *all* get rich!!!
> (Poor guys on Oracle and DB2 lists :-)
>
> laszlo
> P.S.:
> Is this going to be tax-free?
Next time you feel a sudden urge to add to the spam on the MySQL list, please have
the courtesy to delete the message, instead of blindly quoting
HIS IS WHY I
> AM CONTACTING YOU FOR ASSISTANCE. WE HAVE AGREED TO SHARE THE MONEY AS
> FOLLOWS. (i) 30% FOR YOU THE ACCOUNT OWNER. (ii) 60% FOR US(THE
> OFFICIALS) (iii) 10% TO BE USED IN SETTLING TAXATION AND ALL LOCAL/FOREIGN
> EXPENSES. AS YOU MAY WANT TO KNOW AND MAKE YOU LESS CURIOU
SERVANTS ARE FORBIDDEN TO OPERATE OR OWN FOREIGN ACCOUNT. THIS IS WHY I
AM CONTACTING YOU FOR ASSISTANCE. WE HAVE AGREED TO SHARE THE MONEY AS
FOLLOWS. (i) 30% FOR YOU THE ACCOUNT OWNER. (ii) 60% FOR US(THE
OFFICIALS) (iii) 10% TO BE USED IN SETTLING TAXATION AND ALL LOCAL/FOREIGN
EXPENSES. AS YOU
Hello,
I will like to present you, very quickly, with a new Internet
service that i will be putting on line in a few days.
Do you want an account Mail independent of your FAI or ISP ?
What ever your reasons, Avenger Mail System is for you.
Avenger mail System is like Msn, Hotmail, etc
17 matches
Mail list logo