You don't need to be at the mysql> prompt to run it, just run this from the
DOS prompt:
mysql
To: <[EMAIL PROTECTED]>
Cc: "barbara" <[EMAIL PROTECTED]>
Sent: Friday, October 26, 2001 2:15 PM
Subject: how to run sql script in NT
> i am extremely new at this:
>
> i am on NT4.0
>
> i am in a DOS
Hi
You can store Unicode text in a binary column (BLOB) and convert it to/from
native Unicode format in your application. The most efficient form is likely
to be UTF-8 format, which has a variable character length (the lower 128
characters are the same as ASCII).
I have such a database that is st
Chris
Are those columns really character types, or integers ?
The values you list are quoted, which suggests they're character based, but
'id' suggests integers, ie.
insert into match (league_id,round_id,team_id_1,team_id_2) VALUES (1,3,2,3);
Phil
- Original Message -
From: "Chris Ait
ontain some sort of
lookup into the table to allow the row itself to be retrieved ? Or, if rows
are variable length, does MySQL have to do a linear scan through the
database to find the row ? That's what I'm wondering because of the
reference manual warning about variable length ro
Hello all
Grateful for any help on this -
I have a table (definition for MAIN below) with a number of indexes
corresponding to various frequently used queries.
A SELECT statement using one of the multi-column indexes is running very
slow if it retrieves data that is not in in the index itself. F
