03-16-2012
Without a lot of work on your part, you cannot.
SQLite is a library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine. SQLite date files typically have a .sqlite suffix. See
SQLite Home Page for more information.
There are a couple of SQLite addons available for the Firefox browser which you can install if you wish to explore or modify the Firefox SQLite data files.
8 More Discussions You Might Find Interesting
1. Windows & DOS: Issues & Discussions
Hi guys i'm new in windows 2000 server so please bear with me.
My quiestion is how can you remove all the icons and even the start menu using terminal services.
I have a windows xp machine that is part of a domain i installed terminal services.
I can login no problem but i want to be able to... (2 Replies)
Discussion started by: josramon
2 Replies
2. Linux
DOES ROOT USER HAS A PROFILE?
JUST LIKE .PROFILE FOR EVERY USER?
i UNDERSTAND AS A SECURITY REASON THAT IS GENERALLY NOT AVAILABLE?
DOES ANYBODY KNOW HOW IT IS A SECURITY THREAT?
IF WE DONT HAVE A .PROFILE FILE, THEN WHENVER WE EXPORT A VARIABLE OR DO SIMILAR STUFF, IN WHICH FILE IS THAT... (2 Replies)
Discussion started by: chakri.penguin
2 Replies
3. UNIX for Dummies Questions & Answers
Hello,
Actually I donno anything regarding profiles in Linux. Can anyone tell me what are Profiles in Linux and if possible copy links regarding so.
Thanks in advance. (0 Replies)
Discussion started by: ashok.g
0 Replies
4. UNIX for Dummies Questions & Answers
Is there a relatively simple step by step to find what has been deleted? Am aware of how to do it in Windows. Forgive my ignorance am new to Linux.. (1 Reply)
Discussion started by: Capricious11
1 Replies
5. UNIX for Advanced & Expert Users
Hi all,
My need is :
1. To know who , when , which command used.
2. Local user should not delete this information.
I mean , with an example , i can say
i have a user user1
i need to give all the following permissions to user1, :
a. A specific directory other than his home... (3 Replies)
Discussion started by: linuxadmin
3 Replies
6. UNIX and Linux Applications
Can anyone explain why Firefox 10 keeps losing history older than 2 months? (1 Reply)
Discussion started by: cokedude
1 Replies
7. UNIX for Dummies Questions & Answers
Hi all,
My need is :
1. To know who , when , which command used.
2. Local user should not delete this information.
I mean , with an example , i can say
i have a user user1
i need to give all the following permissions to user1, :
a. A specific directory other than his home... (1 Reply)
Discussion started by: sriky86
1 Replies
8. AIX
Hi
I have a doubt. Imagine an aix lpar named "sitsapfs" having 2 different profiles. If in case if it goes down suddenly how we will come to know under which profile
it has been running before going down ? (3 Replies)
Discussion started by: newtoaixos
3 Replies
LEARN ABOUT DEBIAN
sql::translator::parser::sqlite
SQL::Translator::Parser::SQLite(3pm) User Contributed Perl Documentation SQL::Translator::Parser::SQLite(3pm)
NAME
SQL::Translator::Parser::SQLite - parser for SQLite
SYNOPSIS
use SQL::Translator;
use SQL::Translator::Parser::SQLite;
my $translator = SQL::Translator->new;
$translator->parser("SQL::Translator::Parser::SQLite");
DESCRIPTION
This is a grammar for parsing CREATE statements for SQLite as described here:
http://www.sqlite.org/lang.html
CREATE INDEX
sql-statement ::=
CREATE [TEMP | TEMPORARY] [UNIQUE] INDEX index-name
ON [database-name .] table-name ( column-name [, column-name]* )
[ ON CONFLICT conflict-algorithm ]
column-name ::=
name [ ASC | DESC ]
CREATE TABLE
sql-command ::=
CREATE [TEMP | TEMPORARY] TABLE table-name (
column-def [, column-def]*
[, constraint]*
)
sql-command ::=
CREATE [TEMP | TEMPORARY] TABLE table-name AS select-statement
column-def ::=
name [type] [[CONSTRAINT name] column-constraint]*
type ::=
typename |
typename ( number ) |
typename ( number , number )
column-constraint ::=
NOT NULL [ conflict-clause ] |
PRIMARY KEY [sort-order] [ conflict-clause ] |
UNIQUE [ conflict-clause ] |
CHECK ( expr ) [ conflict-clause ] |
DEFAULT value
constraint ::=
PRIMARY KEY ( name [, name]* ) [ conflict-clause ]|
UNIQUE ( name [, name]* ) [ conflict-clause ] |
CHECK ( expr ) [ conflict-clause ]
conflict-clause ::=
ON CONFLICT conflict-algorithm
CREATE TRIGGER
sql-statement ::=
CREATE [TEMP | TEMPORARY] TRIGGER trigger-name [ BEFORE | AFTER ]
database-event ON [database-name .] table-name
trigger-action
sql-statement ::=
CREATE [TEMP | TEMPORARY] TRIGGER trigger-name INSTEAD OF
database-event ON [database-name .] view-name
trigger-action
database-event ::=
DELETE |
INSERT |
UPDATE |
UPDATE OF column-list
trigger-action ::=
[ FOR EACH ROW | FOR EACH STATEMENT ] [ WHEN expression ]
BEGIN
trigger-step ; [ trigger-step ; ]*
END
trigger-step ::=
update-statement | insert-statement |
delete-statement | select-statement
CREATE VIEW
sql-command ::=
CREATE [TEMP | TEMPORARY] VIEW view-name AS select-statement
ON CONFLICT clause
conflict-clause ::=
ON CONFLICT conflict-algorithm
conflict-algorithm ::=
ROLLBACK | ABORT | FAIL | IGNORE | REPLACE
expression
expr ::=
expr binary-op expr |
expr like-op expr |
unary-op expr |
( expr ) |
column-name |
table-name . column-name |
database-name . table-name . column-name |
literal-value |
function-name ( expr-list | * ) |
expr (+) |
expr ISNULL |
expr NOTNULL |
expr [NOT] BETWEEN expr AND expr |
expr [NOT] IN ( value-list ) |
expr [NOT] IN ( select-statement ) |
( select-statement ) |
CASE [expr] ( WHEN expr THEN expr )+ [ELSE expr] END
like-op::=
LIKE | GLOB | NOT LIKE | NOT GLOB
AUTHOR
Ken Youens-Clark <kclark@cpan.org>.
SEE ALSO
perl(1), Parse::RecDescent, SQL::Translator::Schema.
perl v5.14.2 2012-01-18 SQL::Translator::Parser::SQLite(3pm)