> From: David T-G [mailto:[EMAIL PROTECTED]]
> ...I still have to figure
> out how to make sure that our credit card types and skill levels don't
> get corrupted (MC, MasterCard, mastercard, ...), but I guess that gets
> enforced in the software interface, right?
Isn't the card type a piece of der
> From: Michael She [mailto:[EMAIL PROTECTED]]
> ...So are you saying that the Windows ODBC MySQL driver
> doesn't support multiple statements?
So far as I know, *no* drivers support multiple statements.
However, that's not what you want for "bulk inserts". What you want is multiple value
sets
> From: Alex Behrens [mailto:[EMAIL PROTECTED]]
> ...How can I make it so only one form
> selection adds a DESC tag to the query, is this possible?
>
> I'm using this code:
>
> $fetch = mysql_query("SELECT * FROM players ORDER BY $var");
>
>
> Name
> Position
> Number
> Grade
>
> I want only t
> mysql> select sum(trial_signups) from campaign_t where
> datestamp='20021204'\g
> ++
> | sum(trial_signups) |
> ++
> |100 |
> ++
>
>
> mysql> SELECT site_id, sum(raws) As RawHits, sum(uniques) As
> UniqueHits,
> sum(t
>If the data contains "\", then database will automatically takes "\"
>away and shift 1 byte left.
>My data will mass up. That is why I still need "\"
Does your data actually include backslash characters? If you want to import them as
they are, you definitely don't want to ESCAPE BY them.
Esca
> -Original Message-
> From: Jörgen Winqvist [mailto:jorgen@;winqvist.net]
>
> I need to let the values in two columns change place with each other.
> I've tried to "update xxx set a=b, b=a" but that doesn't work
> (b=a uses
> the "new" a).
Here's a cute trick for swapping two numbers w
> -Original Message-
> From: Chris Mason [mailto:masonc@;masonc.com]
> [...]
> The problem is, it is easy to test for one amenity, but I need to test
> that the hotel has all of the amenities. The query above
> returns all the
> hotels that have ANY of the amenities, I need the hotels hav