RE: little problem, I need some help...

2002-11-09 Thread Dean Harding
L Mailinglist Subject: RE: little problem, I need some help... 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 r

Re: little problem, I need some help...

2002-11-09 Thread 3mip1s4la-Emilio Pisanty
hello everyone: 1) in my school groups are called forms, so I used it not to confuse you 2) I hadn't learnt how to define indexes on MySQL so I hadn't defined any 3) now I have, and... 4) the query worked. thanks for your help, Emilio Pisanty

RE: little problem, I need some help...

2002-11-09 Thread Alan McDonald
e- > 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

Re: little problem, I need some help...

2002-11-09 Thread John Coder
On Sat, 2002-11-09 at 19:34, 3mip1s4la-Emilio Pisanty wrote: > > > > 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 >

Re: little problem, I need some help...

2002-11-09 Thread Jocelyn Fournier
lt;[EMAIL PROTECTED]> To: "R. Hannes Niedner" <[EMAIL PROTECTED]> Cc: "MySQL Mailinglist" <[EMAIL PROTECTED]> Sent: Sunday, November 10, 2002 12:34 AM Subject: Re: little problem, I need some help... > > > > tables have met with a 1175 error (&quo

Re: little problem, I need some help...

2002-11-09 Thread 3mip1s4la-Emilio Pisanty
> > 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 wi

Re: little problem, I need some help...

2002-11-09 Thread R. Hannes Niedner
On 11/9/02 3:14 PM, "3mip1s4la-Emilio Pisanty" <[EMAIL PROTECTED]> wrote: > hello everyone: > > to begin with, I apologise for asking a question which is probably > obvious. My name is Emilio Pisanty and I and one of the two makers of my > school's website. recently we updated the database system

little problem, I need some help...

2002-11-09 Thread 3mip1s4la-Emilio Pisanty
hello everyone: to begin with, I apologise for asking a question which is probably obvious. My name is Emilio Pisanty and I and one of the two makers of my school's website. recently we updated the database system (on mysql) from version 3.23 to version 4. since then, any attmepts we've made t