Write an SQL statement to create a table named parts that has two columns: a field for a part number, which will be automatically set to the next part number when a new part is added, and a description field, which will hold up to 255 characters of text.

What will be an ideal response?


```
CREATE TABLE parts (part_number INT UNSIGNED NOT NULL AUTO INCREMENT,
description varchar(255))
```

Computer Science & Information Technology

You might also like to view...

A digital signature ensures all of the following EXCEPT that the information:

A) does not contain a virus. B) comes from you. C) has not been changed after you signed it. D) is valid.

Computer Science & Information Technology

Panels that appear as ______ panels occupy the same space and appear one in front of the other.

A. split B. common C. merged D. integrated

Computer Science & Information Technology

What are the metrics that can be configured for IGRP?

What will be an ideal response?

Computer Science & Information Technology

Let A = {5, 6, 7, 8, 9} and let set B = {x| x is a natural number greater than 8}.  Determine whether the following is true or false.

Answer the following statement true (T) or false (F)

Computer Science & Information Technology