Localhost SIDU ssh connect remote site localhost
The following line is a handy tip to allow SIDU from localhost to ssh connect remote site's localhost, when remote database is not allowed connection from a remote IP:
Open a terminal and input the following line:
# ssh -fCTMNS /tmp/sidu_tunnel -p 22 user@remote.ip -L 3307:localhost:3306
u
Open a terminal and input the following line:
# ssh -fCTMNS /tmp/sidu_tunnel -p 22 user@remote.ip -L 3307:localhost:3306
u
Cat: SIDU | Read: 52870 | 2019-01-01 11
Wiki: Topnew DB helper
Wiki: Topnew DB Helper v 2018.08.08
Topnew DB provides a full list of database functions for PHP PDO only. Generally there are 5 groups of functions:
A - General duties:
1. Database connection
$conn = [
'eng' => 'mysql', // pgsql | sqlite | m
Topnew DB provides a full list of database functions for PHP PDO only. Generally there are 5 groups of functions:
A - General duties:
1. Database connection
$conn = [
'eng' => 'mysql', // pgsql | sqlite | m
SQL row sum
Given an SQL table ID Amt -- --- 1 100 2 200 3 300 Please write a MySQL statement to produce the following result: ID Amt Total -- --- ----- 1 100 100 2 200 300 3 300 600 And here is an example SQL: SELECT a.ID, a.Amt, sum(b.Amt) AS Total FROM tab AS a JOIN tab AS b ON a.ID >= b.ID GROUP BY 1,2
SIDU feature request and bug
This topic is a place to collect feedback for SIDU bugs and feature requests.
SIDU import/export data clean
Topnew note: content lost:due to so many spam, delete bulk lost.please check old blog arc, possible has a copy there
Cat: SIDU | Read: 61638 | 2013-01-11
- 1
- 2
- 3