MySQL database doubts

Navigation
0

In this database and I can not do it:

I have this: 

 value_id | entity_type_id | attribute_id | entity_id | value
 600      | 2              | 22           | 40        | Gaga
 601      | 2              | 20           | 40        | Tonha

And I'd like to turn it around 

 value_id | entity_type_id | attribute_id | entity_id | value1  | value2
          |                |              |           | Gaga    | Tonha

The rest of the fields that are blank, for me it does not matter or not

    
asked by anonymous 14.12.2017 / 20:21

1 answer

0

To add the value2 column to the table: 

ALTER TABLE suatabela ADD value2 varchar(255)

Once you've done this you can enter your data in this way: Ex: 

INSERT INTO suatabela VALUES(600,2,22,40,'Gaga','Tonha');
    
14.12.2017 / 20:32
Get the value of an input in JS to send to PHP file Angular Installation CLI stands still