Journal Week 10 Day 4

In a SQL table, what is the difference between information in a row and information in a column?

Demonstrate the basic structure for creating a new table called characters with the values name, age, description as strings, and an int id.

What is the difference between the following statements:

1. A row is one individual item, and column is just all the data for one variable.

2. CREATE TABLE whatever ( ID varchar(255) NOT NULL whateverElse varchar(255) NOT NULL PRIMARY KEY (ID) );

3. Delete from deletes a single piece of data from a table. Drop table deletes the entire table.

Daily Challenge https://github.com/NathanMQuam/A-Knights-Tail