PLCSQL 0.7

Description:

PLCSQL 0.7

let's go through each function and provide examples on how to use them.


CD (Create Database):
This function creates a new database.
Example:
CD("mydatabase", mydb)


CT (Create Table):
This function creates a new table.
Example:
CT("mytable (id INT AUTO_INCREMENT PRIMARY KEY, name VARCHAR(255))", mydb)


IV (Insert Values):
This function inserts values into a table.
Example:
IV("mytable", "name", ("John",),mydb)


IVM (Insert Multiple Values):
This function inserts multiple rows of values into a table.
Example:
IVM("mytable", "name", [("John",), ("Alice",), ("Bob",)],mydb)


SA (Select All):
This function selects all rows from a table and prints them.
Example:
SA("mytable", mydb)


DB (Drop Database):
This function drops a database.
Example:
DB("mydatabase", mydb)


DT (Drop Table):
This function drops a table.
Example:
DT("mytable", mydb)


STBC (Select Text By Column):
This function selects a specific column from a table and prints its contents.
Example:
STBC("name", "mytable", mydb)


STBW (Select Text By Where):
This function selects all columns from a table based on a given condition and prints the results.
Example:
STBW("mytable", "age > 18", mydb)


STBWL (Select Text By Where Like):
This function selects all columns from a table based on a LIKE condition and prints the results.
Example:
STBWL("mytable", "name", "J%", mydb)


UTBW (Update Text By Where):
This function updates values in a table based on a given condition.
Example:
UTBW("mytable", "name='Jane'", "id=1", mydb)


STBR (Select Text By Row):
This function selects all columns from a table based on a given condition and prints the results row by row.
Example:
STBR("mytable", mydb)


STBO (Select Text By Order):
This function selects all columns from a table and orders the results by a specified field.
Example:
STBO("mytable", "name", mydb)


STBOAD (Select Text By Order And Direction):
This function selects all columns from a table, orders the results by a specified field, and specifies the order direction (ascending or descending).
Example:
STBOAD("mytable", "age", "DESC", mydb)


MCDT (Modify Column Data Type):
This function modifies the data type of a column in a table.
Example:
MCDT("mytable", "age", "INT", mydb)


MCP (Modify Column Position):
This function modifies the position of a column in a table.
Example:
MCP("mytable", "name", "age", mydb)


ATBF (Add Table Field):
This function adds a new column to a table.
Example:
ATBF("mytable", "email", "VARCHAR(255)", mydb)