Scribd
Upload
56 views1 page

My SQL Coding

The document creates a database called aydb and uses it. It then creates a table called aytable within that database with a column for usernames up to 12 characters long. It inserts two usernames, 'aaa' and 'bbb' into the table. It then runs a select statement to retrieve data from a table called jasontable.

Uploaded by

jason_cheong_6
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
56 views1 page

My SQL Coding

The document creates a database called aydb and uses it. It then creates a table called aytable within that database with a column for usernames up to 12 characters long. It inserts two usernames, 'aaa' and 'bbb' into the table. It then runs a select statement to retrieve data from a table called jasontable.

Uploaded by

jason_cheong_6
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
You are on page 1/ 1

create database aydb;

use aydb;
create table aytable (username varchar(12));
insert into aytable values ('aaa');
insert into aytable values ('bbb');
...
select * fromjasontable;

You might also like