MySQL Forums
Forum List  »  Newbie

#1136 - Column count doesn't match value count at row 1
Posted by: Felipe Miranda
Date: April 12, 2012 06:26AM

Hi there I'm a newbie at mysql, and I got a sistem from a friend and whem I'm trying to dump the table in the db I got this error.

This is the source:


-- phpMyAdmin SQL Dump
-- version 2.11.5.1
-- http://www.phpmyadmin.net
--
-- Servidor: mysql03.uni5.net
-- Tempo de Geração: Mai 03, 2009 as 10:14 AM
-- Versão do Servidor: 5.1.34
-- Versão do PHP: 5.2.9

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Banco de Dados: `escolapadrao`
--

-- --------------------------------------------------------

--
-- Estrutura da tabela `boletim_usuarios`
--

CREATE TABLE IF NOT EXISTS `boletim_usuarios` (
`user_id` int(11) NOT NULL AUTO_INCREMENT,
`user_sala_id` int(11) DEFAULT '0',
`user_nome` varchar(60) NOT NULL,
`user_email` varchar(60) DEFAULT NULL,
`user_matricula` varchar(20) NOT NULL,
`user_niveleduc` varchar(255) NOT NULL,
`user_titulos` varchar(255) NOT NULL,
`user_telefone` varchar(200) NOT NULL,
`user_senha` varchar(32) NOT NULL,
`user_level` int(2) DEFAULT NULL,
`user_active` int(1) DEFAULT NULL,
`user_randomkey` varchar(32) DEFAULT NULL,
`id_master` int(11) DEFAULT NULL,
`master` int(1) DEFAULT '0',
PRIMARY KEY (`user_id`),
UNIQUE KEY `user_matricula` (`user_matricula`),
UNIQUE KEY `user_email` (`user_email`),
KEY `user_sala_id` (`user_sala_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Extraindo dados da tabela `boletim_usuarios`
--

INSERT INTO `boletim_usuarios` (`user_id`, `user_sala_id`, `user_nome`, `user_email`, `user_matricula`, `user_niveleduc`, `user_titulos`, `user_telefone`, `user_senha`, `user_level`, `user_active`, `user_randomkey`, `id_master`, `master`) VALUES
(1, 0, 'Administração', 'email@email.com.br', 'ADMINPADRAO', '', '', '', 'e10adc3949ba59abbe56e057f20f883e', 30, 1, '8e225b8af6194ce00a5867fc85840757', NULL, 1, 'null');

Options: ReplyQuote


Subject
Written By
Posted
#1136 - Column count doesn't match value count at row 1
April 12, 2012 06:26AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.