Jump to content

Search the Community

Showing results for tags 'Semi-Solved'.



More search options

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


Forums

  • W3Schools
    • General
    • Suggestions
    • Critiques
  • HTML Forums
    • HTML/XHTML
    • CSS
  • Browser Scripting
    • JavaScript
    • VBScript
  • Server Scripting
    • Web Servers
    • Version Control
    • SQL
    • ASP
    • PHP
    • .NET
    • ColdFusion
    • Java/JSP/J2EE
    • CGI
  • XML Forums
    • XML
    • XSLT/XSL-FO
    • Schema
    • Web Services
  • Multimedia
    • Multimedia
    • FLASH

Find results in...

Find results that contain...


Date Created

  • Start

    End


Last Updated

  • Start

    End


Filter by number of...

Joined

  • Start

    End


Group


AIM


MSN


Website URL


ICQ


Yahoo


Jabber


Skype


Location


Interests


Languages

Found 1 result

  1. MrFish

    Running IF ELSE

    Semi-Solved I am trying to follow the MySQL site but I can't get this to work- IF EXISTS (SELECT * FROM information_table.COLUMNS WHERE TABLE_NAME='db_name' AND TABLE_NAME='communityCustomFeatures' AND COLUMN_NAME='ccf_id');BEGIN;ALTER TABLE `communityCustomFeatures` ADD `ccf_id` ) FIRST;ELSE;ALTER TABLE `communityCustomFeatures` MODIFY `ccf_id` ) FIRST;END IF; It turns up this error- ------------------ IF EXISTS ( SELECT * FROM information_table.COLUMNSWHERE TABLE_NAME = 'db_name'AND TABLE_NAME = 'communityCustomFeatures'AND COLUMN_NAME = 'ccf_id' ); MySQL said: #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IF EXISTS (SELECT * FROM information_table.COLUMNS WHERE TABLE_NAME='db_name' AN' at line 1 ------------------- I cannot figure out why.
×
×
  • Create New...