mysql-insert.sql

#mysql load script

# Copyright 2016 Amazon.com, Inc. or its affiliates.
# All Rights Reserved.
#
# Licensed under the Apache License, Version 2.0 (the "License").
# You may not use this file except in compliance with the License.
# A copy of the License is located at
#
#    http://aws.amazon.com/apache2.0/
#
# or in the "license" file accompanying this file.
# This file is distributed on an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND,
# either express or implied. See the License for the specific language governing permissions
# and limitations under the License.


#create schema and table
        CREATE SCHEMA amzn ;
        CREATE TABLE amzn.serverless_test
        (hello VARCHAR(6), world VARCHAR (6));

#insert
        INSERT INTO amzn.serverless_test (hello, world)
        VALUES('hello1', 'world1');
        INSERT INTO amzn.serverless_test (hello, world)
        VALUES('hello2', 'world2');
        COMMIT;

# verify
        SELECT *
        FROM amzn.serverless_test
        LIMIT 2;