Writing to two tables from a CSV file

[Toan Trac]

Hi,

I found the code that is able to write the data but want to able to do import of more than one record from a csv file. Can someone help me get started.

Below is the current code that I found.


Thanks ahead, TT

-- Generate salt, set @dis to 0 to activate account
SET @salt = UNHEX(SHA2(UUID(), 256));
SET @dis = '1';

-- Create base entity entry for user
INSERT INTO guacamole_entity (name, type)
VALUES ('user1', 'USER');

-- Create user and hash password with salt
INSERT INTO guacamole_user (
entity_id,
password_salt,
password_hash,
password_date,
disabled
)
SELECT
entity_id,
@salt,
UNHEX(SHA2(CONCAT('user1', HEX(@salt)), 256)),
CURRENT_TIMESTAMP,
@dis
FROM guacamole_entity
WHERE
name = 'user1'
AND type = 'USER';