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

Popular posts from this blog

list macos calm editors formula editors

how hibernate @any-related annotations?

why does floated <input> control floated component slip over too distant right ie7, nonetheless firefox?