Example data, column types, table creation.
Now with Primary Key and Not Nulls.

****************************************************************
pets:
Bowser	Diane	dog	m	1979-08-31	1995-07-29	30	65
Chirpy	Gwen	bird	f	1998-09-11	\N	2	41

pet name, owner name, species, sex,   birthdate, deathdate, weight kg, cuteness
varchar     varchar   varchar  char(1)  date        date      int        int

CREATE TABLE pet (
  name VARCHAR(12) PRIMARY KEY, 
  owner VARCHAR(12) Not Null,
  species VARCHAR(12) Not Null, 
  sex CHAR(1), 
  birth DATE Not Null, 
  death DATE,
  weight INT(3) Not Null,
  cuteness INT(2) Not Null);

****************************************************************
products:
11QER/31	Power painter, 15 psi., 3-nozzle	2003-11-3 	8	5	109.99	0.00
13-Q2/P2	7.25-in. pwr. saw blade	2003-12-13 	32	15	14.99	0.05

code/id, description, in-stock date, quantity in stock, reorder quantity trigger, price, discount %, 
varchar    varchar       date             int                 int                 decimal   decimal

CREATE TABLE product (
 p_code VARCHAR(10)  PRIMARY KEY,
 p_descript VARCHAR(35) Not Null,
 p_indate DATE Not Null,
 p_onhand INT Not Null,
 p_min INT Not Null,
 p_price DECIMAL(8,2) Not Null,
 p_discount DECIMAL(5,2) Not Null);


****************************************************************
countries:
'NLD','Netherlands','Europe',41526.00,1581,15864000,78.3,371362.00,'Constitutional Monarchy','Beatrix','NL'
'ALB','Albania','Europe',28748.00,1912,3401200,71.6,3205.00,'Republic','Rexhep Mejdani','AL'

 3-letter code, name, continent, area sq km.dd, year independance, population, lifeExpectancy, GNP, form of govt, head of state, 2-letter code
  char(3)       varchar varchar  float,2            int             int          float,1      float,2  varchar     varchar        char(2)    

CREATE TABLE Country (
  Code char(3) PRIMARY KEY,
  Name varchar(52) Not Null,
  Continent varchar(13) Not Null,
  SurfaceArea float(10,2) Not Null,
  IndepYear smallint(6) Not Null,
  Population int(11) Not Null,
  LifeExpectancy float(3,1) Not Null,
  GNP float(10,2) Not Null,
  GovernmentForm varchar(45) Not Null,
  HeadOfState varchar(60) Not Null,
  Code2 char(2) Not Null);

****************************************************************
This data:
+-----------+-------+--------+------+-----------------+
| name      | state | pop    | area | incomePerCapita |
+-----------+-------+--------+------+-----------------+
| Abbeville | SC    |  26167 |  508 |           15370 |
| Acadia    | LA    |  58861 |  655 |           13424 |
| Accomack  | VA    |  38305 |  455 |           16309 |
| Ada       | ID    | 300904 | 1055 |           22519 |
| Adair     | IA    |   8243 |  569 |           17262 |
 ...

CREATE TABLE counties (
  name varchar(32) NOT NULL,
  state char(2) NOT NULL,
  pop int NOT NULL,
  area int NOT NULL,
  incomePerCapita int NOT NULL,
  PRIMARY KEY (name,state));

+-----------------+-------------+------+-----+---------+-------+
| Field           | Type        | Null | Key | Default | Extra |
+-----------------+-------------+------+-----+---------+-------+
| name            | varchar(32) | NO   | PRI | NULL    |       |
| state           | char(2)     | NO   | PRI | NULL    |       |
| pop             | int(11)     | NO   |     | NULL    |       |
| area            | int(11)     | NO   |     | NULL    |       |
| incomePerCapita | int(11)     | NO   |     | NULL    |       |
+-----------------+-------------+------+-----+---------+-------+