Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2008
    Posts
    55

    Unanswered: Creating DDL files

    thanks for ready and thanks for the suggestions.

    I have been using MySQL for a few years. My current project requires me to use MS SQL. I'm looking for a few pointer web links to learn about the differences in MySQL to SQL. I will also be using PHP so any PHP/SQL links are appreciated.

    My client requires me to give them a DDL file for their SQL Server team to integrate. Is a DDL the same as a .sql file? How can i create a DDL?

    Is there a way to make a SQL DDL have permission for create/edit/remove tables and that's about it?

    thanks

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    Do you mean differences between MySQL and SQL or MySQL and MS SQL server
    SQL is the ANSI standard, MySQL & SQL server are implementations of SQL.

    http://www.google.co.uk/search?sourc...e+Search&meta=

    DDL (data defintion language) is a subset of SQL, most people when referring to SQL actually mean DML (data manipulation language) both are subsets of SQL itself, or comprise SQL

    both generate valid SQL, except DML is manipulating data in tables (eg select, insert, delete), whereas DDL is manipulating the table structure (eg create, drop, alter)
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Mar 2008
    Posts
    55
    thanks @healdem

    I have been reading up at http://www.tomjewett.com/dbdesign/db...age=ddldml.php. Im finding good info similar to yours.

    More comments welcome.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •