I followed appendix ii in the book to try to configure my machine to support a database server and allow me to work locally on my computer. However, I'm having a tough time trying to get the SQL server to work correctly on my home computer, so I just went ahead and read on. The chapter mostly talked about creating tables and SQL statements which I have lots of experience of from my 4610 class and internship.
I can't really do the examples in this chapter due to my computer not being configured correctly, also I'm running a little behind schedule because of my attempts of making local server work.
Some tools to access the MySQL database server are MySQL terminal and phpMyAdmin. MySQL is more hard coded tool as in you will used SQL statements to make the tables and data entry whereas phpMyAdmin is more of a graphical user-friendly tool that help with making the tables easier.
SQL Syntax
-Insert
-Select
-Put a semicolon(;) at the end of statement
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment