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 i practical urls indicate .aspx pages asp.net deployed an iis? (preferably but iis)

jaxb - xjc - reworking generated typesafe enum category members