select same list an insert update
clearly following incorrect.
insert `atable` (`a`,`b`) values((select max(`a`) `atable`)*2),'name');
i value:
sql query:
insert `atable` (`a`, `b` )
values
(
(
name max(`a`)
`atable`
) *2
, 'name'
)
mysql said:
1093 - can't mention aim list 'atable' transform apportionment
so, i'm perplexing bitmap table, any quarrel corresponds bit, 'map' value.
to insert table, i don't wish twin queries, i wish one.
how should i this?
no commented this, nonetheless given i am perplexing bitmap, should * 2 ^ 2, mistake, greatfully note since comments mostly contend ^ 2, an blunder chronicle commenters read.
Comments
Post a Comment