ansible_services_hardening/mysql/files/create_table.sql

10 lines
423 B
SQL

CREATE TABLE IF NOT EXISTS test (
message varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
INSERT INTO test(message) VALUES('This is some message');
INSERT INTO test(message) VALUES('This is another message');
INSERT INTO test(message) VALUES('Ansible is fun');
INSERT INTO test(message) VALUES('a');
INSERT INTO test(message) VALUES('b');
INSERT INTO test(message) VALUES('c');