Answers for "create db in mysql"

SQL

create database mysql

CREATE DATABASE `mydb`;

CREATE TABLE `my_table`
(
	my_table_id INT AUTO_INCREMENT,
    my_table_name VARCHAR(30) NOT NULL,
    my_foreign_key INT NOT NULL,
    my_tb_created TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
  	my_tb_updated TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, ,
    # Any other properties here
    PRIMARY KEY(my_table_id),
    CONSTRAINT fk_name_of_parent_table
    FOREIGN KEY(my_foreign_key) REFERENCES parent_table(parent_table_column)
);

SHOW DATABASES;

Posted by: Guest on February-08-2020

create database in mySQL

CREATE DATABASE nameOfYourDatabase;
USE nameOfYourDatabase;
CREATE TABLE nameOfTable(
id INT AUTO_INCREMENT,
   first_name VARCHAR(100),
   last_name VARCHAR(100),
   email VARCHAR(50),
   password VARCHAR(20),
   PRIMARY KEY(id)
);

Posted by: Guest on October-27-2021

create mysql database

mysql -u username -p
CREATE DATABASE dbname;

Posted by: Guest on August-08-2021

create a db

#TO Create a DB :
CREATE DATABASE <DB_NAME>;
#example : CREATE DATABASE MyDataBase ;
#To Create a Table :
CREATE TABLE <TB_NAME>(
    <Elem 0> <Type_of_Elem created> <ADD_PROPRETIES>, #Don't forget the comma
  	...
  	...
  	...
    <Elem n> <Type_of_Elem created> #last elems don't need a comma 
);
/*example :
CREATE TABLE city (
    id int  NOT NULL IDENTITY(1, 1),
    city_name char(128)  NOT NULL,
    lat decimal(9,6)  NOT NULL,
    long decimal(9,6)  NOT NULL,
    country_id int  NOT NULL,
    CONSTRAINT city_pk PRIMARY KEY  (id)
);
*/

Posted by: Guest on December-25-2020

MySQL CREATE DATABASE

MySQL implements a database as a directory that contains all files which correspond to tables in the database.

To create a new database in MySQL, you use the CREATE DATABASE statement with the following syntax:

CREATE DATABASE [IF NOT EXISTS] database_name
[CHARACTER SET charset_name]
[COLLATE collation_name]

Posted by: Guest on October-19-2020

Source

mysql create database

CREATE {DATABASE | SCHEMA} [IF NOT EXISTS] db_name
    [create_option] ...

create_option: {
    [DEFAULT] CHARACTER SET [=] charset_name
  | [DEFAULT] COLLATE [=] collation_name
}

Posted by: Guest on July-16-2020

Code answers related to "create db in mysql"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Python

Javascript

Whatever

Shell/Bash

CSS

Html

PHP

SQL

Java

Answers for "create db in mysql"

Code answers related to "create db in mysql"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us