-
next bug? 'first' all gone....
... 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
-
Originally Posted by 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
That looks correct.
-
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.
-
@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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|