RE: Problem with query

=NULL" gives the same results as " WHERE xx IS NULL". Or would that be an unusual thing to request. Andrew Murphy -Original Message- From: jim barchuk [mailto:[EMAIL PROTECTED]] Sent: 27 October 2001 8:32 pm To: Paul DuBois Cc: [EMAIL PROTECTED] Subject: Re: Problem with quer

RE: Simple problem: Blank search box returns all records

requests off to mysql so the query will be simpler, and therefore execute much faster. Andrew Murphy -Original Message- From: BadgerBay [mailto:[EMAIL PROTECTED]] Sent: 27 October 2001 6:00 am To: [EMAIL PROTECTED] Subject: Simple problem: Blank search box returns all records How do I avoid

RE: how to run sql script in NT

Hi, Try typing: mysql < Temp.sql while at the DOS prompt. Andrew -Original Message- From: Barbara Ferrell [mailto:[EMAIL PROTECTED]] Sent: 26 October 2001 2:15 pm To: [EMAIL PROTECTED] Cc: barbara Subject: how to run sql script in NT i am extremely new at this: i am on NT4.0 i

Dont want to unsubscribe from mysql list

Im not very happy about this :( Someone is trying to unsubscribe me from the MySQL mailing list! I havent confirmed the request as I dont want to unsubscribe. Who is '[EMAIL PROTECTED]' ??? Andrew Murphy -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]

RE: Question about Encrypt function and Windows 2000 (Help a Newbie!)

How about using only one-way passwords. You could check that the encrypted version of their entry matches the stored password data. Its much safer not decrypting anything like passwords. Andrew -Original Message- From: Jeb [mailto:[EMAIL PROTECTED]] Sent: 24 October 2001 10:41 am To:

RE: Party!!!

Sounds good, as the (altered) saying goes: Life begins at 4.0! -Original Message- From: Deryck Henson [mailto:[EMAIL PROTECTED]] Sent: 04 October 2001 4:00 pm To: MySQL Subject: Party!!! Hey everyone! As most of you know the official (as in, not using a BASH shell) release of MySQL

RE: Non Ascii characters

Hi, Have you tried escaping the euro character '\€', maybe that would work for you. Andrew Murphy -Original Message- From: Jamie Smith [mailto:[EMAIL PROTECTED]] Sent: 03 October 2001 11:23 am To: Mysql@Lists. Mysql. Com Subject: Non Ascii characters I'm having a p

RE: Disk-bound joins

Hi, Excuse me if this is wrong, but I think its the INNER JOIN which is slowing down the query. Wouldnt it be better (less memory intensive) to just use: "FROM zipwork1 as z, pctwork1 as p WHERE z.run_id = p.run_id" to join the tables if they are 1-1 related. And

RE: command prompt

Hi, If you want to enter MySQL commands for making tables etc, run 'c:\mysql\bin\mysql.exe' (If thats where its installed on your machine), from either the DOS command line (cmd) or the windows 'Run...' box. Andrew -Original Message- From: John Nyukuri [mailto:[EMAIL PROTECTED]] Sent: 2

RE: Illegal table names

Try using: drop table `resultat impl VT2001`; -Original Message- From: Håkan Elmqvist [mailto:[EMAIL PROTECTED]] Sent: 20 September 2001 9:34 am To: [EMAIL PROTECTED] Subject: Illegal table names mysql> drop `resultat impl VT2001`; ERROR 1064: You have an error in your SQL syntax

RE: Simple SELECT query (or so I thought)

Hi, How about adding and ORDER BY username, giving: SELECT * FROM genomestats WHERE curDate IN ('$curDate', '$lastUpdate', '$lastDay') order by username, wucount desc, rank desc; Andrew Murphy <^oo^> Im a bit of a night owl. -Original Message- Fro

RE: Video game programming????

database, sql, query, table database, sql, query, table (I hate 123box.co.uk) Im not gonna go into long discussions of game programming in here. But the reason most people dont use a database backend for most modern games is more a matter of speed than anything else. You cant get an average of

RE: Help needed getting table headings into an outfile

formatting ok, but it just needs the table headings. Ideally we want to use one or more queries to do this, rather than using mysqldump. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 10 September 2001 11:38 am To: Andrew Murphy Subject: Re: Help needed getting table

Help needed getting table headings into an outfile

Hi, I keep sending this to the list, but im not sure if anyone else is getting it. I hope you can help me with this. I am using the INTO OUTFILE 'filename' function, to create .CSV output files from my queries. Whenever I do this, the table headings are removed from the output. Is there a way t

HELP getting table headings into an OUTFILE

Hi, I am using the INTO OUTFILE 'filename' function, to create .CSV output files from my queries. Whenever I do this, the table headings are removed from the output. Is there a way to get the table headings displayed in the output file? Andrew -

RE: RE: Use of the MySQL logo - licensing agreement

Why not get MySQL to make a series of slightly different logos you can choose from like Sun and other companies do. Some are colour, others greyscale, and some are inverse for placement on black backgrounds. Andrew Murphy -Original Message- From: Ed Carp [mailto:[EMAIL PROTECTED]] Sent

RE: Join Problem

You could try using an AND in the WHERE statement. EG. SELECT DISTINCT R.ID, R.CatCode, R.Title FROM Recipes R, Ingredients I WHERE I.Description LIKE "%$SearchKey%" AND R.ID = I.ID; Hope this helps. Andrew Murphy -Original Message- From: Urb LeJeune [mai

Table headings in OUTFILE

Hi, I am using the INTO OUTFILE 'filename' function, to create .CSV output files from my queries. Whenever I do this, the table headings are removed from the output. Is there a way to get the table headings displayed in the output file? Andrew -