Re: Access to MySQL from Linux command line

Hi Adam. I need to get all the data. Andrew Adam wrote: Drew, That's vague. Specifically what do you want from the Access database (e.g. schema, data, etc.)? A-

Access to MySQL from Linux command line

Hi All. Does anyone know of any tools to convert a MS Access file to MySQL from the Linux command line? Thanks. Andrew

RE: Sorting by a comma list

Excellent. Worked like a dream. Thanks. Andrew -Original Message- From: news [mailto:[EMAIL PROTECTED] On Behalf Of Harald Fuchs Sent: 23 September 2004 15:14 To: [EMAIL PROTECTED] Subject: Re: Sorting by a comma list I think SELECT id, title, description FROM table1 WHERE id IN

Sorting by a comma list

Hi Everyone. I'm not sure if this is possible of not, but I want to sort a query by a comma list. Here is what I'm doing: SELECT id, title, description FROM table1 WHERE id IN (4,1,3,6,8,2) This returns the results ok but they are not in any particular order. I want the result in the order the

RE: In Statement Help

Help Andrew Dixon <[EMAIL PROTECTED]> wrote: >Hi Everyone. > >I require some help with an IN statement I'm trying to get working. I >have inherited a database from someone else in which there is a table >with project information and a field containing which geograp

RE: In Statement Help

Hi Rhino I had pretty much already suggested doing that, but I have been told that I'm not allowed to redesign the database as there is already lots other code working on it already that would need changing as well. I personally think the database design is terrible, but I have to work with what I

In Statement Help

Hi Everyone. I require some help with an IN statement I'm trying to get working. I have inherited a database from someone else in which there is a table with project information and a field containing which geographic regions the projects relate. As a single project can relate to multiple geograph

RE: GUI for mysql

Hi. Navicat is excellent and a linux version is available. I would assume it is the same as the windows version but I have not used it personally. http://www.navicat.com/linux_overview.php3 Best Regards >>> Andrew SpamNet - Stop spam immediately and help me too! www.cloudmark.com/spa

RE: Query Help

Excellent, thanks for that. I have used the first way as the second way gave me different results (lower record count) from what I was getting with it via a server side script. The first way provide me with the same record count. Thanks. Best regards >>> Andrew Dixon

RE: Query Help

Already tried that, but is 2 appears at the end of the list is doesn't get picked up because there is no comma at the end of the list Best regards >>> Andrew Dixon -Original Message- From: Dean Urmson [mailto:[EMAIL PROTECTED] Sent: 11 June 2004 12:53 To: [E

Query Help

d, gallery_name FROMgalleries WHERE keywords Hope that makes sense, thanks in advanced. Best Regards, Andrew Dixon. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Help with a SELECT Statement

Hi Everyone. I have the following SELECT statement the get information from two tables. The statement only works when it finds a value for the image_archive.circuit value in the circuits table. However, not all entries in the database has a value in the this field, some are set to 0 as the circui

MySQL FULLTEXT maximum score?

nk you very much. > > >Best regards > >>> Andrew Dixon > >www.mso.net >Head Office Tel: + 44 1474 813816 >Head Office Fax: + 44 1474 813819 >Sales & Marketing Office Tel: +44 1892 610225 ---

UPDATE SELECT

Hi everyone. I'm trying to do the following update, which someone at Macromedia gave me, however I get a SQL error when I'm trying to use it with MySQL, any ideas on what is wrong. update general_users set rolling_total = sumUsr.rollingTotal from ( select id,sum(jan+feb+mar+apr+may+jun+jul+aug+s