i have read several different threads none of contained helpful information pertaining problem. i've created database in mysql workbench , have connected winscp htlm/java/php website. i'm trying insert list of data workbench i'm getting error code 1054 message.
use csc272_mkp; drop table if exists articletable; create table articletable ( id int primary key, articletitle text, articleauthor varchar(255), yeararticlepublished mediumint, resourcetypearticle mediumint ); insert articletable (articletitle, articleauthor, yeararticlepublished, resourcetypearticle) values ("tellus. aenean","miriam k. stout",1926,999),("cursus,","ira s. fry",1935,999),("pellentesque","macey h. hawkins",1930,999),("eget metus. in","marah u. mccoy",1995,999),("primis in faucibus","serena p. sweet",1969,999),("aliquam","stephen m. sheppard",1923,999),("nulla eu neque","charde y. gill",1973,999),("id, ante.","portia u. woodard",1909,999),("at,","kennedy j. duke",1969,999),("quis","imogene j. mejia",1987,999),("quam dignissim","mikayla j. pierce",1996,999),("elementum sem,","duncan q. henson",1938,999),("quam, elementum at,","kareem g. dickerson",1940,999),("elit","heather t. knox",1993,999),("felis","hector i. burnett",1990,999),("malesuada fames ac","samson o. miranda",1980,999),("ad","mariam v. wilkins",1926,999),("sed","brian x. reese",1937,999),("donec est. nunc","sebastian z. guerrero",1941,999),("neque sed sem","jade n. harper",1911,999),("nam ligula elit,","rina u. bird",1995,999),("duis","judah t. fulton",1901,999),("dolor. fusce feugiat.","hammett i. rivas",1930,999),("vulputate, nisi","barclay o. chase",1961,999),("mauris","jolene p. russell",1958,999),("donec","hanae r. hanson",1929,999),("a neque. nullam","naomi e. allison",1906,999),("mattis","clark g. carroll",1918,999),("integer","tyler v. simon",1919,999),("velit","pandora n. boyle",1918,999),("nascetur ridiculus mus.","ivy m. blair",2002,999),("turpis. nulla aliquet.","jolene y. reeves",1918,999),("cursus","thaddeus n. drake",1931,999),("pretium et,","kim u. horn",1903,999),("magnis dis parturient","armand g. mccray",1997,999),("aliquam nisl.","malcolm z. best",1922,999),("integer eu lacus.","pamela w. conley",1930,999),("mauris. integer sem","roth b. gillespie",1948,999),("non lorem vitae","lael c. boyer",1942,999),("at, iaculis quis,","cadman f. puckett",1915,999),("vitae","keegan k. mayo",1907,999),("arcu. vestibulum","jocelyn m. mooney",1904,999),("etiam","gil b. wooten",1981,999),("nisi. aenean eget","maite s. whitney",1962,999),("molestie","demetrius h. kemp",1969,999),("tempus risus.","priscilla h. mcintosh",1995,999),("dolor. fusce mi","brock u. wynn",1915,999),("enim. suspendisse aliquet,","hollee i. koch",1967,999),("integer aliquam adipiscing","kermit g. woodard",1926,999),("diam","grant z. browning",1935,999),("malesuada","natalie j. boone",1955,999),("ligula","darius u. vance",1936,999),("sollicitudin","maya x. ryan",1908,999),("nonummy ac,","joseph f. raymond",1912,999),("pellentesque","davis b. cervantes",2008,999),("neque vitae semper","ori i. kidd",1910,999),("quisque varius.","joy j. roth",1934,999),("sem eget","alden y. forbes",1928,999),("mauris. suspendisse aliquet","blaine y. chapman",2001,999),("ornare, elit elit","ryan a. mendez",1934,999),("ligula","uriah u. hale",1961,999),("tincidunt","xavier x. bradley",1955,999),("inceptos","isabella e. gonzalez",1953,999),("in","charde i. franklin",1952,999),("arcu imperdiet","azalia j. obrien",1914,999),("maecenas ornare","christine z. brewer",1957,999),("morbi","dexter t. melendez",1927,999),("cras sed leo.","alfreda m. shaw",2004,999),("eu","mary u. shelton",1973,999),("congue,","juliet j. padilla",1960,999),("magna. cras","ishmael w. cortez",1905,999),("penatibus","russell b. dennis",2000,999),("ridiculus mus. proin","uriah m. pate",1983,999),("neque pellentesque massa","cassandra x. diaz",1939,999),("porttitor interdum. sed","rae r. weiss",1917,999),("morbi non sapien","ori k. watson",1901,999),("auctor","larissa z. campos",1910,999),("dui quis accumsan","leilani q. terry",1932,999),("pede, malesuada vel,","ursa f. hanson",1908,999),("sed pede nec","ina o. avila",1981,999),("ac","elton l. hansen",1943,999),("lacinia.","skyler n. morton",1914,999),("eleifend","hanna h. stokes",1973,999),("eu","martin p. mcdaniel",1996,999),("primis","ryder x. bruce",1936,999),("felis.","gillian k. holmes",1992,999),("ut eros","jenna e. livingston",1939,999),("aliquet. phasellus","clarke z. ruiz",1903,999),("duis risus","iliana g. harrington",1959,999),("sed,","randall j. brennan",1911,999),("non,","meghan y. eaton",1975,999),("luctus ut, pellentesque","jessica v. nash",1948,999),("convallis est, vitae","brooke v. sellers",1954,999),("aliquet libero.","hasad t. noble",1942,999),("amet ornare","risa t. holcomb",1900,999),("fusce fermentum fermentum","briar e. washington",1948,999),("non, lobortis","malik r. ward",1971,999),("cras pellentesque.","rafael v. sears",1930,999),("adipiscing ligula. aenean","briar b. stanton",1944,999),("augue scelerisque","stone k. barry",1976,999); select * articletable; any or ideas appreciated. apologies if redundant question couldn't find anywhere.
running sql i've got error related id column:
that's because you've created table (primary key) id column forgot set auto increment column.
once set id column auto increment you'll able insert new records on table:
Comments
Post a Comment