Hi people.
This is my first thread, i hope you can help me.
I'm a newbie and my english is so bad, but, i hope you can understand me.
this is my question:
I've a table TURN with this field
IDTURN (int)
SEASON (string)
SORT (string)
another table GROUP
IDGROUP (int)
IDTURN (int)
a table MATCH
On Fri, May 23, 2008 at 11:20 PM, Velen [EMAIL PROTECTED] wrote:
Hi,
I wanted to know when doing a select query how is it executed :
If there is 1000 records with price10, 3000 records with flag='Y' and the
table contains 200,000 records.
Select code, description, price, flag from
On May 15, 2008, at 1:38 PM, afan pasalic wrote:
hi,
I have a table with tasks. column status could be 1 (means todo)
and
0 (meas done).
also,have column order_no to sort tasks by priorities.
once in a while order_no is not in order, e.g 1, 2, 3, 5, 6, 8, 11,
12, 13, 19, 20,... (some
On May 15, 2008, at 4:30 AM, rustam ershtukaev wrote:
I have been trying to write a trigger in mysql, but can't get it to
work. It's really simple,i just need my trigger to add varchar value
to
a table on insert if postcode = 1000.
Where does postcode come from? Your SELECT statement
Is there anyway of doing what is described below with version 5 or will
I l have to wait for MySQL 6.0
PlanetMySQL Blog: MySQL 6.0 Feature #2: Online Backup
Alexander Nozdrin, Chuck Bell, Lars Thalmann, Peter Gulutzan, Rafal Somla
BACKUP DATABASE copies all data and metadata in
Just execute as the following.
1、create table b like a;
2、alter table b add ;
3、insert into b select a.
4、alter table b rename to a;
On Wed, Apr 16, 2008 at 11:08 PM, Arun Kumar PG [EMAIL PROTECTED]
wrote:
given that my table is in myisam, there are some hacky way of doing this
Also,
The below method will not add it the default values for date's and also will
create the indexes and if any column is set as auto increment, that also
need to be take care.
So, is there a way to take care of the above, in the create table statement
itself.
regards
anandkl
On 5/26/08,
Hi All,
The issue has been solved, we removed relay-log.index files which was
refering to the old relay-log file. After this the CHANGE MASTER worked and
replication is going on fine.
regards
anandkl
On 5/24/08, Moon's Father [EMAIL PROTECTED] wrote:
I think you should check the error with
Replication is a complicated process.I can't see what you do and what happened
for your computer.
From you description,i think you maybe save some old file in your entironment
and some configer parmater point to it.
So,the best way is sending you actions to me step by step and we will analyse