Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
  1. Home
  2. Database & SysAdmin
  3. MySQL
  4. help me to remove this sql error

help me to remove this sql error

Scheduled Pinned Locked Moved MySQL
databasehelpmysql
5 Posts 3 Posters 18 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • N Offline
    N Offline
    noo dyab
    wrote on last edited by
    #1

    hello i use mysql to build my database and i use its GUI to build my ralationship diagrams i try to make a one to many ralationship using database diagram when i drag the PK in the (one) side of relation to drop it in the (Many) side i get that error Both sides of relation must have the same number of culumns and related to my database i cant make them equal in column number what shall i do..

    M 1 Reply Last reply
    0
    • N noo dyab

      hello i use mysql to build my database and i use its GUI to build my ralationship diagrams i try to make a one to many ralationship using database diagram when i drag the PK in the (one) side of relation to drop it in the (Many) side i get that error Both sides of relation must have the same number of culumns and related to my database i cant make them equal in column number what shall i do..

      M Offline
      M Offline
      Marc Firth
      wrote on last edited by
      #2

      which GUI? MySQL has no GUI AFAIK. There's the MySQL SHELL> but I would really call that a gui... PHPMyAdmin? Navicat?

      Portfolio | Web Design, Web Hosting & IT Support

      N 1 Reply Last reply
      0
      • M Marc Firth

        which GUI? MySQL has no GUI AFAIK. There's the MySQL SHELL> but I would really call that a gui... PHPMyAdmin? Navicat?

        Portfolio | Web Design, Web Hosting & IT Support

        N Offline
        N Offline
        noo dyab
        wrote on last edited by
        #3

        hi i mean Data Base Diagram in mysql and i use SQL server Management Express this error killing me because i cant understand it help me if you have any idea please :( :( :(

        M L 2 Replies Last reply
        0
        • N noo dyab

          hi i mean Data Base Diagram in mysql and i use SQL server Management Express this error killing me because i cant understand it help me if you have any idea please :( :( :(

          M Offline
          M Offline
          Marc Firth
          wrote on last edited by
          #4

          Sorry, I don't use SQL server Management Express - so I don't have a clue. Have you asked the guys who made it?

          Portfolio | Web Design, Web Hosting & IT Support
          "The big corporations are suddenly taking notice of the web, and their reactions have been slow. Even the computer industry failed to see the importance of the Internet, but that's not saying much. Let's face it, the computer industry failed to see that the century would end." (Douglas Adams)

          1 Reply Last reply
          0
          • N noo dyab

            hi i mean Data Base Diagram in mysql and i use SQL server Management Express this error killing me because i cant understand it help me if you have any idea please :( :( :(

            L Offline
            L Offline
            Lost User
            wrote on last edited by
            #5

            AFAIK, you cannot use SQL server Management Express to connect to MySQL. Are you using an SQL Server database ?

            1 Reply Last reply
            0
            Reply
            • Reply as topic
            Log in to reply
            • Oldest to Newest
            • Newest to Oldest
            • Most Votes


            • Login

            • Don't have an account? Register

            • Login or register to search.
            • First post
              Last post
            0
            • Categories
            • Recent
            • Tags
            • Popular
            • World
            • Users
            • Groups