how to create database and table colmun in MYSQL database

0
1733

Overview

In this tutorial you will learn how to make simple database and make 1 table of this database
with 2 columns name as username and password.both column value will be like string or characters
that’s why i am using varchar you can also use “int” type if column values in from of digits.

database table SQL script snippet code :

--
-- Table structure for table `loginlogs`
--

CREATE TABLE IF NOT EXISTS `loginlogs` (
`username` varchar(255) NOT NULL,
`password` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

Summary

how to make simple mysql database and make one user table difference
between varchar and “int” data type of column.
This Tutorial is of phpmyadmin for Beginners.