Jump to content


Photo

Adding The Example Table Into Sql


  • Please log in to reply
2 replies to this topic

#1 rowdog_14

rowdog_14

    New Member

  • Members
  • Pip
  • 3 posts

Posted 28 November 2011 - 07:52 AM

I am wanting to add the SQL example tables into MYSQL without having to manually type all them in. I have click around MYSQL and added them into the the Database folder and they still do not show up.

located here
http://www.headfirst...om/books/hfsql/
under downloads, all tables zip file

#2 rowdog_14

rowdog_14

    New Member

  • Members
  • Pip
  • 3 posts

Posted 30 November 2011 - 08:00 AM

I guess I will just edit each one copy and paste all of them into MySql

#3 rowdog_14

rowdog_14

    New Member

  • Members
  • Pip
  • 3 posts

Posted 30 November 2011 - 12:39 PM

Found it...Just click on File,Open SQL script, a windows box will open, direct it to the folder from Head First, then select the file, press CTRL/SHIFT/Enter or select query. You table is now loaded into your database.

You can run a Select * query to verify that all your data is in the table.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users