Re: Insert data from CONCAT data from one table using select statement into new table

[Tim Burke]

I figured it out... This is exactly what I wanted to do.


CREATE TABLE username (
usernameID INT AUTO_INCREMENT PRIMARY KEY,
IDNumber INT NOT NULL,
username CHAR(6),
FOREIGN KEY (IDNumber) REFERENCES person(IDNumber));

insert into username (IDNumber, username) select IDNumber, (concat(substring(FirstName,1,1),substring(LastName,1,1),substring(IDNumber,1,4))) username from person;