MariaDB

SQL Statements

Select

This should get every value for every column and every row in the table 'tbl_name'.

select *
from tbl_name

This should get the value of the column 'field1' for every row in 'tbl_name' where the column 'id' equals 1. If 'id' is your primary key, zero or one record should be returned.

select field1
from tbl_name
where id = 1

This should get the value of the column 'field1' for every row in 'tbl_name' and order the results by the value of 'field1'.

select field1
from tbl_name
order by field1

Insert

This should create a new value row in 'tbl_name'.

INSERT INTO tbl_name (column1, column2, column3)
VALUES (value1, value2, value3);