Engineering

PRACTICAL 3 The spend a penny fudge Statement The wee-wee TABLE line is utilize to create a hedge in a database. SQL CREATE TABLE Syntax CREATE TABLE table_name ( mainstay_name1 data_ suit, editorial_name2 data_ image, column_name3 data_ role, .... )| 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 suit Now we compliments to create a table called Persons that contains quintette columns: P_Id, LastName, FirstName, shell out, and urban center. We uptake the following CREATE TABLE report: 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 get. 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 lo ok like this: P_Id| LastName| FirstName| Address| City|  |  |  |  |  | The empty table can be change with data with the INSERT INTO statement. data types and ranges for Microsoft Access, MySQL and SQL Server. Microsoft Access Data Types Data type| Description| Storage| Text| mapping for schoolbook 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| whole number| Allows wh ole numbers between -32,768 and 32,767| 2 by! tes| 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| soprano| Double precision floating-point. Will handle most decimals| 8 bytes| currency| 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: OrderCustomPaper.com

If you want to get a full essay, visit our page: write my paper