0
Create db and a table
3 Answers
+ 2
I dont know whats the question but i could imagine that you want to know How to create db and table ??
Database:
CREATE DATABASE my_database;
Table (just a small one you have to adapt it for your needs):
CREATE TABLE example (
id INT,
data VARCHAR(100)
);
0
To create ina Database.
In Mysql.
1. after you are in phpMyAdmin.
2. Click on New or the "create database"
3.Colocas the name of your database and the overlapping (see the different types of overlapping by languages).
4. Click Create.
To create a table.
1. Select the database you created by clicking on the name.
2. Add the name that will have the table and the amount of column that you will use.
3. Set the fields according to your data base type.
4. ready.
0
SQL CREATE DATABASE Syntax
CREATE DATABASE dbname;
Eg:
CREATE DATABASE my_db;
SQL CREATE TABLE Syntax
CREATE TABLE table_name
(
column_name1 data_type(size),
column_name2 data_type(size),
column_name3 data_type(size),
....
);
Eg
CREATE TABLE Persons
(
PersonID int,
LastName varchar(255),
FirstName varchar(255),
Address varchar(255),
City varchar(255)
);