Breaking News: Grepper is joining You.com. Read the official announcement!

mysql create table

Add Answer

Curious Capybara answered on December 18, 2019 Popularity 10/10 Helpfulness 3/10

answer mysql create table

related create table in mysql

related create table mysql

related mysql create table

related create table in mysql

related how to create a table in mysql

related Create Table in MySql

related mysql create table query

related create table in mysql

related create table mysql

mysql create table

Comment

Imaginons que l’ont souhaite créer une table utilisateur,
contenant "id","nom", "prenom", "email", "date_naiss", "pays" etc..
La requête pour créer cette table peut ressembler à ceci:

CREATE TABLE utilisateur
(
    id INT PRIMARY KEY NOT NULL,
    nom VARCHAR(100),
    prenom VARCHAR(100),
    email VARCHAR(255),
    date_naissance DATE,
    pays VARCHAR(255),
    ville VARCHAR(255),
    code_postal VARCHAR(5),
    nombre_achat INT
)

Voici des explications sur les colonnes créées :

    id : identifiant unique qui est utilisé comme clé primaire
		 et qui n’est pas nulle
    nom :une colonne de type VARCHAR avec un maximum de 100 caractères 
    prenom : idem mais pour le prénom
    email : adresse email enregistré sous 255 caractères au maximum
    date_naissance :  format AAAA-MM-JJ (exemple : 1973-11-17)
    pays : nom du pays  255 caractères au maximum
    ville : idem pour la ville
    code_postal : 5 caractères du code postal
    nombre_achat : nombre d’achat de cet utilisateur sur le site

Popularity 10/10 Helpfulness 3/10 Language sql

Source: Grepper

Tags: create-table mysql sql

Link to this answer
Share Copy Link

Contributed on Feb 11 2021

Curious Capybara

0 Answers Avg Quality 2/10

Closely Related Answers

create table in mysql

Comment

create table tutorials_tbl(
   tutorial_id INT NOT NULL AUTO_INCREMENT,
   tutorial_title VARCHAR(100) NOT NULL,
   tutorial_author VARCHAR(40) NOT NULL,
   submission_date DATE,
  student_name VARCHAR (255),
	sex varchar (6),
	contact int (10)
   PRIMARY KEY ( tutorial_id )
);

create table mysql query

Popularity 10/10 Helpfulness 8/10 Language javascript

Source: Grepper

Tags: create-table create-tab

Link to this answer
Share Copy Link

Contributed on Jan 06 2023

Akshit Singhal

0 Answers Avg Quality 2/10

create table mysql

Comment

CREATE TABLE IF NOT EXISTS tasks (
    task_id INT AUTO_INCREMENT PRIMARY KEY,
    title VARCHAR(255) NOT NULL,
    start_date DATE,
    due_date DATE,
    status TINYINT NOT NULL,
    priority TINYINT NOT NULL,
    description TEXT,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
)  ENGINE=INNODB;

Popularity 10/10 Helpfulness 6/10 Language sql

Source: Grepper

Tags: create-table create-tab

Link to this answer
Share Copy Link

Contributed on Dec 18 2019

Nathan Stanford

0 Answers Avg Quality 2/10

mysql create table

Comment

CREATE TABLE IN MYSQL

CREATE TABLE CARS (
CARID INT,
NAME VARCHAR(20),
OWNER VARCHAR(20),
SALESDATE DATE,
PRIMARY KEY (CARID)
);

Popularity 9/10 Helpfulness 6/10 Language sql

Source: Grepper

Tags: create-table create-tab

Link to this answer
Share Copy Link

Contributed on Mar 27 2024

raminismayilsoy

0 Answers Avg Quality 2/10

create table in mysql

Comment

# updated dec 2020
# Creates a Simple User table
# Uses an auto-incrementing primary key as userId 

CREATE TABLE user (
    userId INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
    username VARCHAR(100),
    password VARCHAR(100) 
) ENGINE=InnoDB;

Popularity 10/10 Helpfulness 5/10 Language sql

Source: Grepper

Tags: create-table create-tab

Link to this answer
Share Copy Link

Contributed on Dec 12 2020

Shubham Kunwar

