Tycoon Talk
Become a Big fish!
The number 1 forum for online business!
Post topics, ask questions, share your knowledge.
Tycoon Talk is part of Freelancer.com - find skilled workers online at a fraction of the cost.

Coding Forum


You are currently viewing our Coding Forum as a guest. Please register to participate.
Login


Tycoon Talk > Web Development and Programming Support > Coding Forum > Mixing MyISAM and Innodb

Reply
Mixing MyISAM and Innodb
Old 08-14-2008, 09:14 PM Mixing MyISAM and Innodb
UCDaZ's Avatar
Skilled Talker

Posts: 80
Name: Nick Leung
Location: Silicon Valley
Trades: 0
Talkupation: UCDaZ is on a distinguished road
Is it ok to have one table in myisam and one table in innodb?
I want to convert my Post table into myisam and keep the rest of my other tables as innodb.

Thanks!
UCDaZ is offline
Reply With Quote
View Public Profile Visit UCDaZ's homepage!
 
 
Register now for full access!
Old 08-15-2008, 11:48 AM Re: Mixing MyISAM and Innodb
VirtuosiMedia's Avatar
Web Design Made Simple

Latest Blog Post:
2009 In Review And Our Goals For 2010
Posts: 1,228
Trades: 0
Talkupation: VirtuosiMedia has a brilliant futureVirtuosiMedia has a brilliant futureVirtuosiMedia has a brilliant futureVirtuosiMedia has a brilliant futureVirtuosiMedia has a brilliant futureVirtuosiMedia has a brilliant futureVirtuosiMedia has a brilliant futureVirtuosiMedia has a brilliant futureVirtuosiMedia has a brilliant futureVirtuosiMedia has a brilliant futureVirtuosiMedia has a brilliant future
As far as I know, there aren't any side effects. You can have a mix of the two in the same database.
__________________
Want new web resources every day? - Follow me on
Please login or register to view this content. Registration is FREE


Please login or register to view this content. Registration is FREE


Please login or register to view this content. Registration is FREE
|
Please login or register to view this content. Registration is FREE
VirtuosiMedia is offline
Reply With Quote
View Public Profile Visit VirtuosiMedia's homepage!
 
Old 08-15-2008, 05:04 PM Re: Mixing MyISAM and Innodb
UCDaZ's Avatar
Skilled Talker

Posts: 80
Name: Nick Leung
Location: Silicon Valley
Trades: 0
Talkupation: UCDaZ is on a distinguished road
Awesome! Thanks! I wanted to use the Fulltext search in MyISAM and foreign key constraints in Innodb for some tables.
UCDaZ is offline
Reply With Quote
View Public Profile Visit UCDaZ's homepage!
 
Reply     « Reply to Mixing MyISAM and Innodb
 
Previous Thread | Next Thread Tycoon Talk > Web Development and Programming Support > Coding Forum > Mixing MyISAM and Innodb

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off




   
RSS Feed  Feeds: RSS   JS   XML
RSS Feed  Feeds for this forum: RSS   JS   XML



Page generated in 0.87355 seconds with 12 queries