0
Want this question answered?
Be notified when an answer is posted
Add your answer:
Earn +20 pts
How do you create a TABLE in MySQL?
To create a table in MySQL you will need to use the CREATE TABLE function. This is simple enough to use, a simple example of creating a users table is below, it has a unique id (Primary Key) with a unique username and a password field (which I would recommend storing as an MD5). CREATE TABLE users (id INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY , username VARCHAR( 16 ) NOT NULL , password CHAR( 32 ) NOT NULL , UNIQUE ( username ) );
When a relationship exists between two tables in a database for Microsoft acess what name is given to the matching field in the related table?
The field in a related table that matches a field in another table is called a foreign key. This foreign key establishes the relationship between the two tables in a database.
What symbol means the field is the primary key for the table appears in front of a field in the table window?
key
How the primary key is declared in MySQL?
Its best to choose an ID for each table to use as the Primary Key (PK). This is best as an INT due to speed.
What six columns are shown in the output of the DESCRIBE table statement?
Field Name of the table field.Type Column type such as varchar or timestamp.Null Does the field allow null values?Key Is this field a primary key or (a part of) and index?Default Default field value.Extra Additional information such as "on update CURRENT_TIMESTAMP"
Can a primary key refer to a whole table?
No, a primary key do not refers to the whole table .A primary key refers to a field in the table that is not null and unique.
True or false A foreign key is a field in one table that refers to the primary key field in another table and indicates how the the tables are related?
True.
What is the linking field in the many table called?
Foreign key field
Does Access automatically creates and maintains an index for a table's primary key?
Access automatically creates an index for the primary key field in a table. In addition, Access automatically creates an index for any field name that contains the following letter sequences: code, ID, key, or num.
Access automatically adds a field called as the first field in the table?
key field
What is A field that uniquely identifies a particular record in a table called?
A field that uniquely identifies a particular record in a table is called a primary key. The field or fields on which records are sorted is called the sort key.
When you create a table in datasheet view access automatically adds which field as the first field in the table?
The primary key.
