1. Read
  2. Vote
  3. Old
  4. New
  5. Hot
  6. Reply

Home / SIDU


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
Cat: SIDU | Read: 18582 | Msg: 1 | 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 | sq
Cat: SIDU | Read: 67489 | 2018-11-05  1
Tag: CMS, Wiki

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
Cat: SIDU | Read: 12680 | 2018-11-02
Tag: Test

SIDU feature request and bug



This topic is a place to collect feedback for SIDU bugs and feature requests.
Cat: SIDU | Read: 15971 | Msg: 4 | 2018-10-28  2
Tag: SIDU, Bug, Feature

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: 61111 | 2013-01-11

  1. 1
  2. 2
  3. 3

Category