Re: FN-FORUM MySQL

date posted 21st June 2002 19:50

what type of field is 'column'? there isn't a true boolean column type in
MySQL.
I always use tinyint and 1 for true 0 for false. It's easy to query ("WHERE
column" or
"WHERE !column) and easy to flip ("SET column = 1 - column").

Tim Ward
http://www.chessish.com
[EMAIL REMOVED]
----- Original Message -----
From: Andrew Mottershead [EMAIL REMOVED]
To: [EMAIL REMOVED]
Sent: Friday, June 21, 2002 6:41 PM
Subject: FN-FORUM MySQL


> Hello there folks,
>
> In M$ access you can use
>
> SELECT whatever FROM table
> WHERE column = TRUE
>
> What would be the statement to use under MySQL as the TRUE query is not
> valid?
> Also - is the SQL supported by MySQL transact SQL?
>
> I am now going to stop typing the letters SQL
>
> regards
>
> Andrew Mottershead
> Web Developer
> Mindstream Web Design
>
> email: [EMAIL REMOVED]
> tel: +44 (0)1743 718262
> fax: +44 (0) 7092 115513
> web: www.mindstream.co.uk
>
> This e-mail, and any attachment, is confidential. If you have received
> it in error, please delete it from your system, do not use or disclose
> the information in any way, and notify me immediately.
>
>
>
>
> ================================================================
> = ************************* SilkPHP ************************** =
> = ---------> Free PHP Scripts for your web sites = ******************* www.silkphp.com/?fl ******************** =
> ================================================================
>
> Sponsor the forum for as little as £1 at:
>
> http://www.freelancers.net/cgi/sponsor.cgi?action=show
>
>
> Freelancers and Freelance Jobs:
> http://www.freelancers.net
>
> Forum FAQs:
> http://freelancers.netrickery.com
>
> To unsubscribe please email:
> [EMAIL REMOVED]
>
> If you have difficulties unsubscribing please email:
> [EMAIL REMOVED]
>