Mar-22-2020, 08:00 AM
How should I create a column by concat First Name and LastName in Sqlite (python environment)?
I getting a syntax error when i defining "as" below
I getting a syntax error when i defining "as" below
conn_dB = sqlite3.connect('EmployeeDB.db') c= conn_dB.cursor() c.execute(SELECT *CONCAT( "FirstName" ,' ', "LastName") as FullName FROM Employee) conn_dB.commit() c.close()