Community Learn Tools Library Leisure
search
English
Home > php教程 > php手册 > 用sql命令修改数据表中的一个字段为非空(not null)的语句

用sql命令修改数据表中的一个字段为非空(not null)的语句

WBOY
Release： 2016-06-13 12:15:37
Original
2374 people have browsed it



ALTER TABLE table1 ALTER COLUMN [name] varchar(60) NULL;

table1 表名 
name 字段名 为什么加上[],因为name是sql关键字会冲突出现错误，这样以防万一。

如果name字段已经创建了索引，如果需要修改的话，必须先删除索引才能正确的进行。

Related labels：
alter NOT null sql table for Revise Order Field data sheet use of statement non empty
source：php.cn
Previous article：php trim 去除空字符的定义与语法介绍 Next article：javascript 小型动画组件与实现代码
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
Latest Articles by Author
Latest Issues
PHP arrays obtained from URL parameters do not behave as expected I have a URL parameter that contains the category ID and I want to treat it as an array li...
From 2024-04-06 22:09:02
0
1
1428
Move the content to the left by adding the Width property I have provided margins to the body. main {left margin: 200px; right margin: 200px; text a...
From 2024-04-06 22:01:35
0
3
816
Where should I place CustomLog directive in apache I'm using php:7.2-apachedocker. I need to disable health check url login access log. Based...
From 2024-04-06 22:03:59
0
1
990
The page suddenly cannot pull css or bootstrap So I'm developing a page, I did part of it yesterday and it worked great, and today I cont...
From 2024-04-06 21:58:04
0
1
800
Dynamically modify inline CSS styles in Javafx I'm trying to change the background image of a pane when the application is maximized. My ...
From 2024-04-06 20:57:16
0
1
487
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template