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, t-sql in, t-sql;, syntax, lit, br software, create member, convert assistant, datetime, class convert, mysql create table, mysql sql syntax, references convert, sql syntax, sql virtual assistant, null software, virtual assistant sql, mysql virtual table, simple sql software, simple software key, virtual wanted, simple sql, convert key, create primary key sql, mysql class written

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 are bidding on average $4 for this job

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