MYSQL

FULL NAME TO FIRST, MIDDLE, LAST IN MYSQL

by admin 
UPDATE student t
JOIN (
    SELECT
        id,
        first AS full_name,
        SUBSTRING_INDEX(first, ' ', 1) AS f_name,
        SUBSTRING_INDEX(first, ' ', -1) AS l_name
    FROM student
) x ON t.id = x.id
SET
    t.first = x.f_name,
    t.middle = '',
    t.last = x.l_name;

Note : update your_table to required table name