Home >Database >Mysql Tutorial >How can we use the output of any expression, function, etc. that MySQL self-evaluates to insert a value in a row?
When inserting a value in a row, we can use any expression, function, etc. to self-calculate the output value. Here is an example to demonstrate it -
mysql> Insert into employee(id, emp_name)Select 1+1, Concat_ws(' ','Gaurav', 'Kumar'); Query OK, 1 row affected (0.04 sec) Records: 1 Duplicates: 0 Warnings: 0 mysql> Select * from employee; +------+--------------+ | id | emp_name | +------+--------------+ | 2 | Gaurav Kumar | +------+--------------+ 1 row in set (0.00 sec)
The above is the detailed content of How can we use the output of any expression, function, etc. that MySQL self-evaluates to insert a value in a row?. For more information, please follow other related articles on the PHP Chinese website!