Hi, On Thu, Sep 3, 2015 at 5:33 AM, manash b <boruah.manash18 at gmail.com> wrote: > Hello, > > > I am using SQLite version 3.8.11.1 and PHP for my web application. > > Table *employee* has 4 columns. Last two columns have default NULL values. > > Insert query - > > > > *INSERT INTO employee SELECT 3 AS 'eid','manash' AS 'name' > UNION SELECT 2,'ram' UNION** SELECT 1,'rahim'* > > > Getting error - > > ["SQLSTATE[HY000]: General error: 1 table employee has 4 columns but 2 > values were supplied > > > How can i handle this? Please let me know.
Could you please post "CREATE TABLE employee" statement? Thank you. > > > > Thanks, > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
