ক্যাসকেডগুলি দেখতে, MySQL-এ SHOW CREATE TABLE ব্যবহার করুন। আসুন প্রথমে একটি টেবিল তৈরি করি -
mysql> টেবিল তৈরি করুন DemoTable1378 -> ( -> Id int NULL AUTO_INCREMENT PRIMARY KEY, -> EmployeeId varchar(20), -> EmployeeFirstName varchar(20), -> EmployeeLastName varchar(20), -> EmployeeLastName varchar(20) 40), -> EmployeeAge int, -> EmployeeSalary int, -> UNIQUE(EmployeeFirstName,EmployeeSalary), -> INDEX First_Last_NameIndex(EmployeeFirstName,EmployeeLastName) -> প্রভাবিত হয়েছে () 0/0>;প্রশ্ন 0/9> প্রভাবিতআসুন এখন MySQL -
-এ ক্যাসকেড দেখিmysql> দেখান টেবিল তৈরি করুন DemoTable1378;এটি নিম্নলিখিত আউটপুট −
তৈরি করবে <প্রে>+-------------------------------------------------------- -------------------------------------------------- -------------------------------------------------- -------------------------------------------------- -------------------------------------------------- -------------------------------------------------- -------------------------------------------------- -------------------------------------------------- -------------------------------------------------- -------------------------------------------------- -------------------------------------------------- -------------------------------------------------- -------------------------------------------------- ------------------------------------------+| টেবিল | টেবিল তৈরি করুন |+---------------+------------------------------- -------------------------------------------------- -------------------------------------------------- -------------------------------------------------- -------------------------------------------------- -------------------------------------------------- ---------------------------------------------------------------------------------- -------------------------------------------------- -------------------------------------------------- -------------------------------------------------- -------------------------------------------------- -------------------------------------------------- -------------------------------------------------- ----------------------------------+| DemoTable1378 | টেবিল তৈরি করুন `demotable1378` ( `Id` int(11) NULL AUTO_INCREMENT, `EmployeeId` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL, `EmployeeFirstName` varchar(20F_ULLUT_ULL) varchar(20) DEFAULT NULL, `EmployeeCountryName` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL, `EmployeeAge` int(11) DEFAULT NULL, `EmployeeSalary` int(11) DEFAULT` PRINUY, UYLL PRINUYKE EmployeeFirstName`,`EmployeeSalary`), KEY `First_Last_NameIndex` (`EmployeeFirstName`,`EmployeeLastName`)) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8+------------Unicode -------------------------------------------------- -------------------------------------------------- -------------------------------------------------- -------------------------------------------------- -------------------------------------------------- -------------------------------------------------- ----------------------------------- -------------------------------------------------- -------------------------------------------------- -------------------------------------------------- -------------------------------------------------- -------------------------------------------------- -------------------------------------------------- ------------------------ সেটে 1 সারি (0.02 সেকেন্ড)
