Convert a Simple T-SQL ''CREATE TABLE'' Syntax to MySQL Syntax
$1-6 USD
$1-6 USD
Paid on delivery
<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 ....
**
Project ID: 3015482
About the project
5 proposals
Remote project
Active 13 yrs ago
Looking to make some money?
Benefits of bidding on Freelancer
Set your budget and timeframe
It's free to sign up and bid on jobs
5 freelancers are bidding on average $4 USD for this job
$3.40 USD in 7 days
5.0 (44 reviews) $5.10 USD in 7 days
5.0 (51 reviews) $5.10 USD in 7 days
4.5 (18 reviews) $5.10 USD in 7 days
0.0 (3 reviews)