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 is full text indexing in mysql?

958

---

How to create a trigger in mysql?

937

---

What is offset limit?

965

---

How do I clear a mysql database?

962

---

What are the indexes in mysql?

1033

---

What is the difference between mysql and sql?

1055

---

How do I select a table in mysql?

936

---

What is the difference between unix timestamp and mysql timestamp?

1057

---

What is cursor in mysql?

897

---

explain GROUPBY & HAVING clause with examples.

2294

---

What is the difference between b-tree and hash indexes?

1001

---

How do I find the size of a mysql database?

918

---

How to delete a table.

929

---

How can you see all indexes defined for a table?

1123

---

What is use of mysql?

928

---