How to write 'create table ... as select [some number/function] as test' in MySQL 5.5 so t-CodePudding

Home > Mobile > How to write 'create table ... as select [some number/function] as test' in MySQL 5.5 so t

How to write 'create table ... as select [some number/function] as test' in MySQL 5.5 so t

Time：07-22

I build the empty frame of a table in MySQL by taking a huge query, adding a WHERE 1 = 0 condition (to shrink down the output rows to 0) and running it like the following tiny example:

create table xzy as 
select convert(2147483647, signed) as test
WHERE 1 = 0

I thought taking the

Information about that was found around the middle of the page here.
(their example used a bigint value)

Here's a dbfiddle (using verson 5.5) with example use.

Page link：https//www.codepudding.com/Mobile/484739.html

Prev:Get last 3 rows from SQL table without duplicates of a row

Next:Add a column to the Woocommerce Orders page

Tags：

mysql

select

integer

create-table

mysql-5.5

Links：
CodePudding