next bug? 'first' all gone....

[black75]

... now all data are stored, I did following code:

update my_table
set last = 'weber-williams'
where first = 'jonie';

now, all data on the column FIRST is gone...

btw, if i'd have two 'jonie' at first name would be following command correct if I assume there is only one LAST called 'weber'? -->

update my_table
set last = 'weber-williams'
where first = 'jonie' AND last = 'weber';

tia

cheers,
bs

[J_F]

... now all data are stored, I did following code:

update my_table
set last = 'weber-williams'
where first = 'jonie';

now, all data on the column FIRST is gone...

btw, if i'd have two 'jonie' at first name would be following command correct if I assume there is only one LAST called 'weber'? -->

update my_table
set last = 'weber-williams'
where first = 'jonie' AND last = 'weber';

tia

cheers,
bs

That looks correct.

[nosepicker]

And your first UPDATE statement could not have caused all the "first" data to disappear. Either something else must have caused that, or your UPDATE statement was mis-typed.

[black75]

@J_F: thnx!

@nosepicker: thnx for reply... the update statement wasn't in fault, as I copy pasted the same stuff from my txt file (just in case the IE crashes and looses input. I tried it 3 times, the last time then it suddenly worked out, after of course always dropping the table and re-create it afterwards, as all first data in the first column where gone... anyway... I learned some sql, just a pitty i didn't do it earlier, cause i lost a job opportunity...looks easy, sql

cheers