mysql insert into table values current time

So far I've successfully inserted data into 'items' like that: $sql = 'INSERT INTO items (SKU, name, price) VALUES ('$SKU', '$name', '$price')' īut I can't reach out 'attributes' table. I want to extract data from this form and insert into tables - items and attributes. Each of them has it's own input field in the form. How is it possible to insert data into table as key-value pairs? I need to insert data for size, height, width, length, weight. Insert into Orders values (123,'Popp圜ounter','Chocltae',now (),now ()) You need to use now () (instead of 'now') as you are looking for the function and not for the string. Where as now is a string literal and not equal to any date and time.

And I can't just type INSERT INTO attributes (SKU, key, value) VALUES ('$SKU', '$size', '$height'. now () is a MySQL function on currenttimestamp. And values like integers for each dimension. Sometime you just want to set some fields not all of them. The keys like 'size', 'height', 'weight' etc. Fields are not always mandatory in a table. INSERT INTO attributes (column1, column2, column3) VALUES ('value1', 'value2', 'value3')' īut the problem is that my second table 'attributes' contents data as key-value pairs. CREATE TABLE servers ( id int(11) NOT NULL PRIMARY KEY autoincrement, servername varchar(45) NOT NULL, onlinestatus varchar(45) NOT NULL, exchange varchar(45) NOT NULL, diskspace varchar(45) NOT NULL, networkshares varchar(45) NOT NULL, datetime datetime NOT NULL. From what you did, that shows Many to Many table relationship, and the right schema would be creating a new table that has FK to those 2 tables. I know that it's possible to insert data into several tables like that: $sql = 'INSERT INTO items (column1, column2, column3) VALUES ('value1', 'value2', 'value3') Even though there are many accepted answers, I think this way is also possible: Create your 'servers' table as following . For 1 to 1 table relationship, that doesn't mean you have to put their PK on each other, instead people usually decide which FK goes to another table and that's all. Tables are connected via SKU column as primary/secodnary key. And 'id' is an ID for each attribute in 'attributes'. I've got two tables 'items' and 'attributes'. I'm asking for some help regarding inserting data into MySQL database from PHP form.

Mysql insert into table values current time