-
Tables keep losing data
I've made my table twice now. Once as myemployees_tb2406 and again as myemployees_tb0624, both times I've had an issue after attempting to update data. The original insertion of data works fine but when I try to update it I lose a columns worth of data and nothing else updates properly.
my last command on the 0624 variant was
update myemployees_tb0624 set Age = Age+1 where First = Dirk and Last = 'Smith'; (Dirk should be in single quotes). Did the lack of single quotes on Dirk cause an error that cleared a column? or is something else going on?
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
|
|