Em Andamento

Convert a Simple T-SQL ''CREATE TABLE'' Syntax to MySQL Syntax

<strong><span class="kwd">CREATE</span> <span class="kwd">TABLE</span><span class="pln"> FavoriteList<br /></span><span class="pun">(</span><span class="pln"><br /> favoriteWantedID int </span><span class="kwd">IDENTITY</span> <span class="pun">(</span><span class="lit">50</span><span class="pun">,</span><span class="lit">4</span><span class="pun">)</span> <span class="kwd">PRIMARY</span> <span class="kwd">KEY</span><span class="pun">,</span><span class="pln"><br /> memberID int </span><span class="kwd">NOT</span> <span class="kwd">NULL</span> <span class="kwd">REFERENCES</span><span class="pln"> Member</span><span class="pun">(</span><span class="pln">memberID</span><span class="pun">),</span><span class="pln"><br /> wantedID int </span><span class="kwd">NOT</span> <span class="kwd">NULL</span> <span class="kwd">REFERENCES</span><span class="pln"> Wanted</span><span class="pun">(</span><span class="pln">wantedID</span><span class="pun">)</span> <span class="kwd">ON</span> <span class="kwd">DELETE</span> <span class="kwd">CASCADE</span><span class="pun">,</span><span class="pln"><br /> dateCreated datetime </span><span class="kwd">DEFAULT</span><span class="pln"> GetDate</span><span class="pun">()</span> <span class="kwd">NOT</span> <span class="kwd">NULL</span><span class="pun">,</span><span class="pln"><br /> </span><span class="kwd">UNIQUE</span> <span class="pun">(</span><span class="pln">memberID</span><span class="pun">,</span><span class="pln"> wantedID</span><span class="pun">)</span><span class="pln"><br /></span></strong><span class="pun"><strong>);<br /></strong><br /><span style="color: #c00000;"><strong>The above Syntax is written in T-SQL ... Please change it to MySQL, write it<br />clearly as i wrote it above.</strong></span><br /></span>

## Deliverables

## **Quick Edit ....

**

Habilidades: Arquitetura de software, Assistente virtual

Ver mais: virtual int, syntax, lit, br software, create member, datetime, mysql create table, mysql sql syntax, references convert, sql syntax, null software, mysql virtual table, simple sql software, simple software key, virtual wanted, simple sql, convert key, create primary key sql, create table mysql, convert references, write sql , sql wanted, create table, convert sql mysql, convert table

Acerca do Empregador:
( 15 comentários ) Canada

ID do Projeto: #3015482

Premiar a:

vw7889722vw

See private message.

$3 USD em 7 dias
(1 Comentário)
0.0

5 freelancers estão ofertando em média $4 para este trabalho

soft1serve

See private message.

$3.4 USD in 7 dias
(44 Comentários)
4.5
iqmax99

See private message.

$5.1 USD in 7 dias
(51 Comentários)
4.1
developer1986

See private message.

$5.1 USD in 7 dias
(18 Comentários)
2.9
TRUSTY786

See private message.

$5.1 USD in 7 dias
(3 Comentários)
0.0