Results 1 to 3 of 3

Thread: Tables keep losing data

  1. 03-23-2018, 12:34 PM #1
    Tanner
    Tanner is offline Registered User
    Join Date
    Mar 2018
    Posts
    3

    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?
    Reply With Quote Reply With Quote
  2. 03-23-2018, 12:35 PM #2
    Tanner
    Tanner is offline Registered User
    Join Date
    Mar 2018
    Posts
    3
    Update: I just tried to look at my table again and now all the rows except for Jonie Weber are gone but Jonie has her last name back. Is this just a server issue?
    Reply With Quote Reply With Quote
  3. 03-23-2018, 12:36 PM #3
    Tanner
    Tanner is offline Registered User
    Join Date
    Mar 2018
    Posts
    3
    Update: also my 2406 table isn't even finding anything anymore when I search for it. I just get "no data selected"
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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