Engineering

PRACTICAL 3 The fashion fudge Statement The perform TABLE line is utilise to create a surround in a database. SQL CREATE TABLE Syntax CREATE TABLE table_name ( mainstay_name1 data_ suit, pillar_name2 data_ image, column_name3 data_ grapheme, .... )| The data type specifies what type of data the column can hold. For a masterful reference of all the data types available in MS Access, MySQL, and SQL Server, CREATE TABLE manikin Now we compliments to create a table called Persons that contains pentad columns: P_Id, LastName, FirstName, report, and urban center. We delectation the following CREATE TABLE averment: CREATE TABLE Persons ( P_Idint, LastNamevarchar(255), FirstNamevarchar(255), Address varchar(255), City varchar(255) )| The P_Id column is of type int and will hold a takings. The LastName, FirstName, Address, and City columns atomic number 18 of type varchar with a maximum length of 255 characters. The inane Persons table will now look like this: P_Id| LastName| FirstName| Address| City|  |  |  |  |  | The empty table can be change with data with the INSERT INTO statement. info types and ranges for Microsoft Access, MySQL and SQL Server. Microsoft Access Data Types Data type| Description| Storage| Text| mapping for text or combinations of text and song.

255 characters maximum|  | Memo| Memo is used for big amounts of text. Stores up to 65,536 characters. Note: You cannot sort a memorandum field. However, they be searchable|  | Byte| Allows hearty numbers from 0 to 255| 1 byte| full-length number| Allows whole numbers between -32,768 and 32,767| 2 bytes| Long| Allows whole numbers between -2,147,483,648 and 2,147,483! ,647| 4 bytes| Single| Single clearcutness floating-point. impart handle most tenfolds| 4 bytes| look-alike| Double precision floating-point. Will handle most decimals| 8 bytes| currentness| Use for currency. Holds up to 15 digits of whole dollars, plus 4 decimal places. Tip: You can choose which countrys currency to use| 8...If you want to get a full essay, order it on our website: OrderEssay.net

If you want to get a full information about our service, visit our page: How it works.