Create db and a table | Sololearn: Learn to code for FREE!
New course! Every coder should learn Generative AI!
Try a free lesson
0

Create db and a table

8th Feb 2017, 1:29 PM
Amjad CP
Amjad CP - avatar
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) );
8th Feb 2017, 1:33 PM
R4xx4r
R4xx4r - avatar
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.
8th Feb 2017, 8:20 PM
Jose Angel Garcia
Jose Angel Garcia - avatar
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) );
9th Feb 2017, 9:32 AM
Akwin Lopez
Akwin Lopez - avatar