Question and Answer Solution
When a table is created it an an empty strutre. To add data to the table, the INSERT command is used. If there are exactly the same number of values as there are fields and the values are their values have a one- to – one correspondence, i.e., the first value in inserted into the…
3.3.4 তালিকাৰ গাঁথনি প্ৰদৰ্শন কৰা To display Complete information about the fields defined in the table Student, the Query is (fig 3.10). তালিকাত নিৰ্ধাৰিত ক্ষেত্ৰসমূহৰ সম্পূৰ্ণ তথ্য প্ৰদৰ্শন কৰিবলৈ, কুৱেৰী হৈছে (ডুমুর 3.10)। DESCRIBE student; শিক্ষাৰ্থীক বৰ্ণনা কৰক; OR বা DESC student; ডিইএছচি শিক্ষাৰ্থী; Fig 3.10 Displaying Table Structure
3.3.3 সীমাবদ্ধতা In MySQL, data validation can be censured through Constraints while entering data in a table. Constraints are some ruled that help ensure the validity of the data while entering data a table. The constraints in MySQL are PRIMART KEY,NOT NULL, FOREIGN KEY,UNIQUE, ENUM. and SET. we will discuss NOT NULL and PRIMART KEY…
3.3.2 তালিকা এখন সৃষ্টি কৰা In order to create a table, the CREATE TABLE command is used. In the CREATE TABLE command, each field of the table is defined with three attributes – name of the field, data type of the field and size of the field. টেবল এখন সৃষ্টি কৰিবলৈ, ক্ৰিয়েট টেবল কমাণ্ড ব্যৱহাৰ…