0 Answers Avg Quality 2/10

how to create a table in mysql

Comment

-- 'CREATE TABLE' followed by the name of the table. 
-- In round brackets, define the columns.
CREATE TABLE `test_table` 
(
  id INT(10) PRIMARY KEY,			
  username VARCHAR(50) NOT NULL
);

Popularity 10/10 Helpfulness 5/10 Language sql

Source: Grepper

Tags: mysql mysq

Link to this answer
Share Copy Link

Contributed on Feb 18 2020

by miss american pie

0 Answers Avg Quality 2/10

Create Table in MySql

Comment

CREATE TABLE users(
id INT AUTO_INCREMENT,
   first_name VARCHAR(100),
   last_name VARCHAR(100),
   email VARCHAR(50),
   password VARCHAR(20),
   location VARCHAR(100),
   dept VARCHAR(100),
   is_admin TINYINT(1),
   register_date DATETIME,
   PRIMARY KEY(id)
);

Popularity 10/10 Helpfulness 5/10 Language sql

Source: gist.github.com

Tags: create-table create-tab

Link to this answer
Share Copy Link

Contributed on May 18 2022

Gaurav Gupta

0 Answers Avg Quality 2/10

mysql create table query

Comment

CREATE TABLE student (
student_id int PRIMARY KEY,
student_name VARCHAR (255),
level int (10),
sex varchar (6),
contact int (10) );

Popularity 10/10 Helpfulness 5/10 Language sql

Source: Grepper

Tags: create-table create-tab

Link to this answer
Share Copy Link

Contributed on Sep 04 2022

YouTube Nepal

0 Answers Avg Quality 2/10

create table in mysql

Comment

CREATE TABLE IF NOT EXISTS `user_profiles` (
  `id` int(11) NOT NULL,
  `loginid` varchar(10) NOT NULL,
  `fullname` varchar(255) NOT NULL,
  `phone` varchar(15) NOT NULL,
  `email` varchar(50) NOT NULL,
  `res_data` text NOT NULL,
  `date_on` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

Popularity 9/10 Helpfulness 4/10 Language sql

Source: Grepper

Tags: create-table create-tab

Link to this answer
Share Copy Link

Contributed on Apr 09 2023

@CodeGrepperManu

0 Answers Avg Quality 2/10

create table mysql

Comment

create table tutorials_tbl(
   tutorial_id INT NOT NULL AUTO_INCREMENT,
   tutorial_title VARCHAR(100) NOT NULL,
   tutorial_author VARCHAR(40) NOT NULL,
   submission_date DATE,
   PRIMARY KEY ( tutorial_id )
);

Popularity 10/10 Helpfulness 4/10 Language sql

Source: Grepper

Tags: create-table create-tab

Link to this answer
Share Copy Link

Contributed on Apr 29 2021

Cautious Caribou

0 Answers Avg Quality 2/10

create table mysql

Comment

CREATE TABLE IF NOT EXISTS `sys_user_details` (
    user_detail_id INT(11) AUTO_INCREMENT,
    user_id INT(11),
    name VARCHAR(100) NOT NULL,
    email VARCHAR(200) NOT NULL,
    education VARCHAR(100) DEFAULT NULL,
    skills VARCHAR(100) DEFAULT NULL,
    experience VARCHAR(100) DEFAULT NULL,
    CONSTRAINT PK_sys_user_details PRIMARY KEY (user_detail_id),
    CONSTRAINT FK_sys_user_details_user_id FOREIGN KEY (user_id)
    REFERENCES sys_user(user_id)
        ON UPDATE RESTRICT ON DELETE CASCADE
);

Popularity 10/10 Helpfulness 4/10 Language sql

Source: Grepper

Tags: create-table create-tab

Link to this answer
Share Copy Link

Contributed on Jun 18 2021

Successful Swiftlet

0 Answers Avg Quality 2/10

mysql create table

Contents

More Related Answers

mysql create table

Closely Related Answers

create table in mysql

create table mysql

mysql create table

create table in mysql

how to create a table in mysql

Create Table in MySql

mysql create table query

create table in mysql

create table mysql

create table mysql

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.