Welcome to the Treehouse Community

Want to collaborate on code errors? Have bugs you need feedback on? Looking for an extra set of eyes on your latest project? Get support with fellow developers, designers, and programmers of all backgrounds and skill levels here with the Treehouse Community! While you're at it, check out some resources Treehouse students have shared here.

Looking to learn something new?

Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and join thousands of Treehouse students and alumni in the community today.

Start your free trial

Development Tools Database Foundations Manipulating Schema with SQL Altering Columns

ricardogutierrez
ricardogutierrez
11,349 Points
Posted by ricardogutierrez
ricardogutierrez
11,349 Points

Workbench 6: 'CHANGE' or 'CHANGED' keyword

Hi.

I was working in workbench and following the instructions of video 'Altering Columns' an found a keyword autocomple named 'CHANGED'.

Try to find the 'CHANGE' keyword in autocomple but is missing.

So my question is...

Is the keyword 'CHANGED' equivalent to 'CHANGE'? Is there a way to insert 'CHANGE' in my Workbench 6 autocomple?

Thanks a lot in advance. :D

2 Answers

James Kraai
James Kraai
26,167 Points
James Kraai
James Kraai
26,167 Points

I don't believe so, CHANGED is not in the MySQL 5.6 documentation while CHANGE is. When in doubt just try it and see what it does!

Here is the Documentation Link.

ricardogutierrez
ricardogutierrez
11,349 Points
ricardogutierrez
ricardogutierrez
11,349 Points

Hi James !

Thank you for the link. I didn't found anything about 'CHANGED' keyword either.

If I use it the response throws 'error'. So is strange that 'CHANGED' comes up instead of 'CHANGE' in Workbench autocomplete.

I thought there is a way to customize autocomplete in Workbech ... but I will keep googling it.

Bye.