myhelp:sql
Differences
This shows you the differences between two versions of the page.
| Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
| myhelp:sql [2023/09/13 09:09] – [Other usefull stuff] ulrich | myhelp:sql [2024/10/05 07:51] (current) – [mySQL / MariaDB] ulrich | ||
|---|---|---|---|
| Line 11: | Line 11: | ||
| sqlite> UPDATE T_names SET birthyear=1997 WHERE name = 'Jack Doe'; | sqlite> UPDATE T_names SET birthyear=1997 WHERE name = 'Jack Doe'; | ||
| sqlite> SELECT * FROM T_names LIMIT 1; | sqlite> SELECT * FROM T_names LIMIT 1; | ||
| + | </ | ||
| + | |||
| + | ====== mySQL / MariaDB ====== | ||
| + | < | ||
| + | CREATE DATABASE IF NOT EXISTS meineDB; | ||
| + | CREATE USER ' | ||
| + | GRANT ALL PRIVILEGES ON meineDB . * TO ' | ||
| + | </ | ||
| + | |||
| + | Grant Access from remote IP (10.11.12.13) | ||
| + | < | ||
| + | GRANT ALL ON meineDB.* to ' | ||
| </ | </ | ||
myhelp/sql.1694596169.txt.gz · Last modified: by ulrich