Every SQL database requires the ability to locate a record which is unique
in some way. You can't have two records which look the same.
That's why you need to define a primary KEY on a column or coumns.
You need to read a primer on SQL databases

Alan


> -----Original Message-----
> From: 3mip1s4la-Emilio Pisanty [mailto:emipisala@;lancaster.edu.mx]
> Sent: Sunday, 10 November 2002 11:34
> To: R. Hannes Niedner
> Cc: MySQL Mailinglist
> Subject: Re: little problem, I need some help...
>
>
>
> > > tables have met with a 1175 error ("You are using safe update
> mode and you
> > > tried to update a table without a WHERE that uses a KEY column").
> > Nothing is obvious and is hard to advise you if you don't give
> us some more
> > info on the table structure and the update query you have trouble with.
> >
> > /h
>
> ok. thable structure is this:
> mysql> describe pupils;
> +----------+-------------+------+-----+---------+-------+
> | Field    | Type        | Null | Key | Default | Extra |
> +----------+-------------+------+-----+---------+-------+
> | name     | varchar(20) | YES  |     | NULL    |       |
> | surname  | varchar(20) | YES  |     | NULL    |       |
> | surname2 | varchar(20) | YES  |     | NULL    |       |
> | form     | char(3)     | YES  |     | NULL    |       |
> | tutor    | varchar(20) | YES  |     | NULL    |       |
> | sex      | char(1)     | YES  |     | NULL    |       |
> | birth    | date        | YES  |     | NULL    |       |
> | math     | char(3)     | YES  |     | NULL    |       |
> | optA     | char(3)     | YES  |     | NULL    |       |
> | optB     | char(3)     | YES  |     | NULL    |       |
> +----------+-------------+------+-----+---------+-------+
> 10 rows in set (0.00 sec)
>
> it was built in version 3.23, and we recently updated to 4.0.4 beta.
>
> the query I'm running is
>
> mysql> UPDATE pupuils SET tutor = 'URIOSTEGUI' WHERE group = 'U6U';
> (setting the name of the tutor for Upper 6)
>
> and I meet with:
> ERROR 1175: You are using safe update mode and you tried to
> update a table
> without a WHERE that uses a KEY column
>
> I don't quite understand what a "KEY column" is, can someone
> explain it to
> me? if you can't answer, where can I find error listings? because they
> don't appear to be on the site.
>
> hope this helps you help me...
>
> thanks in advance,
>
>    Emilio Pisanty
>
>
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
>    http://www.mysql.com/manual.php   (the manual)
>    http://lists.mysql.com/           (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
> <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>



---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to