Field ‘id’ doesn’t have a default value?

by

As id is the primary key, you cannot have different rows with the same value. Try to change your table so that the id is auto incremented:

id int NOT NULL AUTO_INCREMENT

and then set the primary key as follows:

PRIMARY KEY (id)

All together:

CREATE TABLE card_games (
   id int(11) NOT NULL AUTO_INCREMENT,
   nafnleiks varchar(50),
   leiklysing varchar(3000), 
   prentadi varchar(1500), 
   notkunarheimildir varchar(1000),
   upplysingar varchar(1000),
   ymislegt varchar(500),
   PRIMARY KEY (id));

Otherwise, you can indicate the id in every insertion, taking care to set a different value every time:

insert into card_games (id, nafnleiks, leiklysing, prentadi, notkunarheimildir, upplysingar, ymislegt)

values(1, 'Svartipétur', 'Leiklýsingu vantar', 'Er prentað í: Þórarinn Guðmundsson (2010). Spilabókin - Allir helstu spilaleikir og spil.', 'Heimildir um notkun: Árni Sigurðsson (1951). Hátíðir og skemmtanir fyrir hundrað árum', 'Aðrar upplýsingar', 'ekkert hér sem stendur' );

More Related Contents:

  1. MySQL Conditional Insert
  2. Get the new record primary key ID from MySQL insert query?
  3. Create a temporary table in a SELECT statement without a separate CREATE TABLE
  4. Which is faster: multiple single INSERTs or one multiple-row INSERT?
  5. SQL – IF EXISTS UPDATE ELSE INSERT INTO
  6. MySql Table Insert if not exist otherwise update
  7. Mysql: Setup the format of DATETIME to ‘DD-MM-YYYY HH:MM:SS’ when creating a table
  8. Increment a database field by 1
  9. MySQL: Error Code: 1118 Row size too large (> 8126). Changing some columns to TEXT or BLOB
  10. Prevent auto increment on MySQL duplicate insert
  11. MySQL trigger On Insert/Update events
  12. BULK INSERT in MYSQL
  13. How do I get the ID of multiple inserted rows in MySQL?
  14. MySQL trigger to update a field to the value of id
  15. How to insert data to MySQL with auto-incremented column(field)?
  16. MySQL INSERT INTO … VALUES and SELECT
  17. MySQL Insert & Joins
  18. How to add a where clause in a MySQL Insert statement?
  19. Reserved word in column name – insert into MySQL [duplicate]
  20. What are practical differences between `REPLACE` and `INSERT … ON DUPLICATE KEY UPDATE` in MySQL?
  21. MySQL LAST_INSERT_ID() used with multiple records INSERT statement
  22. Mysql insert into 2 tables
  23. MySQL – insert data from another table merged with constants
  24. Insert data into table with result from another select query
  25. Alter table if exists or create if doesn’t
  26. MySQL optimizing INSERT speed being slowed down because of indices
  27. MySQL: Insert datetime into other datetime field
  28. “Unknown column in ‘field list'”, but column does exist
  29. Is there a way to use ON DUPLICATE KEY to Update all that I wanted to insert?
  30. Insert and set value with max()+1 problems

Leave a Comment