This topic contains a solution. Click here to go to the answer

Author Question: SQL triggers are used for providing default values, validity checking, updating views, and ... (Read 107 times)

stephzh

  • Hero Member
  • *****
  • Posts: 556
SQL triggers are used for providing default values, validity checking, updating views, and performing referential integrity actions.
 
  Indicate whether the statement is true or false

Question 2

Describe how to create a new database in MySQL 5.6 Community Server Edition.
 
  What will be an ideal response?



Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
Marked as best answer by a Subject Expert

dyrone

  • Sr. Member
  • ****
  • Posts: 322
Answer to Question 1

TRUE

Answer to Question 2

In MySQL 5.6 Community Server Edition, new databases are created in the MySQL Workbench. Click the Create a new schema in the connected server button in the Object Browser. The new_schema tabbed window is displayed. Enter the database name and click the Apply button. The Apply SQL Script to Database dialog box is displayed. Click the Apply SQL button and then, after the SQL script has run, click the Finish button. In the new_schema tabbed window, click the Close button. The new schema appears in the Object Browser.




stephzh

  • Member
  • Posts: 556
Reply 2 on: Jul 7, 2018
Thanks for the timely response, appreciate it


apple

  • Member
  • Posts: 352
Reply 3 on: Yesterday
:D TYSM

 

Did you know?

In inpatient settings, adverse drug events account for an estimated one in three of all hospital adverse events. They affect approximately 2 million hospital stays every year, and prolong hospital stays by between one and five days.

Did you know?

It is widely believed that giving a daily oral dose of aspirin to heart attack patients improves their chances of survival because the aspirin blocks the formation of new blood clots.

Did you know?

Limit intake of red meat and dairy products made with whole milk. Choose skim milk, low-fat or fat-free dairy products. Limit fried food. Use healthy oils when cooking.

Did you know?

All patients with hyperparathyroidism will develop osteoporosis. The parathyroid glands maintain blood calcium within the normal range. All patients with this disease will continue to lose calcium from their bones every day, and there is no way to prevent the development of osteoporosis as a result.

Did you know?

Atropine was named after the Greek goddess Atropos, the oldest and ugliest of the three sisters known as the Fates, who controlled the destiny of men.

For a complete list of videos, visit our video library