473,396 Members | 1,996 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,396 software developers and data experts.

Which one is Suitable Engine!?

Hi
I have two tables which is related with primary & foreign key, for that i set the engine type as innodb. but it is not support for fulltext search. which is support for both?
May 12 '08 #1
1 1213
Atli
5,058 Expert 4TB
Hi.

Full-Text searches are only available on MyISAM tables.

Even tho MyISAM does not support foreign-key restrains, using them on such tables should not cause any errors. They will simply be ignored.

The only drawback is that MySQL will not check restrains when inserting, deleting, or otherwise modifying data that may break restrains.
You will have to do that yourself.
May 12 '08 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

21
by: Rabbit63 | last post by:
Hi: I want to show a set of records in the database table on the clicnt browser. I have two ways to do this (writen in JScript): 1.The first way is: <% var sql = "select firstname from...
1
by: gregs | last post by:
Hi folks, I need to know which EXE's of SP3 to install with SQL Server 2000 Personal Edition. From the Microsoft website: ...
11
by: ALI-R | last post by:
Hi ALL; Sorry if here is not a suitable place to post this question,but I'm going to create my own personal website (and a weblog besides it) and I have absolutely no idea where to get a decent...
122
by: seberino | last post by:
I'm interested in knowing which Python web framework is most like Ruby on Rails. I've heard of Subway and Django. Are there other Rails clones in Python land I don't know about? Which one...
20
by: HKSHK | last post by:
Hi guys, I want to write a database application, which I later want to sell. Now I am looking for a nice, little database which would have to fullfil these requirements: * Either free or low...
0
by: dtsearch | last post by:
A new beta build offers 64-bit developer access to dtSearch's "terabyte indexer," and preliminary MS Word 2007 and Excel 2007 support (in both 64-bit and 32-bit versions) BETHESDA, MD (July 22,...
2
by: crescent_au | last post by:
I've read articles and postings about MyISAM vs InnoDB but I am still a bit unsure about which storage engine to use for my new project. I am developing a website in PHP/MySQL, which includes...
15
by: Hydrogenfussion | last post by:
I got into programming so i could program games.At first i just wanted to make simple games like Astaroids and stuff.Now I would like to learn to make Pro games. I still am not even good enough to...
8
by: Damodhar | last post by:
hi any one can say Which Storage engine is better? why? What are functions available in MySQL?
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.