mysql - INSERT INTO and the subquery with COUNT -

-

i'd put photo data table articles_photos , condition numbers of photos selected article.

both tables exist. below have presented query

insert articles_photos(title,                              filename,                              photo_order,                              created,                              article_id)        values ('title',                'filename',                 (select count(id)                    articles_photos                   article_id = 7) + 1,                now(),                7)

phpmyadmin says:

static analysis:  5 errors found during analysis.      comma or closing bracket expected (near "select" @ position 109)     unrecognized keyword. (near "count" @ position 116)     unexpected token. (near "(" @ position 121)     unexpected token. (near "id" @ position 122)     unexpected token. (near ")" @ position 124)  #1093 - table 'articles_photos' specified twice, both target 'insert' , separate source data

what did wrong?

you close. believe following work:

insert articles_photos(title,                          filename,                          photo_order,                          created,                          article_id)  select 'title',      'filename',      count(id)+1,      now(),      7 articles_photos  article_id = 7;

you should able select same table upon inserting, can't in subquery inside values list had in question. instead, here, move constants down select statement.


Comments

Post a Comment

Popular posts from this blog

sequelize.js - Sequelize group by with association includes id -

-
so when requesting group sequelize follows: return models.workingcalendar .findall({ attributes: [ 'workingcalendar.periodid', 'workingcalendar.date', 'period.name' ], include: [ { model: models.period, attributes: [] } ], where: { getsudoid: currentgetsudo.id, unitplantid: unitplantid }, group: ['workingcalendar.periodid', 'workingcalendar.date', 'period.name'], }); sequelize run query: select [workingcalendar].[id], [workingcalendar].[periodid], [workingcalendar].[date], [period].[name] [workingcalendars] [workingcalendar] left outer join [periods] [period] on [wor...
Read more

c++ - Migration from QScriptEngine to QJSEngine -

-
i'm migrating qscriptengine code on qjsengine. now, have: class pars { public: static qscriptvalue printmainlog(qscriptcontext* c, qscriptengine* e); }; qscriptvalue pars::printmainlog(qscriptcontext* c, qscriptengine* e) { //some actions return e->globalobject().property(""); } ... qscriptengine engine; ... engine.globalobject().setproperty("printlog",engine.newfunction(pars::printmainlog)); so, user can put printlog("what ever"); in application in , example, qlineedit , function pars::printmainlog evalute. is there way qjsengine? so, user put same printlog("what ever");? way find here , user should put logger.printlog("what ever"); logger class inherited qobject printlog slot.
Read more

delphi - Take screenshot in webcam using VFrames in Console Application -

-
i'm doing program take picture of webcam using delphi xe2 , vframes achieve this, problem have figured out, in graphic application works fine, when use unit in console application, returns me error saying first chance exception @ $76b6b727. exception class eaccessviolation message 'access violation @ address 004a271b in module 'console.exe'. read of address 00000260'. process console.exe (3676) my unit : unit webcam; interface uses sysutils, windows, vcl.imaging.jpeg, vcl.graphics, vsample, vframes, classes; type twebcam = class private procedure newvideoframeevent(sender: tobject; width, height: integer; dataptr: pointer); public constructor create; destructor destroy; override; procedure capture_webcam(take_name: string); end; var web_image: tvideoimage; name_screen: string; implementation constructor twebcam.create; begin inherited create; end; destructor twebcam.destroy; begin inherited destroy; end; ...
Read more