Click Test Connection to check if the connection works well then click OK to

Click test connection to check if the connection

This preview shows page 3 - 5 out of 5 pages.

connection information (ip, port, username, password). Click Test Connection to check if the connection works well, then click OK to save the new connection.
Image of page 3
- From the Home screen, click the connection you defined in the previous step - Once connected, you work with the server by writing SQL statements, in the query panel. To run a single statement, just select it, and press Ctrl + Enter or click button on the tool box.
Image of page 4
II. Getting started with SQL statements 1. Write a SQL statement to create a new database name Company . 2. Write a SQL statement to create to set the default working database to Company . 3. Write SQL statements to define tables of Company databases with contraints and columns illustrated by igures below. You should determine appropriate datatype for each column. 4. Add column Partner_ssn to the table EMPLOYEE. This column indicates the SSN of spouse of each employee. For those who are now single, the value should be NULL. 5. Write SQL statements to insert sample rows to these tables. 6. Write SQL statements to delete the tables you created.
Image of page 5

You've reached the end of your free preview.

Want to read all 5 pages?

  • Winter '19
  • Nguyen Tue
  • MYSQL

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

Stuck? We have tutors online 24/7 who can help you get unstuck.
A+ icon
Ask Expert Tutors You can ask You can ask You can ask (will expire )
Answers in as fast as 15 minutes