MySQL Forums
Forum List  »  Newbie

Re: Unsure of what the results of proposed table structure
Posted by: Peter Brawley
Date: February 22, 2021 09:23PM

> when I changed some fields from text to varchar,
> the proposed table structure was saying higher values
> than what the max length was

Again I've no clue what "proposed table structure" might mean. Proposed by what? For what purpose? Based on what?

> ZONE VALVES was the max value at 406

You're taking an aggregate max() of string values? Makes no sense.

You'll need to provide specific info, ie the result of Show Create Table for that table, and a few rows of sample data.

Options: ReplyQuote


Subject
Written By
Posted
Re: Unsure of what the results of proposed table structure
February 22, 2021 09:23PM


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.