JOB.SH┃CMCC┃TTINN┃CNIAPP┃吕进博客

select a.username,substring_index(substring_index(a.tags,',',b.help_topic_id+1),',',-1) tag
from USER_TAG a join
mysql.help_topic b
on b.help_topic_id < (length(a.tags) - length(replace(a.tags,',',''))+1)
order by username;

Sub byw()
Dim arr, arr1
Dim i%, j%, s%
arr = Sheet6.Range("A1:K" & [A65536].End(3).Row) '第一行为标题行'
ReDim arr1(1 To UBound(arr), 1 To 11)
s = 1
For i = 2 To UBound(arr)  '数据区域从第二行开始'
    If arr(i, 10) = "是" Then
       For j = 1 To 11
         'arr1(s, j) = arr(i, j) '如果不改变数组的排列
         arr1(s, 1) = s '我给加的一个序号
         arr1(s, 2) = arr(i, 5)
         arr1(s, 3) = arr(i, 4)
         arr1(s, 4) = arr(i, 3)
         arr1(s, 5) = arr(i, 1)
         arr1(s, 6) = arr(i, 6)        
       Next
       s = s + 1
    End If
Next
Sheet1.Range("A4:AU100").ClearContents
Sheet1.[A4].Resize(s, 6) = arr1
End Sub

<?php
   class MyDB extends SQLite3
   {
      function __construct()
      {
         $this->open('sqlite3.db');
      }
   }
   $db = new MyDB();
   if(!$db){
      echo $db->lastErrorMsg();
   } else {
      echo "Opened database successfully\n";
   }

   $sql =<<<EOF
      CREATE TABLE COMPANY
      (userid INT PRIMARY KEY     NOT NULL,
      username           TEXT    NOT NULL,
      password           TEXT     NOT NULL);
EOF;

   $ret = $db->exec($sql);
   if(!$ret){
      echo $db->lastErrorMsg();
   } else {
      echo "Table created successfully\n";
   }
  
  
   $sql2 =<<<EOF
      INSERT INTO COMPANY (userid,username,password)
      VALUES (1, 'popy32', $(MD5("popy32")));
EOF;

$ret = $db->exec($sql2);
   if(!$ret){
      echo $db->lastErrorMsg();
   } else {
      echo "Insert data successfully\n";
   }  
   $db->close();
?>