Top "Insert-into" questions

Adding a line break in MySQL INSERT INTO text

Could someone tell me how to add a new line in a text that I enter in a MySql table? …

mysql newline insert-into

INSERT INTO...SELECT for all MySQL columns

I'm trying to move old data from: this_table >> this_table_archive copying all columns over. I've tried …

mysql select insert-into

mysql -> insert into tbl (select from another table) and some default values

As the title says, I am trying to insert into one table selecting values from another table and some default …

mysql insert-into

Inserting values into tables Oracle SQL

I'm trying to insert values into an 'Employee' table in Oracle SQL. I have a question regarding inputting values determined …

sql oracle database-design insert-into

sql - insert into multiple tables in one query

assuming that i have two tables, names and phones and i want to insert data from some input to the …

sql mysql multiple-tables insert-into

Inserting records into a MySQL table using Java

I created a database with one table in MySQL: CREATE DATABASE iac_enrollment_system; USE iac_enrollment_system; CREATE TABLE …

java mysql sql jdbc insert-into

MySQL How do you INSERT INTO a table with a SELECT subquery returning multiple rows?

MySQL How do you INSERT INTO a table with a SELECT subquery returning multiple rows? INSERT INTO Results ( People, names, ) …

mysql select subquery insert-into

SQL Insert Into Temp Table in both If and Else Blocks

I'm trying to populate a temp table based on the result of a condition in SQL 2005. The temp table will …

sql sql-server-2005 temp-tables insert-into

SQL DML: Incorrect date value (MySQL)

I created a table in my database: CREATE TABLE official_receipt( student_no INT UNSIGNED, academic_year CHAR(8), trimester ENUM(…

mysql insert-into date-format dml

Enforce a foreign-key constraint to columns of same table

How to enforce a constraint of foreign key on columns of same table in SQL while entering values in the …

sql oracle foreign-keys self-reference insert-into