Sqlite - Revision history

Leo: Added categories and navbox

2021-12-30T01:16:13Z

Added categories and navbox

← Older revision		Revision as of 01:16, 30 December 2021
Line 43:		Line 43:
	*CLI: https://sqlite.org/cli.html		*CLI: https://sqlite.org/cli.html
	*Types: https://www.tutorialspoint.com/sqlite/sqlite_data_types.htm		*Types: https://www.tutorialspoint.com/sqlite/sqlite_data_types.htm

			{{Navbox Linux}}
			[[Category:Linux]]
			[[Category:LinuxUtilities]]

Leo: scripting

2020-07-03T21:41:06Z

scripting

← Older revision		Revision as of 21:41, 3 July 2020
Line 1:		Line 1:
	== Quick Usage ==		==Quick Usage==
	Run <code>sqlite3</code>. Use .tables to show tables.		Run <code>sqlite3</code>. At the prompt, you can open (or create a new) database with .open. Use .tables to show tables.

			You can then begin entering SQL queries. For scripting, you can also pipe these queries to the sqlite3 program.

	Create a table		Create a table
Line 29:		Line 31:
	}}		}}

	== See Also ==		=== Scripting ===
			There are two ways to pipe queries for execution. Either pipe it directly with <code>\|</code> or by piping a file into stdin with <code>< filename</code>.
			{{Highlight
			\| code = # echo "INSERT ..." {{!}} sqlite3 database.db
			# sqlite3 database.db < queries.sql
			\| lang = terminal
			}}

			==See Also==

	* CLI: https://sqlite.org/cli.html		*CLI: https://sqlite.org/cli.html
	* Types: https://www.tutorialspoint.com/sqlite/sqlite_data_types.htm		*Types: https://www.tutorialspoint.com/sqlite/sqlite_data_types.htm

Leo: Created page with "== Quick Usage == Run `sqlite3`. Use .tables to show tables. Create a table {{Highlight | code = create table bandwidth ( mac character(12), time datetime, tx_b..."

2020-07-03T05:47:58Z

Created page with "== Quick Usage == Run <code>sqlite3</code>. Use .tables to show tables. Create a table {{Highlight | code = create table bandwidth ( mac character(12), time datetime, tx_b..."

New page

== Quick Usage ==
Run <code>sqlite3</code>. Use .tables to show tables.

Create a table
{{Highlight
| code = create table bandwidth (
mac character(12),
time datetime,
tx_bytes unsigned int,
rx_bytes unsigned int
);
| lang = sql
}}
Create a composite key
{{Highlight
| code = CREATE UNIQUE INDEX pk_index ON "bandwidth" ("mac", "time");
| lang = sql
}}
Find the current hour as a timestamp, which you can insert as a datetime field?
{{Highlight
| code = select strftime('%s', 'now') - (strftime('%s','now')%3600);
| lang = sql
}}
To insert a record:
{{Highlight
| code = insert into bandwidth ('mac', 'time', 'tx_bytes', 'rx_bytes')
VALUES ('000c2958db2f', strftime('%s', 'now') - (strftime('%s','now')%3600), 100, 100);
| lang = sql
}}

== See Also ==

* CLI: https://sqlite.org/cli.html
* Types: https://www.tutorialspoint.com/sqlite/sqlite_data_types.htm

Sqlite - Revision history

Leo: Added categories and navbox

Leo: scripting

Leo: Created page with "== Quick Usage == Run sqlite3. Use .tables to show tables. Create a table {{Highlight | code = create table bandwidth ( mac character(12), time datetime, tx_b..."

Leo: Created page with "== Quick Usage == Run `sqlite3`. Use .tables to show tables. Create a table {{Highlight | code = create table bandwidth ( mac character(12), time datetime, tx_b..."