The "INSERT INTO" is a SQL statement that is used to insert new rows into a table.
Questions tagged [insert-into]
707 questions
-2
votes
3 answers
How to insert "/" into mysql
Anyone know how to insert "/" character into a string in mysql. I have a varchar field with 255 space. but when I insert a a string contain "1403/04". it is throwing an error.
EDIT: Here is my sql statement, I am using navicat to do the admin…
Visa
- 9
- 4
-2
votes
1 answer
MS Access Syntax error in INSERT INTO statement
I have a "Syntax error in INSERT INTO statement". Here is a copy code (the code is in a JFrame which I created using the GUI builder FYI):
private void jButtonSaveActionPerformed(java.awt.event.ActionEvent evt) { …
user3450753
- 3
- 4
-2
votes
2 answers
How do I insert into a form with over 100 fields
I've created a user form in which once the submit button is pressed I would like to send/insert the data to mysql database adding a new record. The form has over 100 input fields. How can I accomplish this. Here is my sample php code.
…
Don Austin
- 5
- 4
-3
votes
1 answer
How to insert multiple values in 11g?
How to insert multiple values in a table in oracle 11g using query?
I tried This
-3
votes
2 answers
Syntax error in INSERT INTO statement VB using Access
I've been struggling with this for a while now and just don't understand what is wrong. I'm doing this for my college coursework and have little to no experience in coding. All I am trying to do here is insert Values from my windows form into my…
Waylandd
- 1
-3
votes
3 answers
INSERT INTO not working for 2nd table
I'm new to PHP but normally able to solve most problems but this one has got me.
I'm trying to create a newsletter sign up (single field) with a single submit button. I have this working fine, sending out an email and inserting the form data into my…
Rich
- 1
- 4
-3
votes
1 answer
How to DELETE a table, then INSERT in PLSQL by SELECT * plus an additional column
I wish to delete the contents of a table, populate it with the contents from a very lengthy query, and also add another column of data.
My query and the table use identical field names, but the table has an additional column called LAST_UPDATED. …
QuestionMarks
- 246
- 3
- 24
-3
votes
2 answers
sql dml exercise 19
I have been working on this query for a couple of time I managed to find a solution but on the exercise solution itself it says I got the correct number of results but mismatch.
This is the exercise they propose:
Assuming that no any two battles…
Ken Wu
- 18
- 1
-3
votes
4 answers
Can't write to the database using INSERT INTO
I have written a form with server side validation using php and now my aim is to insert all the input's from my form into my database (which already has its tables). Below is my syntax:
//Example of one of my validations (for postcode input)
if…
sass
- 87
- 2
- 13
-3
votes
3 answers
PHP SQL INSERT INTO error message
So I'm doing some self learning on creating online forms with php.
On my first page I have the following:
Hi
-4
votes
1 answer
I can't insert a lots of rows to column in a table with other auto_increment column.
I've got the table with auto_increment ID column and i want to add another column, which would has copied numbers from ID column ( for example named copied_ID), so i
want to have two the same colmuns, one of them auto_increment.
before_photo
…
s7e0n5g1a
- 47
- 1
- 7
-4
votes
2 answers
Java JDBC Error Insert into
Here is the code:
String sqlstatment = "INSERT INTO order (orderedBy, totalItems, totalPrice) "+
"VALUES (?, ?, ?);";
ResultSet keys = null;
try (
PreparedStatement stmt = conn.prepareStatement(sqlstatment,…
23214asdasd
- 13
- 1
- 4
-4
votes
1 answer
SQL Inserting data from one table to another / Data type Error
I am trying to insert data from one SQL table to another. The problem is that the columns have different data types. And when I use Cast() I still get the following error message:
[Msg 8114, Level 16, State 5, Line 3 Error converting data type…
johankent30
- 65
- 2
- 3
- 11
-4
votes
2 answers
PHP insert into a table not working
I'm trying to insert items into a table but it isn't working although it's displaying a successful message :/
Here's my code & table.
SevnDK
- 31
- 8
-5
votes
1 answer
I could't insert data into MySQL table
I am facing the issue only when I try to insert data, where the same code runs perfectly well when I try inserting data to another table with different set of values.
CRAWLMINDS
- 1
- 1