Differences

This shows you the differences between two versions of the page.

--- myhelp:sql [2023/09/13 09:06] – [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> SELECT * FROM T_names LIMIT 1;
+</code>
+====== mySQL / MariaDB ======
+<code>
+CREATE DATABASE IF NOT EXISTS meineDB;
+CREATE USER 'benutzer'@'localhost' IDENTIFIED BY 'passwort';
+GRANT ALL PRIVILEGES ON meineDB . * TO 'benutzer'@'localhost';
+</code>
+Grant Access from remote IP (10.11.12.13)
+<code>
+GRANT ALL ON meineDB.* to 'benutzer'@'10.11.12.13' IDENTIFIED BY 'passwort' WITH GRANT OPTION;
 </code>
@@ Line 74: / Line 86: @@
 Copy a SELECT to a CSV from CLI(shell)
-ata0266262@atsl-pqsqlp01 ~]$ sudo -u postgres psql -d storage -c "COPY (SELECT  t_volume.servicename, t_volume.serviceid, SUM(t_data.vol_size) AS "SIZE", SUM(t_data.used) AS "USED", (SUM(t_data.vol_size) - SUM(t_data.used)) AS "Delta"
+<code>
-FROM t_data JOIN t_volume ON t_volume.uuid = t_data.uuid JOIN t_vserver ON t_vserver.vserver_name = t_volume.vserver_name
+sudo -u postgres psql -d database -c "COPY (SELECT  something, other_stuff FROM table
-WHERE time_stamp = (SELECT MAX(time_stamp) FROM t_data)
+GROUP BY something) TO '/tmp/result.csv' WITH CSV HEADER;"
-  AND serviceid != '0'
+</code>
-  AND is_clone = false
-GROUP BY t_volume.servicename, t_volume.serviceid) TO '/tmp/zahlen.csv' WITH CSV HEADER;"
+{{tag>[Good2Know]}}