aaaaaaaaaaaaah, it's been a while since my last post. And now, it's time for me to publish my new post
-jeng jeeeeeeeeng-
this time, i'll share about making a Database, and table in MySQL. -eehheeuum-
well, check-this-one-out (^o^)/
making a database in MySQL is reaaaaaly simple, you don't have to memorize the query, you just have to understand.
The Query is :
create database nameOfDatabase;
for example :
create mermaid;
if you want to see the database you've just made, type:
show databases;
remember use ' ; ' in the end of query ^^
before you make table, use database that you've just made. The Query is
use nameOfDatabase;
for example:
use mermaid;
that mean you use the database that you've just made to save the table.
now, making a table as simple as making a database. The Query is
create table nameOfTable (nameOfField_1 datatype1, nameOfField_2 datatype2);
for example:
create table fish(ID char (5), name char (20), sex char (6));
in the picture above, there is a query describe fish, this query means you describe the table of fish. On fish table, we can see, there's three field, with their own type.
well minna, for now that's all. Keep waiting for my next post, if there's something that you don't understand or whatever, feel free to comment. ciao
( ˘ з˘ )♬♪