MySQL Forums
Forum List  »  Views

Re: CREATE VIEW with ENUM columns
Posted by: David Jansen
Date: December 26, 2010 02:06AM

Yes I tried, but it turns out that I am not able to build a simple CRUD interface directly in MySQL.
If this is at all possible, it is beyond my current level of experience.
SELECT
		html_text_field_texts.htmlTextId AS htmlTextId
	,	page_types.pageTypeName AS pageTypeName ENUM('a','b','c')
	,	pages.pageName AS pageName ENUM('d','e','f')
	,	locales.locale AS locale ENUM('g','h','i')
	,	html_text_field_names.htmlTextFieldName AS htmlTextFieldName ENUM('j','k','l')
	,	html_text_field_texts.htmlText AS htmlText

FROM
	html_text_field_texts
	INNER JOIN
		page_types
	ON
		page_types.pageTypeId = html_text_field_texts.pageTypeId

	INNER JOIN
		pages
	ON
		pages.pageId = html_text_field_texts.pageId

	INNER JOIN
		locales
	ON
		locales.localeId = html_text_field_texts.localeId

	INNER JOIN
		html_text_field_names
	ON
		html_text_field_names.htmlTextFieldId = html_text_field_texts.htmlTextFieldId

WHERE
	locales.enabled = '1'
would probably not work and even if it did, I still have to insert the IDs for the text fields into a new record.

Options: ReplyQuote


Subject
Views
Written By
Posted
3360
December 25, 2010 12:21PM
1628
December 25, 2010 11:38PM
Re: CREATE VIEW with ENUM columns
2531
December 26, 2010 02:06AM
1876
January 02, 2011 11:14PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.