sql-parser
sql-parser copied to clipboard
phpmyadmin
A validating SQL lexer and parser with a focus on MySQL dialect.
# Execute ```sql START TRANSACTION; SELECT * FROM mytable WHERE id = 88777 FOR UPDATE; ``` ``` # 1064 - Erreur de syntaxe près de 'LIMIT 0, 25' à la...
Docs: https://dev.mysql.com/doc/refman/8.0/en/delete.html#idm140219041342912 There are two possible forms of multiple-table delete statement (queries based on [this tutorial](http://www.mysqltutorial.org/mysql-delete-join/)): - `DELETE t1, t2 FROM t1 INNER JOIN t2 ON t2.ref = t1.id WHERE...
When building queries, the LIMIT is re-formatted. For example `SELECT * FROM tbl LIMIT 1` is changed to `SELECT * FROM tbl LIMIT 0, 1`. This works just fine for...
Having the AS keyword in the select expression is option, following both should work: ```mysql SELECT 1 AS name; SELECT 1 name; ``` But the shorter variant fails: ```console $...
Suddenly when trying to use phpmyadmin, I am receiving the error below. Interestingly, I was in a debugging session debugging some php code. I went to use phpmyadmin and in...
```sql SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'Custom error'; ```
Hi, the following statement: ```sql ALTER TABLE `mail_template` CHANGE COLUMN `mtpl_group` `mtpl_group` ENUM('ORDER') NULL DEFAULT NULL ; ``` throws an exeception: "Missing comma before start of a new alter operation."....
```sql SELECT CONCAT('CHECKSUM TABLE ', GROUP_CONCAT(table_name), ';') AS statement FROM information_schema.tables WHERE table_schema = 'information_schema' INTO @command; ``` Gives a query syntax error because of `INTO @command` ### Error ```...
Aliases do not work after CASE expression: ``` $ ./bin/lint-query --query 'select 1 name' #1: Unrecognized keyword. (near "name" at position 9) $ ./bin/lint-query --query 'select case when 1 >...
### Data Definition Statements - [x] ALTER - [ ] CREATE - [x] DATABASE - [x] EVENT - [x] FUNCTION - [ ] INDEX - [x] PROCEDURE - [ ]...
Metadata
Owner
Metadata
A validating SQL lexer and parser with a focus on MySQL dialect.