[Tutor] make a sqlite3 database from an ordinary text file

Dennis Lee Bieber wlfraed at ix.netcom.com
Sun Jun 19 15:17:06 EDT 2022


On Mon, 20 Jun 2022 00:03:27 +0530, Manprit Singh
<manpritsinghece at gmail.com> declaimed the following:

>Yes sir ,
>I do agree it will fail for second time , if table exists .
>
>One treatment could be writing the command like create table table_name if
>not exist (--------)
>

	The syntax for that is

		CREATE TABLE IF NOT EXISTS <table-name> ...


-- 
	Wulfraed                 Dennis Lee Bieber         AF6VN
	wlfraed at ix.netcom.com    http://wlfraed.microdiversity.freeddns.org/



More information about the Tutor mailing list