You're creating a table called content. The Primary Key is called catid which can be an integer of up to 10 characters. There is no 0 for the primary ID. That's about where I get off....I've never seen so many KEYs in a MYSQL statement...
Please refer to www.mysql.com Their documentation is pretty good... Julia Computer Consulting Web Design @ Reasonable Prices PO Box 279 Watertown MA 02471-0279 Email: [EMAIL PROTECTED] http://www.juliagreen.com Phone: 617-926-3413 Fax: 617-812-5935 ----- Original Message ----- From: "Michael Lugassy" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, October 03, 2001 1:55 PM Subject: Can anyone "Translate" this? > I have a mySQL CREATE script that I want to run on MS-SQL 2000. > Can anyone let me know how to "translate" this? > > CREATE TABLE content ( > catid mediumint(10) unsigned NOT NULL default '0', > link text, > link1 text, > link_count smallint(5) unsigned default NULL, > link_total int(6) unsigned default NULL, > symlinkfarm enum('Y','N') NOT NULL default 'N', > PRIMARY KEY (catid), > KEY link_total (link_total), > KEY symlinkfarm (symlinkfarm), > KEY link_count (link_count) > ) TYPE=MyISAM; > > Michael. > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
