Sqlite CONCAT columns

Thread Rating:

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

Thread Modes

Sqlite CONCAT columns

issac_n
Not Blown Up Yet

Posts: 55

Threads: 24

Joined: Nov 2017

Reputation: 0

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

(Mar-22-2020, 08:24 AM)buran Wrote:
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.

hi buran,

thx for the code, it is working but DB does not update it. how to update in DB?

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: 2 Guest(s)

View a Printable Version

Sqlite CONCAT columns

User Panel Messages

Announcements