Re: Table Insert Question

[Rick James]

Eh? Sounds rather complicated. How about simply:

DROP TABLE IF EXISTS harbor_layout;
CREATE TABLE harbor_layout (
    id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
    dock CHAR(60)
);

INSERT INTO harbor_layout
         (dock)
    SELECT Concat(float_num,' : ',permanent_assignee,
                            ' *',temporary_assignee )
         FROM harbor
         Order by harbor.id asc;

By not specifying "id" in the INSERT, and because it is AUTO_INCREMENT, "id" will be automatically assigned, beginning with 1.