Re: Hardware Raid and 2 Gig Limit

2003-11-03 Thread Steve Vernon
THanks everyone for all your help! Steve - Original Message - From: "Pete Harlan" <[EMAIL PROTECTED]> To: "David T-G" <[EMAIL PROTECTED]> Cc: "mysql users" <[EMAIL PROTECTED]>; "Steve Vernon" <[EMAIL PROTECTED]> Sent: Frida

Re: Hardware Raid and 2 Gig Limit

2003-10-31 Thread Steve Vernon
ovatt" <[EMAIL PROTECTED]> To: "Steve Vernon" <[EMAIL PROTECTED]>; "Mysql List" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Friday, October 31, 2003 12:17 PM Subject: RE: Hardware Raid and 2 Gig Limit > Hi > > We have a similar challenge

Re: Hardware Raid and 2 Gig Limit

2003-10-31 Thread Steve Vernon
I looked into big tables for myself and everyone said you need the raid option in MySQL. Now I'm not sure! Thanks, Steve - Original Message - From: "David T-G" <[EMAIL PROTECTED]> To: "mysql users" <[EMAIL PROTECTED]> Cc: "Steve Vernon" <

Hardware Raid and 2 Gig Limit

2003-10-31 Thread Steve Vernon
Hello, Does the 2 Gig file size limit on Linux get broken when I have a hardware raid controller? My ISP says I don't need the raid option activated on MySQL. Thanks, Steve -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com

date_format function - German

2003-10-22 Thread Steve Vernon
Hello, I have read and searched the internet, but I cannot find much on getting mysql to return German and other languages months. Is there codes you use? I really would prefer to use the English MySQL (if there is such a one) as I don't know much German, and need the error messages in English!

Double Select?!

2003-03-05 Thread Steve Vernon
Hiya, Any help would be appreciated! Due to various hardware requirements, on our exiting server space is a problem not speed. I store a lot of details of members, and have worked out that I will save space by storing lastname's, firstname's etc in a seperate table. e.g. lastname

Re: Year Lists

2003-01-02 Thread Steve Vernon
But don't blame me if the query is grossly inefficient! > > Nick Elliott > > - Original Message - > From: "Steve Vernon" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Tuesday, December 31, 2002 10:44 AM > Subject: Re: Year Lists > >

Re: Year Lists

2002-12-31 Thread Steve Vernon
y). up to 2003 Ideally if a year does not have any projects it would not be listed. Any more help would be great, or I could be wrong and you could have the answer! Steve > On Tue, 2002-12-31 at 14:53, Steve Vernon wrote: > > Hiya, > > I have a datab

Year Lists

2002-12-31 Thread Steve Vernon
Hiya, I have a database about projects in a company, they all have a start year and end year. If the projects have not ended then they get a end year of . I have made a SQL command, given a year, works out with projects are running in that year. The company I am doing this for, wants b

DISTINCT on one collum

2002-12-20 Thread Steve Vernon
MySQL as the filter stupidly does not match SELECT Hiya, How do you get a disctinct value from one collumn only? I am basically using it to construct a dynamic menu, and need the menu names at a level. Items are in one table, like CATEGORY, SUBCATEGORY, SUBSUBCATEGORY, PAGE, ID I cou

Re: unicode encoding

2002-12-02 Thread Steve Vernon
Hiya, Have you got a rough timescale as to when 4.1 will come out? If not then is there a way to simulate Unicode in MySQL? THanks, Steve XX - Before posting, please check: http://www.mysql.com/manual.php

Re: i'm just missing something

2002-11-19 Thread Steve Vernon
There is a mysql database with a user table in it. Add a new user, then reload the database! Remember to password the password. And it will work! > I been tring to read the docs on the website, and tried looking it up, but > i'm getting confused. I am trying to make a database and a user. > to m

large Scale Storage

2002-11-05 Thread Steve Vernon
Hello, I am working on a website for a client which is basically biological database, and some have pictures, I am not allowed to give more out. It will be stored in MySQL. Basically the client says there are about 500 million different items of data, which each holds about 10 small text f