Answer Posted / arihant

example of check constraint

CREATE TABLE Customer_Details(
Cust_ID Number(5) CONSTRAINT Nnull1 NOT NULL
CONSTRAINT Ccheck1 CHECK( Cust_ID BETWEEN 101 AND 105),
Cust_Last_Name VarChar2(20) CONSTRAINT Nnull2 NOT NULL,
Cust_Mid_Name VarChar2(4),
Cust_First_Name VarChar2(20),
Account_No Number(5) CONSTRAINT Pkey1 PRIMARY KEY,
Account_Type VarChar2(10) CONSTRAINT Nnull3 NOT NULL,
Bank_Branch VarChar2(25) CONSTRAINT Nnull4 NOT NULL,
Cust_Email VarChar2(30)
);

What are date and time intervals?

922

---

How can we get total number of records by query in mysql?

853

---

How can we find out which auto increment was assigned on Last insert?

1035

---

Is mysql and sql are same?

985

---

What is database migration in mysql?

951

---

What is mysql enterprise edition?

847

---

What is mysql routine?

850

---

If you are assigned a task, to find the information of procedures. What are the basic commands that you will use to do so?

890

---

What is a heap table?

877

---

What is mysql good for?

839

---

What is difference between microsoft sql and mysql?

924

---

how to take mysql database backup?

999

---

How to give user privilages for a db. Login as root. Switch to the mysql db. Grant privs. Update privs.

884

---

What is pdo mysql?

880

---

Write a query to fetch common records between two tables using mysql?

957

---