JJ2K Posted July 3, 2009 Share Posted July 3, 2009 Hi there just 2 basic questions about MySQL which have been bugging me. Sometimes I see people put ` ` around their table and column names inside their SQL statements, however others (how i've been taught) don't put anything around them. Is there an advantage to do it the other way? Secondly what effect does adding TYPE=MyISAM to the end of our table creation have, what does it mean? Quote Link to comment https://forums.phpfreaks.com/topic/164695-2-basic-mysql-questions-about-using-and-typemyisam/ Share on other sites More sharing options...
fenway Posted July 3, 2009 Share Posted July 3, 2009 Those backticks are to escape special characters (like spaces) in table names and fields. MyISAM is the non-transactional database engine -- as opposed to InnoDB. Effects are broad and significant. Quote Link to comment https://forums.phpfreaks.com/topic/164695-2-basic-mysql-questions-about-using-and-typemyisam/#findComment-868515 Share on other sites More sharing options...
JJ2K Posted July 3, 2009 Author Share Posted July 3, 2009 Thanks, So in general use myISAM, is innoDB set as the default if I do not specify a type in my create table query? Quote Link to comment https://forums.phpfreaks.com/topic/164695-2-basic-mysql-questions-about-using-and-typemyisam/#findComment-868524 Share on other sites More sharing options...
fenway Posted July 4, 2009 Share Posted July 4, 2009 MySQL v5 uses InnoDB as the default... 4.1 was using MyISAM. Quote Link to comment https://forums.phpfreaks.com/topic/164695-2-basic-mysql-questions-about-using-and-typemyisam/#findComment-868632 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.