The "INSERT INTO" is a SQL statement that is used to insert new rows into a table.
Questions tagged [insert-into]
715 questions
-2
votes
1 answer
T-SQL INSERT INTO disabling Constraints check
i would like to temporarly(just for the t-sql statement) disable the constraints check.
My statement is:
insert into branchOffice(
branchOfficeTypeId,
labirintoClientiId,
companyId,
signboardName,
address,
addressNumber,
zipCode,
city,
province,…
Alessio Bacin
- 71
- 1
- 8
-2
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
- 20
- 1
-2
votes
1 answer
Mysql_query error in PHP
)
I am building a website, but ran into an error... I have a script that is supposed to upload variable values to an sql database. I am using or die(mysql_error()), but i get nothing, as if the mysql is working, but the variables aren't populated...…
user2326923
- 43
- 6
-2
votes
1 answer
How to SQL DML - sql-ex.ru exercise 18
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 somethings missing.
This is the exercise they propose.
You should add from the…
Miguel Santos
- 3
- 3
-2
votes
1 answer
I have an error in my php insert into code
There is an error:
Could not run query: You have an error in your SQL syntax; check the
manual that corresponds to your MySQL server version for the right
syntax to use near ''')' at line 2
Prem ThAqqar
- 99
- 1
- 10
-2
votes
2 answers
Insert INTO queries using WHERE clause
I have issue on INSERT INTO query,
In the registration form, when user enter username and select the department/center as bursary,
I want to insert that UserName into table bursary.
What I tried is;
$query14 = "INSERT INTO bursary (UserName) VALUES …
satish
- 37
- 4
-2
votes
1 answer
Wont insert into database( comment on a comment)
What I'm trying to do here is
comment on a comment, like Facebookm but it wont insert, and it's not getting c_id & mem_id.
It needs to get the [c_id from blog] and [mem_id from blog_users] then INSERT INTO blog_subcomments.
I just want to know why…
Jonathan
- 123
- 10
-2
votes
1 answer
(PHP/MYSQL) mysql_real_escape_string not working
Recently, I've been having a problem with INSERT INTO not working properly when inserting certain strings. I discovered that the cause was the string contained apostrophes which were messing with my code. To solve this, I've been trying to use…
MNOPYZ
- 55
- 1
- 2
- 13
-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
4 answers
Insert data in mysql colum with spaces with php
I've got a little question about my script, I'm trying to enter a lot of data in my MySQL database but I've got the next problem
I can't enter the data with php because there is a space in one of my column names
here is the code
$qw1 = "voornaam,…
Pieter-Jan Coenen
- 11
- 2
- 7
-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