Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I am working on my sql via mysql. I need help with a code.
I am able to create the table; however, I am having trouble installing the data into the table with out getting the ERROR 1136.

CREATE DATABASE  IF NOT EXISTS `contact_info`;
USE `contact_info`;
DROP TABLE IF EXISTS `contact_info`;
CREATE TABLE `contact_info` (
  `firstName` varchar(25),
  `middleInitial` char(1), 
  `lastName` varchar(25),
  `suffixDescription` varchar(5),
  `titleDescription` varchar(5),
  `jobTitle` varchar(40),
  `department` varchar(30),
  `email` varchar(35),
  `url` varchar(50) DEFAULT NULL COMMENT 'Web address for station',
  `IMaddress` varchar(25),
  `phoneNumber` varchar(25),
  `phoneDescription` varchar(10),
  `birthday` date,
  `notes` varchar(255),
  `companyName` varchar(30),
  `addressLine1` varchar(40),
  `addressLine2` varchar(40),
  `city` varchar(20),
  `state_province` varchar(15) ,
  `zip_postalcode` varchar(10) ,
  `country_region` varchar(15) ,
  `companyURL` varchar(50),
  `companyPhone` varchar(12)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

insert into contact_info (`firstName `, 
            `middleInitial `,
            `lastName `,
            `suffixDescription `,
            `titleDescription `,
            `jobTitle `,
            `department `,
            `email `,
            `url `,
            `IMaddress `,
            `phoneNumber `,
            `phoneDescription `,
            `birthday `,
            `notes `,
            `companyName `,
            `addressLine1 `,
            `addressLine2 `,
            `city `,
            `state_province `,
            `zip_postalcade `)
value ('Jacob',
    'P',
    'Jacobson',
    'Jr.',
    'Mr.',
    'Director',
    'Finace',
    'rjameson@concor.com',
    'www.concor.com/~rjames',
    'jpjacobson',
    '323-546-6834 ext. 29',
    'work',
    '1969-07-13',
    'All meetings must be scheduled through Charlene Reynolds',
    'Concor International, Inc.',
    '143 South Main Street',
    null,
    'Los Angeles',
    'CA',
    '90012-3712',
    'USA',
    'www.concor.com',
    '323-546-6834'
    ),('Charlene',
    null,
    'Reynolds',
    null,
    'Ms.',
    'Assistant to Finance Director',
    'Finace',
    'creynolds@concor.com',
     null,
    'charreynolds',
    '323-546-6834 ext. 30',
    'work',
    '1972-06-15',
    'Very nice, but can make things difficult if you make her angry.',
    'Concor International, Inc.',
    '143 South Main Street',
    null,
    'Los Angeles',
    'CA',
    '90012-3712',
    'USA',
    'www.concor.com',
    '323-546-6834'
    ),
    ('Karson',
    'B',
    'Campbell',
    null,
    'Dr.',
    'Chief Resident',
    'Pediatrics',
    'kbc232@mvch.org',
    null,
    null,
    '585-544-1212',
    'home',
    '1955-01-05',
    'Wife: Molly Kids: Cassidy, Justine, and Cory.',
    'Mountain View Hospital',
    null,
    null,
    null,
    null,
    null,
    null
    ),
    ('Les',
    'M',
    'Nelson',
    'Ph.D.',
    'Prof.',
    'Professor',
    'Business',
    'lmnbus@rit.edu',
    null,
    null,
    '585-475-0000',
    'work',
    '1964-03-23',
    'Hates when work is submitted late',
    'RIT',
    'Bldg. 12',
    '102 Lomb Memorial Drive',
    'Rochester',
    'NY',
    '14623',
    'USA',
    'www.rit.com',
    null
    ),
    ('Rachel',
    null,
    'Woods',
    null,
    'Miss.',
    null,
    null,
    'goof@go.com',
    null,
    'Goofy12',
    '585-475-0000',
    'cell',
    '1985-05-06',
    'Favorite color is purple.',
    null,
    null,
    null,
    null,
    null,
    null,
    null,
    null,
    null
    ),
    ('David',
    'W',
    'Shanley',
    null,
    'Mr.',
    null,
    null,
    null,
    null,
    null,
    null,
    null,
    null,
    null,
    null,
    null,
    null,
    null,
    null,
    null,
    null,
    null,
    null
    )
    ;

When I insert it to mysql, I get this "ERROR 1136 (21S01): Column count doesn't match value count at row 1" I look on Google, some my books that i owned and even try this Getting error 1136 in this MySQL query still at a standstill.

share

migration rejected from stackoverflow.com Sep 8 '13 at 17:33

This question came from our site for professional and enthusiast programmers. Votes, comments, and answers are locked due to the question being closed here, but it may be eligible for editing and reopening on the site where it originated.

closed as off-topic by Mat, Mark Storey-Smith, ypercube, Jon Seigel, Max Vernon Sep 8 '13 at 17:33

If this question can be reworded to fit the rules in the help center, please edit the question.

3  
This question appears to be off-topic because it is about basic SQL. –  Mat Sep 7 '13 at 11:27