RE: Simple problem: Blank search box returns all records

the 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: Problem with query

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 query Hi Paul! On Sat, 27

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]] Sent: 25

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

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

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

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 problem

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. Andrew Murphy -Original

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:

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: 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

RE: Help needed getting table headings into an outfile

the 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 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: 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 [mailto:[EMAIL

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

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