wiki.server17.net

User Tools

Site Tools

Trace: • sql
myhelp:sql

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
myhelp:sql [2023/08/28 05:45] – [Get the lastest timestamp] ulrichmyhelp: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;
 +</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> </code>
  
Line 67: Line 79:
 <code>SELECT something FROM table  <code>SELECT something FROM table 
 WHERE time_stamp = (SELECT time_stamp FROM table ORDER BY time_stamp DESC NULLS LAST LIMIT 1);</code> WHERE time_stamp = (SELECT time_stamp FROM table ORDER BY time_stamp DESC NULLS LAST LIMIT 1);</code>
 +
 +===== Other usefull stuff =====
 +Switch off the pages from CLI(shell)
 +<code>sudo -u postgres psql -P pager=off -d database -c "SELECT something FROM table;"</code>
 +
 +
 +Copy a SELECT to a CSV from CLI(shell)
 +<code>
 +sudo -u postgres psql -d database -c "COPY (SELECT  something, other_stuff FROM table 
 +GROUP BY something) TO '/tmp/result.csv' WITH CSV HEADER;"
 +</code>
 +
 {{tag>[Good2Know]}} {{tag>[Good2Know]}}
myhelp/sql.1693201549.txt.gz · Last modified: by ulrich