SQL_ADMIN(oh)			     LOCAL			 SQL_ADMIN(oh)

sql_admin - SQL admin

DATABASE_ACTIONS
	   [CREATE|DROP] DB_ELEMENT [IF [NOT] EXISTS] ELEMENT_NAME;

     DB element	   : can be table, view, trigger.
     Exists	   : create if item does not exist or drop if it exists.

TABLE_ACTIONS
     insert : INSERT INTO <TABLE_NAME>(<COLUMNS>) VALUES(<VALUES>);
     update : UPDATE <TABLE_NAME> SET <COLUMN_NAME> = <VALUE>;
     delete : DELETE FROM <TABLE_NAME> WHERE <CONDITION>;

SCHEMA_DEFINITIONS
   Tables
     CREATE TABLE <TABLE_NAME> (
	     COLUMN_NAME1 DATA_TYPE,
	     COLUMN_NAME2 DATA_TYPE
     );

   Views
     Queries can be saved as views: create view VIEW_NAME as QUERY;

   Triggers
     Specify action to be executed on events:
     create trigger TRIGGER_NAME [BEFORE|AFTER] [EVENT]
     begin
	     STATEMENT
     end;
     EVENT can be:

     insert : INSERT ON <TABLE_NAME>
     update : UPDATE OF <COLUMN_NAME> ON <TABLE_NAME>
     delete : DELETE ON <TABLE_NAME>
     Field references can be:

     insert : new.COLUMN_NAME
     update : new.COLUMN_NAME and old.COLUMN_NAME
     delete : old.COLUMN_NAME
     Example
     CREATE TRIGGER <TRIGGER_NAME> AFTER INSERT on <TABLE_NAME> begin
     UPDATE <TABLE1_NAME> set <COLUMN_NAME> = new.<COLUMN_NAME>;
     end;

SEE ALSO
     sql(oh) , sqlite3(oh) , mysql(oh)

AUTHORS
     ohazot(oh) | ABOUT_OH(oh) | ohazot.com: https://ohazot.com
     <admin@ohazot.com>

linux , OpenBSD 7.8 |
		    Created:2026-05-14|Updated:2026-05-14|	 SQL_ADMIN(oh)