Insert query in mysql I am using MySQL. I have table like below:

CREATE TABLE test_table
(
    first_name VARCHAR(20),
    last_name VARCHAR(20),
    full_name VARCHAR(40)
);


Now I want to insert values like below:

INSERT INTO test_table
VALUES('raju','pydi',CONCAT(first_name,last_name));


I know this will not work, but it illustrates what I want to achieve.

How can I do this with a query? (not a procedure or function or some other).
You could do something like:

INSERT INTO test_table
    (first_name,last_name,full_name)
SELECT first_name,last_name
     , CONCAT(coalesce(first_name,''),coalesce(last_name,''))
FROM (
    SELECT 'raju' as FIRST_NAME
          ,'pydi' as LAST_NAME
) AS T;


I still think it's a pretty bad idea to store full_name though. You could create a view like:

CREATE VIEW TEST_VIEW AS (
    SELECT first_name, last_name
         , CONCAT(coalesce(first_name,''),coalesce(last_name,'')) as full_name
    FROM test_table
);