Home Backend Development PHP Tutorial mysql 新增多一列数据 报错 Data truncated for column 'tg_level' at row 1

mysql 新增多一列数据 报错 Data truncated for column 'tg_level' at row 1

Jun 13, 2016 pm 01:09 PM
Level NOT null

mysql 新增加一列数据 报错 Data truncated for column 'tg_level' at row 1
插入的是这个列 alter table tg_user change tg_level tg_level tinyint(1) unsigned not null 如果不加这个 not null 没有错误。求高手帮忙解答

------解决方案--------------------
他不是update, 是add, 所以很奇怪, 应该是没找到病根

探讨

把库里面原来的数据删除就行了,因为原来有数据,又设为not null ,是冲突的
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Hot AI Tools

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress AI Tool

Undress images for free

Clothoff.io

Clothoff.io

AI clothes remover

Video Face Swap

Video Face Swap

Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Article

Roblox: Bubble Gum Simulator Infinity - How To Get And Use Royal Keys
3 weeks ago By 尊渡假赌尊渡假赌尊渡假赌
Nordhold: Fusion System, Explained
4 weeks ago By 尊渡假赌尊渡假赌尊渡假赌
Mandragora: Whispers Of The Witch Tree - How To Unlock The Grappling Hook
3 weeks ago By 尊渡假赌尊渡假赌尊渡假赌

Hot Tools

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use

Zend Studio 13.0.1

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver CS6

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)

Hot Topics

Java Tutorial
1670
14
PHP Tutorial
1274
29
C# Tutorial
1256
24
What do undefined and null mean? What do undefined and null mean? Nov 20, 2023 pm 02:39 PM

In JavaScript, both undefined and null represent the concept of "nothing": 1. undefined represents an uninitialized variable or a non-existent property. When a variable is declared but no value is assigned to it, the value of the variable is undefined , when accessing properties that do not exist in the object, the returned value is also undefined; 2. null represents an empty object reference. In some cases, the object reference can be set to null to release the memory it occupies.

What is the difference between null and NULL in c language What is the difference between null and NULL in c language Sep 22, 2023 am 11:48 AM

The difference between null and NULL in C language is: null is a macro definition in C language, usually used to represent a null pointer, which can be used to initialize pointer variables, or to determine whether the pointer is null in a conditional statement; NULL is a macro definition in C language A predefined constant in , usually used to represent a null value, used to represent a null pointer, null pointer array or null structure pointer.

What is the difference between null and undefined What is the difference between null and undefined Nov 08, 2023 pm 04:43 PM

The difference between null and undefined is: 1. Semantic meaning; 2. Usage scenarios; 3. Comparison with other values; 4. Relationship with global variables; 5. Relationship with function parameters; 6. Nullability check; 7. Performance considerations; 8. Performance in JSON serialization; 9. Relationship with types. Detailed introduction: 1. Semantic meaning, null usually means knowing that this variable will not have any valid object value, while undefined usually means that the variable has not been assigned a value, or the object does not have this attribute; 2. Usage scenarios, etc.

When to use null and undefined When to use null and undefined Nov 13, 2023 pm 02:11 PM

Both null and undefined indicate a lack of value or an undefined state. Depending on the usage scenario, there are some guiding principles for choosing to use null or undefined: 1. When you need to clearly indicate that a variable is empty or invalid, you can use null; 2. When a variable has been declared but not yet assigned a value, it will be set to undefined by default; 3. When you need to check whether a variable is empty or undefined, use the strict equality operator "===" to determine whether the variable is null or undefined. .

What are the uses of null in java What are the uses of null in java Mar 01, 2024 am 10:10 AM

Usage: 1. Initialize the reference type variable to null, indicating that the variable does not currently point to any object; 2. Set the reference type variable to null, which can release the memory space of the object referenced by the variable and help the garbage collector to recover This object; 3. Use null to check whether a reference is empty. You can avoid the occurrence of NullPointerException by judging whether the reference is null. 4. Use null in conditional judgment to judge whether a reference is empty.

How to remove null from php array How to remove null from php array Dec 23, 2022 am 10:27 AM

How to remove nulls from PHP arrays: 1. Use the "foreach($arr as $k=>$v){...}" method to remove null values ​​from the array; 2. Use the while syntax structure to remove null values; 3. Use The array_filter function filters the array and removes null values.

Locksmith giant Assa Abloy acquires another smart lock startup Locksmith giant Assa Abloy acquires another smart lock startup Sep 22, 2024 am 06:15 AM

Assa Abloy, the world's largest lock maker since the turn of the 21st century, has not refrained from acquiring competitors and would-be competitors as it strives to expand the access control market. California-based smart lock brand Level Lock is th

NOTCOIN (NOT) Price Analysis: Buyers Attempt to Regain Control, But Bears Are Lurking NOTCOIN (NOT) Price Analysis: Buyers Attempt to Regain Control, But Bears Are Lurking Aug 12, 2024 pm 06:04 PM

Losing more than 60% of its value in two months, Notcoin found support this week and increased a little. Due to a significant drop in buy volume, the price has remained stagnant as it decides on the next major move.

See all articles