In the midst of me trying to write My Project Proposal here I am in class learning mySQL.
Image Source
NASU has decided to go HAM ( at last) with their strike but it's still not hard enough rme. Most of my colleagues and I walked right from the school gate to the department only to find our classes locked. This led to us having to make use of another class in another department.
Beginner's Class for mySQL is going great...not so bad after all since this is just going to be basics. We kicked off with the installation into our individual system then creating of database and table.
Image Source
Certain instructions we've made use of include: CREATE, SHOW and SELECT...we are not moving fast with these new stuffs so as to avoid information overload, lol.
However, I need help!!! Apparently I tampered with a table (Employee) in the database and this has caused the columns to be in a mess.
Initially, the 5th column should be for 'Birth_Date' and then followed by 'Salary' and then 'Dept_ID' but since I deleted the 'Birth_Date' column (I was just trying different things) and repopulated the Table the whole thing is now messed up and I can't seem to fix it up. From the look of it, the Year from 'Birth_Date' seems to be intact (without the month and day tho), then the salary values are now on the 'Dept_ID' column.
I'm pretty sure there's a command to help fix 'Birth_Date' in its appropriate column...well, I guess I just have to keep on learning and tweaking. Till then...