SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Member MatrixBrains's Avatar
    Join Date
    Jan 2005
    Location
    myroom
    Posts
    1
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Question Create Table in mysql database from an asp.net page

    Hi,

    I need the code to create a table (say "contacts") in mysql database (named "test") with dsn "something.mysite.com"

    What i want to do is to create a table from an asp.net page.

    Any help is appreciated.

    I have search enough but could not find it. Every one explains how to do it on server ( mysql> ...) but no one knows / talks about how to do it from asp.net page.

    Regards,
    MB

  2. #2
    SitePoint Zealot CdeMky's Avatar
    Join Date
    Sep 2004
    Location
    United States
    Posts
    123
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by MatrixBrains
    Hi,

    I need the code to create a table (say "contacts") in mysql database (named "test") with dsn "something.mysite.com"

    What i want to do is to create a table from an asp.net page.

    Any help is appreciated.

    I have search enough but could not find it. Every one explains how to do it on server ( mysql> ...) but no one knows / talks about how to do it from asp.net page.

    Regards,
    MB
    You can just execute that sql script in a regular query. The "create table" sql statement is no different than any other sql query so long as you have the proper permissions to let the script do that and doesn't have to be executed from the command line mysql interface.


Bookmarks

Posting Permissions

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