codingtcher.com
Theme Night
Home
Login

Sql Insert Into

Home » Sql » Sql Insert Into

insert into sql

$sql = "INSERT INTO table_name('arg1, 'arg2', ...) VALUES ('value1,
value2, ...)'";

sql insert

INSERT INTO sakila.actor
    (first_name, last_name)  # column names to insert into
VALUES
    ("Ryan", "Desmond");  # values to insert into those columns (in the same order)


# in SQL, the hashtag or pound sign is the comment symbol, just FYI

insert in sql

INSERT INTO tableName
VALUES (‘anydata’, ‘anydata’, ‘anydata’, ‘anydata’, NULL,
NULL);

sql insert query

INSERT INTO `products` (`id`, `name`) VALUES (1,'Blue Casual T-Shirt');
//here 'products' is table name

SQL INSERT INTO Statement

INSERT INTO Customers(customer_id, first_name, last_name, age, country)
VALUES
(5, 'Harry', 'Potter', 31, 'USA');

sql insert into


INSERT INTO c_change_log_index ( change_log_row_id, video_id, type, ch, word, s,e,l, cdt)
SELECT p.id, p.video_id, c.type, c.ch, c.word, c.s, c.e, c.l, c.cdt
FROM c_change_log p
INNER JOIN c_change_log_index c ON c.Id = p.Id
Source: stackoverflow.com

Sql Related Post