CREATE TABLE Table1 (A varchar(7),B varchar(20),C varchar(20)); INSERT INTO Tab...
$(function(){ let len = 50; $('.demo').each(function(){ if($(this).html...
SELECT a1 AS 'Date',a2 AS 'Time',a3 AS '總發電量kWh',a4 AS '總發電時數', a5 as '當日發電量',RO...
Private Sub CommandButton1_Click() Dim U As Integer Set RngHead = Worksheets(&qu...
Sub Test() Dim u As Integer u = 0 For aq = 1 To 10 If Cells(aq, 1) > 1 Then...
CREATE TABLE A ( XYEAR INT, Q1 INT, Q2 INT, Q3 INT, Q4 INT); INSERT INTO A VAL...
CREATE TABLE A ( A1 NVARCHAR(10), -- 公司代號 A2 NVARCHAR(10)); -- 車號 INSERT INTO...
CREATE TABLE XX ( A int,B varchar(10)); INSERT INTO XX Values(10,'apple'), (10,...
$mysqli -> query ("INSERT INTO waterml (type,ml,durationtime) VALUES ('&...