alter table TB_EXAM_PROBLEM modify PRO_DESC VARCHAR2(4000);alter table TB_EXAM_PROBLEM modify PRO_KEY VARCHAR2(4000);
can only be modified one by one?
alter table TB_EXAM_PROBLEM modify PRO_DESC VARCHAR2(4000);alter table TB_EXAM_PROBLEM modify PRO_KEY VARCHAR2(4000);
can only be modified one by one?
alter table TB_EXAM_PROBLEM modify PRO_DESC VARCHAR2(4000),
modify PRO_KEY VARCHAR2(4000);
Mysql supports an alter statement to modify multiple fields. Separate the different modify with and
.
did not understand the problem of the landlord, what is meant by "can only be modified one by one"?
whether you write an alter statement per line of fields, or you reply to modify multiple fields in an alter statement, it's just a command.
if you want to modify multiple fields, put all the command statements to be executed in a sql file, and then execute them in batches.
-
Invalid ORA-01722: number, the field type of both tables is varchar (2)?
when writing insert sql statements with python + cx_oracle, the error message is an invalid ORA-01722: number. The field types of the two tables are the same, and they are executed in PL SQL, and the field that reported the error is found. But after loo...
-
What does it mean that multiple map=0%,reduce=0% appear in succession in hadoop?
normal hadoop execution
hadoop
what does it mean that multiple map=0%,reduce=0% appear in succession? Last error report: Error while processing statement: FAILED: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.mr.MapRedTask
...
-
In the stored procedure of oracle, check that there is no GEN_ETL.R_AG_1_DAY@TO_CCGENESYS table?
then why is there still the following code?
from GEN_ETL.R_AG_1_DAY@TO_CCGENESYS t1,
GEN_ETL.O_AG_1_DAY@TO_CCGENESYS t2
...
-
False
-
Django, Why does the system automatically generate an empty session? every time the request is made?
-
Use python to convert dict1 to dict2, in the example. I tried for a long time but couldn't find a solution.
-
How to self-start the php-fpm service when building a LNMP environment with docker?
-
Can an array in react state be bound to a dom state using an element in the array?
-
Wechat browser version 6.6.5 cannot prevent the springback of pull-up and drop-down to the top under ios system.
-
In express+hbs, how do you define the routed data as a variable on the page?
-
How to use symbol reference of Iconfont in dva
-
How to elegantly add data to JSON objects?
-
Using node to build video streaming server
-
The proportional width of the echarts graph is inconsistent.
-
React uses axios to call the background data. After success, how to jump to the page based on the returned value?
-
I don't understand what a linux command means. Please explain it.
-
Vue introduces multiple components in vue-router by nesting named views, and does not refresh the same reference in other pages.
-
Running nodejs reports fewer errors ")"
-
Baidu sharing fails, prompt sorry, check your sns sites answer!
-
How to design the inventory table of the purchase, sale and storage system?
-
What is the difference between Dcloud's 5+app and uni-app?
-
A pit that uses template strings in angularjs
-
Why didn't event bus work?
Menu