Unformatted text preview: 1. Connect to your online MySQL database. 2. Create a table with a name of your choice. 3. Define the table to have three attributes ; two of type text and one of type int . 4. Insert at least four data entries in the table. 5. Browse the table to verify the entries have been inserted. 6. Snapshot the screen with the browsed table contents. 7. Use the search function to find some entry (entries) by specifying a search condition of the form: Attribute = value 8. Snapshot the screen with the search results. 9. Repeat the search with an SQL search query like: Select from tableName where attributeName = 'value' and Snapshot the results. 10. Post the results and email your account and MySQL password to me so I directly access them....
View Full Document
- Spring '09
- MYSQL , search query, MySQL exercise Noon