poreklo / vscode-mysql Goto Github PK

DROP PROCEDURE IF EXISTS moveMoney;

DELIMITER //

CREATE PROCEDURE moveMoney(
	fromaccount CHAR(4),
        toaccount CHAR(4),
        amount NUMERIC(4, 2)
)
BEGIN

	SELECT fromaccount, toaccount, amount;

END//

DELIMITER ;

This is my code, it works in the mysql client but it won't work in vscode with this extension.

The error I'm getting:

Error: ER_PARSE_ERROR: You have an error in your SQL syntax; 
  check the manual that corresponds to your MySQL 
  server version for the right syntax to use near '//

DELIMITER' at line 10

Can you please add the ability to see stored procedures and functions? When that is added, can you create a tree structure that groups tables, stored procedures and functions separately?

As this looks to be a bit more maintained than Jan's version I thought I would raise formulahendry#1 here as well.

A lot of MySQL databases are not exposed directly and you have to SSH setting up a port forward to gain access to them. This can be seen in tools like MySQL Workbench.

In the original issue I point at a library that looks to work well for SSH in other extensions.

"SELECT * FROM table1 JOIN table2 ON table1.id=table2.user_id"

• in Result page there are all fields except for the fields from the table1 named as the fields from table2. Unless I explicitly rename them with AS

when i insert to column set as date the CURRENT_DATE()
it is display as "2019-02-28T22:00:00.000Z"

INSERT INTO data (id, date, time, zone, type, value) VALUES ('asdf', CURRENT_DATE(), NOW(), 'asdf', 'asdf', 3)

It's better for there to be this.
https://code.visualstudio.com/updates/v1_23#_contributions-to-the-activity-bar

./model/tableNode.ts#49 add ` to database and table names;

const sql =SELECT * FROM `${this.database}`.`${this.table}` LIMIT 1000;;