fix your error mysql

Solutions on MaxInterview for fix your error mysql by the best coders in the world

showing results for - "fix your error mysql"
Russell
26 Mar 2016
1# ************************************************************
2# Sequel Pro SQL dump
3# Version 4096
4#
5# http://www.sequelpro.com/
6# http://code.google.com/p/sequel-pro/
7#
8# Host: localhost (MySQL 5.6.14)
9# Database: SocialNetwork
10# Generation Time: 2017-01-24 18:54:41 +0000
11# ************************************************************
12
13
14/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
15/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
16/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
17/*!40101 SET NAMES utf8 */;
18/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
19/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
20/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
21
22
23# Dump of table followers
24# ------------------------------------------------------------
25
26DROP TABLE IF EXISTS `followers`;
27
28CREATE TABLE `followers` (
29  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
30  `user_id` int(11) unsigned NOT NULL,
31  `follower_id` int(11) unsigned NOT NULL,
32  PRIMARY KEY (`id`)
33) ENGINE=InnoDB DEFAULT CHARSET=latin1;
34
35
36
37# Dump of table login_tokens
38# ------------------------------------------------------------
39
40DROP TABLE IF EXISTS `login_tokens`;
41
42CREATE TABLE `login_tokens` (
43  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
44  `token` char(64) NOT NULL DEFAULT '',
45  `user_id` int(11) unsigned NOT NULL,
46  PRIMARY KEY (`id`),
47  UNIQUE KEY `token` (`token`),
48  KEY `user_id` (`user_id`),
49  CONSTRAINT `login_tokens_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
50) ENGINE=InnoDB DEFAULT CHARSET=latin1;
51
52
53
54# Dump of table password_tokens
55# ------------------------------------------------------------
56
57DROP TABLE IF EXISTS `password_tokens`;
58
59CREATE TABLE `password_tokens` (
60  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
61  `token` char(64) NOT NULL DEFAULT '',
62  `user_id` int(11) unsigned NOT NULL,
63  PRIMARY KEY (`id`),
64  UNIQUE KEY `token` (`token`)
65) ENGINE=InnoDB DEFAULT CHARSET=latin1;
66
67
68
69# Dump of table users
70# ------------------------------------------------------------
71
72DROP TABLE IF EXISTS `users`;
73
74CREATE TABLE `users` (
75  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
76  `username` varchar(32) DEFAULT NULL,
77  `password` varchar(60) DEFAULT NULL,
78  `email` text,
79  `verified` tinyint(1) NOT NULL DEFAULT '0',
80  PRIMARY KEY (`id`)
81) ENGINE=InnoDB DEFAULT CHARSET=latin1;
82
83
84
85
86/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
87/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
88/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
89/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
90/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
91/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
queries leading to this page
sqlstate 5b21s01 5d 3a insert value list does not match column list 3a 1136 column count doesn 27t match value count at row 2sql error 5b1136 5d 5b21s01 5d 3a column count doesn 27t match value count at row 1insert value list does not match column list 3a 1136 column count doesn 27t match value count at row 9problem sqlstate 5b21s01 5d 3a insert value list does not match column list 3a 1136 column count doesn 27t match value count at row 1problemsqlstate 5b21s01 5d 3a insert value list does not match column list 3a 1136 column count doesn 27t match value count at row 1sqlstate 5b21s01 5d 3a insert value list does not match column list 3a 1136 column count doesn 27t match value count at row 2sqlstate 5b21s01 5d 3a insert value list does not match column list 3a 1136 column count doesn 27t match value count at row 1 3a insert value list does not match column list 3a 1136 column count doesn 27t match value count at row 1fatal error 3a uncaught pdoexception 3a sqlstate 5b21s01 5d 3a insert value list does not match column list 3a 1136 column count doesn 27t match value count at row 1error 3a 1136 2821s01 29 3a column count doesn 27t match value count at row 1created at insert value list does not match column list 3a 1136 column count doesn 27t match value count at row 4 28sql 3a insererror 1136 2821s01 29 3a column count doesn 27t match value count at row 1 22sqlstate 5b21s01 5d 3a insert value list does not match column list 3a 1136 column counterror sqlstate 5b21s01 5d 3a insert value list does not match column list 3a 1136 column count doesn 27t match value count at row 1 with dataloadinsert value list does not match column list 3a 1136 column count doesn 27t match value count at rowinsert value list does not match column list 3a 1136 column count doesn 27t match value count at row 1fatal error 3a uncaught pdoexception 3a sqlstate 5b21s01 5d 3a insert value list does not match column list 3a 1136 column count doesn 27t match value count at row 1 ininsert value list does not match column list 3a 1136 column count doesn 27t match value count at row 5fix mysql errorerrore 3a sqlstate 5b21s01 5d 3a insert value list does not match column list 3a 1136 column count doesn 27t match value count at row 1sqlstate 5b21s01 5d 3a insert value list does not match column list 3a 1136 column count doesn 27t match value count at rowinsert value list does not match column list 1136 column count doesn 27t match value count at row 1insert value list does not match column list 3a 1136 column count doesn 27t match value count at row 3insert value list does not match column list 3a 1136 column count doesn 27t match value counterror code 3a 1136 column count doesn 27t match value count at row 1laravel pdoexception 3a 3a 28 22sqlstate 5b21s01 5d 3a insert value list does not match column list 3a 1136 column count doesn 27t match value count at row 10 22 29fix your error mysql