5.0| MySQL | |
|---|---|
| URL format | jdbc:mysql://host:port/database |
| SSL support | Not tested |
| Maven Central coordinates | mysql:mysql-connector-java:8.0.12 |
| Supported versions | 5.0 and later |
| Default Java class | com.mysql.jdbc.Driver |
/* Single line comment */
CREATE TABLE test_data (
value VARCHAR(25) NOT NULL,
PRIMARY KEY(value)
);
/*
Multi-line
comment
*/
-- MySQL procedure
DELIMITER //
CREATE PROCEDURE AddData()
BEGIN
# MySQL-style single line comment
INSERT INTO test_data (value) VALUES ('Hello');
END //
DELIMITER;
CALL AddData();
-- Placeholder
INSERT INTO ${tableName} (name) VALUES ('Mr. T');