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? 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. 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? 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. 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
Archived
This topic is now archived and is closed to further replies.