forked from AlaSQL/alasql
-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathindex.html
80 lines (55 loc) · 2.69 KB
/
index.html
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>AlaSQL - JavaScript SQL database console</title>
<link rel="stylesheet" href="style.css" type="text/css">
<script src="xlsx.core.min.js"></script>
<script src='alasql.min.js'></script>
</head>
<body>
<h1>AlaSQL - JavaScript SQL database console</h1>
<p>This is a demo console for AlaSQL javascript database. Read more information and documentation on
<a href="https://github.com/agershun/alasql">https://github.com/agershun/alasql</a></p>
<p>Enter <b>SOURCE 'world.sql'</b> to load sample database, then <b>SHOW TABLES</b>, and then <b>SELECT TOP 10 * FROM City</b>. Then enter <b>SELECT VALUE COUNT(*) FROM TXT('world.sql') WHERE LEN([0])>20</b> to count number of lines with length more than 20 characters</p>
<div id='myconsole'></div>
<p>
<tt><span id="useid">alasql</span> ></tt> <input id='myprompt' autofocus/>
</p>
<p><center><button onClick="showHelp()">Show list of commands</button></center></p>
<script>
var first = decodeURI(location.search.substr(1));
alasql.options.logtarget = 'myconsole';
alasql.prompt('myprompt','useid');
alasql.prompt('myprompt','useid', first);
function showHelp(){
alasql.log([
{command:'ALTER TABLE table RENAME TO table'},
{command:'ALTER TABLE table ADD COLUMN column coldef'},
{command:'ALTER TABLE table MODIFY COLUMN column coldef'},
{command:'ALTER TABLE table RENAME COLUMN column TO column'},
{command:'ALTER TABLE table DROP column'},
{command:'ATTACH engine DATABASE database'},
{command:'ASSERT value'},
{command:'CREATE [engine] DATABASE [IF NOT EXISTS] database'},
{command:'CREATE TABLE [IF NOT EXISTS] table (column definitions)'},
{command:'DELETE FROM table [WHERE expression]'},
{command:'DETACH DATABASE database'},
{command:'DROP [engine] DATABASE [IF EXISTS] database'},
{command:'DROP TABLE [IF EXISTS] table'},
{command:'INSERT INTO table VALUES value,...'},
{command:'INSERT INTO table DEFAULT VALUES'},
{command:'INSERT INTO table SELECT select'},
{command:'SELECT [modificator] columns [INTO table] [FROM table,...] [[mode] JOIN [ON] [USING]] [WHERE ] [GROUP BY] [HAVING] [ORDER BY] '},
{command:'SET option value'},
{command:'SHOW [engine] DATABASES'},
{command:'SHOW TABLES'},
{command:'SHOW CREATE TABLE table'},
{command:'UPDATE table SET column1 = expression1, ... [WHERE expression]'},
{command:'USE [DATABASE] database'},
{command:'See <a href="http://github/agershun/alasql">http://github/agershun/alasql</a> for more information'}
])
}
</script>
</body>
</html>