Mysql error 1366-Incorrect integer value how to solve?
This article mainly introduces how to solve the Mysql error 1366-Incorrect integer value. This article solves the problem by modifying the default value of the field. For more information,
Database version: 5.6.16?? operating system: Red Hat Enterprise Linux Server release 6.3 (Santiago)?? When inserting data, prompt for alarm:?mysql> Show warnings;+---------+------+----------------------------------------------------------+| Level |
Mysql error 1366-Incorrect integer value solution, 1366 incorrect
Because this database server stores many databases and all of them are small databases, it initially runs on a windows server. Some time ago, due to the need to adjust the server room,
Incorrect integer value: ''for column 'id' at row 1 solves this problem when I recently wrote a query insert statement.
Insert into test values ('', row [contentid], '". tn ."');
If the result is inserted, the error "Incorrect integer value:''
This article mainly introduces the MySQL error 1366-incorrect integer value solution, this article by modifying the default value of the field to solve, the need for friends can refer to the
Because the database server has a lot of databases and
first, the introduction
This is what I was inspired to learn from the 28th page of the book "Python Algorithms 2nd":
For intergral weights, your could use Sys.maxint, even though it ' s not guaranteed to is the greatest possbile value (long INTs
1. Incorrect integer value appears: ' For column ' id ' at row 1To mysqld my.cnf ModifyModified into sql-mode= "No_auto_create_user,no_engine_substitution"2 . Column count doesn ' t match value count at row 1The number of columns in the SQL
When using mysql to insert data, the system prompts to solve the Incorrect integer value: for column id; at row 1 error. Let's take a look at the solution to this problem.
I recently wrote a query insert statement as follows:
Insert into test
When using navicat for MySQL to restore a database backup, the error incorrect integer value: ''for column 'id' at Row 1 occurs;
Online data discovery5. if the version is null, null should be written.This problem usually occurs on MySQL 5.x.
Use
There are three main methods of PHP rounding, namely function ceil,floor,round, but there are some differences between the three, now do an example to analyze their respective characteristics:
(1) ceil () into a method to take the integer
CPP] view Plaincopyprint? Write a function that checks if the character is an integer and, if so, returns its integer value. (or: How to write a function from string to Long integer with only 4 lines of code) #include "stdafx.h" #include
The idea of public class reverseinteger {/** is as follows * 1. first, convert the integer variable to the string * 2. convert the string to a char array, and then compare the positive and negative values of the input variables. if it is positive,
In ILP32, char, short, int, long, long long, pointer respectively accounted for 1, 2, 4, 4, 8, 4 bytes,In LP64, char, short, int, long, long long, pointer respectively accounted for 1, 2, 4, 8, 8, 8 bytes,Whether in ILP32 or LP64, long long always
1. Methods to be used:Math.random: Take a random number greater than or equal to 0 to less than 1;Math.floor: Rounding down;Math.ceil: Rounding up;2. Look at a face question, require a function FN, the parameter is n, you need to return n integers
Because the database server has a lot of databases and small databases, it was originally run on a Windows server. Some time ago due to the computer room server to make adjustments, so I will be in a night of nights on the migration of the database
There is no way to find a solution on the Internet. But Baidu went to a personal blog and found a way to solve it.
An error SQL statement
Update XX user Set Qq_password = ' xx_id ' & photo = ' img ' WHERE email = ' EMAILX '
And then this is the
Today in the public number to see this problem, I wrote down, found himself still have a lot of unnoticed, in this record,Returns a random integer function getrandom (min, max) {var rand = Math.Round (Math.random () * (max-min) + min); return rand;};
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.