SQL Fail - How do i solve it?

Results 1 to 2 of 2
  1. #1
    Member Sunny Anton is offline
    MemberRank
    Mar 2014 Join Date
    68Posts

    SQL Fail - How do i solve it?

    Hi! I've got a problem with my CMS sql.

    Picture: https://gyazo.com/1c1baa032cb4758a121f2c6355460700

    SQL query:

    alter table users add designer enum('1','0') DEFAULT '0'
    MySQL said:
    #1060 - Duplicate column name 'designer'

    How do i solve this? ^^


  2. #2
    Valued Member MedinaJoshua is offline
    MemberRank
    Oct 2009 Join Date
    inetpub/wwwrootLocation
    114Posts

    Re: SQL Fail - How do i solve it?

    You already have that designer column on users
    Can you provide a screenshot of your users table?



Advertisement