Sqlite CONCAT columns

Thread Rating:

0 Vote(s) - 0 Average
1
2
3
4
5

Thread Modes

Sqlite CONCAT columns

buran

Posts: 8,091

Threads: 154

Joined: Sep 2016

Reputation: 582

Mar-22-2020, 08:24 AM (This post was last modified: Mar-22-2020, 08:24 AM by buran.)

c.execute("SELECT FirstName || ' ' || LastName as FullName from Employee")

It's not clear what you want - display concatenated names or insert a new column in a table, which you should not do given that you already have first name and last name as columns.

If you can't explain it to a six year old, you don't understand it yourself, Albert Einstein
How to Ask Questions The Smart Way: link and another link
Create MCV example
Debug small programs

Find

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	882	Jul-14-2023, 04:41 PM Last Post: nafshar
	Pandas AttributeError: 'DataFrame' object has no attribute 'concat'	Sameer33	5	6,320	Feb-17-2023, 06:01 PM Last Post: Sameer33
	Concat Strings	paulo79	5	1,621	Apr-15-2022, 09:58 PM Last Post: snippsat
	[SOLVED] Concat data from dictionary?	Winfried	4	1,872	Mar-30-2022, 02:55 PM Last Post: Winfried
	Create SQLite columns from a list or tuple?	snakes	6	9,133	May-04-2021, 12:06 PM Last Post: snakes
	pd.concat Problem	WiPi	1	1,845	May-27-2020, 07:42 AM Last Post: WiPi
	Concat multiple Excel sheets with exclusion	alessandrotk	1	2,932	Jan-10-2020, 04:43 AM Last Post: sandeep_ganga
	SQLite DB integration duplicate columns	rachitmishra25	1	5,492	Oct-27-2017, 11:20 AM Last Post: buran

Users browsing this thread: 1 Guest(s)

View a Printable Version

Sqlite CONCAT columns

User Panel Messages

Announcements