Python Forum
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Sqlite CONCAT columns
#1
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

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()
Reply


Messages In This Thread
Sqlite CONCAT columns - by issac_n - Mar-22-2020, 08:00 AM
RE: Sqlite CONCAT columns - by ndc85430 - Mar-22-2020, 08:11 AM
RE: Sqlite CONCAT columns - by buran - Mar-22-2020, 08:24 AM
RE: Sqlite CONCAT columns - by issac_n - Mar-22-2020, 09:08 AM
RE: Sqlite CONCAT columns - by buran - Mar-22-2020, 09:31 AM

Possibly Related Threads…
Thread Author Replies Views Last Post
  DataFRame.concat() nafshar 3 873 Jul-14-2023, 04:41 PM
Last Post: nafshar
  Pandas AttributeError: 'DataFrame' object has no attribute 'concat' Sameer33 5 6,253 Feb-17-2023, 06:01 PM
Last Post: Sameer33
  Concat Strings paulo79 5 1,614 Apr-15-2022, 09:58 PM
Last Post: snippsat
  [SOLVED] Concat data from dictionary? Winfried 4 1,859 Mar-30-2022, 02:55 PM
Last Post: Winfried
  Create SQLite columns from a list or tuple? snakes 6 9,093 May-04-2021, 12:06 PM
Last Post: snakes
  pd.concat Problem WiPi 1 1,835 May-27-2020, 07:42 AM
Last Post: WiPi
  Concat multiple Excel sheets with exclusion alessandrotk 1 2,928 Jan-10-2020, 04:43 AM
Last Post: sandeep_ganga
  SQLite DB integration duplicate columns rachitmishra25 1 5,487 Oct-27-2017, 11:20 AM
Last Post: buran

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020