Questions tagged [insert-into]

The "INSERT INTO" is a SQL statement that is used to insert new rows into a table.

707 questions
-2
votes
3 answers

SQLite: how do I fix syntax on INSERT INTO?

I have a column CARDNUM that I am trying to increment by +1 in a Table called TOTALCOUNT. App crashed with syntax error near "SET" This is my INSERT statement: db.execSQL("INSERT INTO "+ DBContract.DBEntry.TABLE_NAME_TOTALCOUNT+" SET "+…
AJW
  • 1,578
  • 3
  • 36
  • 77
-2
votes
1 answer

Inserting Value using php mysqli connection

DB and Table is created but the form values are not going into the database table Form field values are absolutely right i checked them by echo Is there any mistake in my insert into sql command. Code is as following …
-2
votes
2 answers

SQL Insert with value from different table

I have 2 tables storing information. For example: Table 1 contains persons: ID NAME CITY 1 BOB 1 2 JANE 1 3 FRED 2 The CITY is a id to a different table: ID NAME 1 …
Flying Dutch Boy
  • 344
  • 3
  • 17
-2
votes
1 answer

How to insert multiple row from textareas in MySQL

i cant insert to mysql from two textarea (both every row), first this is a add.html
text 1 :