Home > other >  i can't import database through phpmyadminfle
i can't import database through phpmyadminfle

Time:12-27

Database: catering

Struktur dari table : detail_pesanan

related DDL:

CREATE TABLE `detail_pesanan` 
(
  `id`         INT( 11 ) NOT NULL ,
  `produk_id`  INT( 11 ) NOT NULL ,
  `qty`        INT( 11 ) NOT NULL ,
  `pesanan_id` INT( 11 ) NOT NULL
) ENGINE = INNODB DEFAULT CHARSET = latin1;

MySQL said: Documentation

#1046 - No database selected

CodePudding user response:

USE catering;
CREATE TABLE `detail_pesanan` 
(
  `id`         INT( 11 ) NOT NULL ,
  `produk_id`  INT( 11 ) NOT NULL ,
  `qty`        INT( 11 ) NOT NULL ,
  `pesanan_id` INT( 11 ) NOT NULL
) ENGINE = INNODB DEFAULT CHARSET = latin1;

CodePudding user response:

create databse and then run this DDL inside SQL or import the .sql file

  • Related