conversion postgresql to mysql

Bonjour,

je souhaite savoir quel l'équivalent mysql de cette requête postgresql

merci pour votre aide :ccool:

Code:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
CREATE TABLE facture
(
  id integer NOT NULL DEFAULT nextval('"Facture_id_seq"'::regclass),
  nom character varying(64),
  prenom character varying(64),
  nss character varying(64),
  adresse character varying(64),
  tel character varying(64),
  permis character varying(64),
  etat character varying(64),
  marque character varying(64),
  modele character varying(64),
  numero_meneralogique character varying(64),
  kilometrage character varying(64),
  prix character varying(64),
  statut character varying,
  CONSTRAINT "Facture_pkey" PRIMARY KEY (id)
)
WITH (OIDS=TRUE);
ALTER TABLE facture OWNER TO postgres;