Home Database Mysql Tutorial sql必学知识点(蒙古国立大学计算学院滴血教程)

sql必学知识点(蒙古国立大学计算学院滴血教程)

Jun 07, 2016 pm 03:07 PM
sql University college Knowledge points calculate

1.在SQL server 2005 中可以使用delete 删除视图中的一列吗? 视图只能操作查询,不能在里面修改。你可以在原表进行子查询,去掉不要的. 2.一个关于触发器实例:点击打开链接 存储过程 3.插入数据时,可以这样,你知道吗? $q=$m-query('insert into location

1.在SQL server 2005 中可以使用delete 删除视图中的一列吗?

视图只能操作查询,不能在里面修改。你可以在原表进行子查询,去掉不要的.

2.一个关于触发器实例:点击打开链接

存储过程  
   
   

3.插入数据时,可以这样,你知道吗?

$q=$m->query('insert into location (number,location,op,input) values ((select number from inventory where id = "'.$_GET[id].'"),"'.$_POST[location].'","'.$_SESSION[auth].'","'.$input.'")');
Copy after login


4.修改字段属性,

实例一:

ALTER TABLE `ship` CHANGE `sQty` `sQty` SMALLINT( 7 ) NOT NULL

实例二:

ALTER TABLE `setting_display` ADD `length2` VARCHAR( 255 ) NOT NULL AFTER `others` ,
ADD `width` VARCHAR( 255 ) NOT NULL AFTER `length2` ,
ADD `height` VARCHAR( 255 ) NOT NULL AFTER `width` ,
ADD `vol2` VARCHAR( 255 ) NOT NULL AFTER `height` ,
ADD `weight2` VARCHAR( 255 ) NOT NULL AFTER `vol2` ;

5.插入数据还可以这样,你会吗?

insert into wc SET yourfatcher='123123';

6.字段你能分清吗?

试试funlltext是何意?

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 Article Tags

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)

What is the difference between HQL and SQL in Hibernate framework? What is the difference between HQL and SQL in Hibernate framework? Apr 17, 2024 pm 02:57 PM

What is the difference between HQL and SQL in Hibernate framework?

How to calculate addition, subtraction, multiplication and division in word document How to calculate addition, subtraction, multiplication and division in word document Mar 19, 2024 pm 08:13 PM

How to calculate addition, subtraction, multiplication and division in word document

CUDA's universal matrix multiplication: from entry to proficiency! CUDA's universal matrix multiplication: from entry to proficiency! Mar 25, 2024 pm 12:30 PM

CUDA's universal matrix multiplication: from entry to proficiency!

Usage of division operation in Oracle SQL Usage of division operation in Oracle SQL Mar 10, 2024 pm 03:06 PM

Usage of division operation in Oracle SQL

What does the identity attribute in SQL mean? What does the identity attribute in SQL mean? Feb 19, 2024 am 11:24 AM

What does the identity attribute in SQL mean?

How to count the number of elements in a list using Python's count() function How to count the number of elements in a list using Python's count() function Nov 18, 2023 pm 02:53 PM

How to count the number of elements in a list using Python's count() function

Comparison and differences of SQL syntax between Oracle and DB2 Comparison and differences of SQL syntax between Oracle and DB2 Mar 11, 2024 pm 12:09 PM

Comparison and differences of SQL syntax between Oracle and DB2

Detailed explanation of the Set tag function in MyBatis dynamic SQL tags Detailed explanation of the Set tag function in MyBatis dynamic SQL tags Feb 26, 2024 pm 07:48 PM

Detailed explanation of the Set tag function in MyBatis dynamic SQL tags

See all articles