Recent questions tagged ddl

0 votes

442 views

1 answer

ddl - MySQL: ALTER TABLE if column not exists

I have this code: ALTER TABLE `settings` ADD COLUMN `multi_user` TINYINT(1) NOT NULL DEFAULT 1 And I want ... make this as simple as possible? See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

359 views

1 answer

ddl - Adding multiple columns AFTER a specific column in MySQL

I need to add multiple columns to a table but position the columns after a column called lastname. I have tried this: ... can I use AFTER in a query like this? Question&Answers:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

308 views

1 answer

ddl - Can a number be used to name a MySQL table column?

I have a table that has column names like 25, 50, 100, etc.. When trying to update the table I get an error, ... it possible to use a number as a column name? Question&Answers:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

251 views

1 answer

ddl - add column to mysql table if it does not exist

My research and experiments haven't yielded an answer yet, so I am hoping for some help. I am modifying the install ... Does anyone have a good way to do this? Question&Answers:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

349 views

1 answer

ddl - Concat variable with a string in location parameter in a create statement?

In Greenplum, I need to create an external table with a dynamic location parameter. For an example: CREATE READABLE TABLE_A( ... 'gphdfs://teste:1010/tmp' " Can anyone help me?...

asked Feb 19, 2021 in Technique[技术] by 深蓝 (71.8m points)

Categories

Just Browsing Browsing

Most popular tags