I have 2 tables, category product. product contains category_id which
points back to category.id
I'm trying to get all fields for each category plus the total no. of
products in that category. A simple query for this:
SELECT c.*, COUNT(p.id) AS total
FROM category AS c, product AS p
WHERE
To me it should be a simple task. Insert 65k of text in Unicode or even
simple ASCII format into a column of type 'text' by using a GUI client
like SQLyog or MySQLCC and then extract it when needed by my web page
without loosing everything I put in after a certain character or
character
I have several tables which have some columns indexed for full text
searching.
table 1:
FULLTEXT(foo,bar)
table 2
FULLTEXT(pip,pop,pup)
table 2:
FULLTEXT(hip,hop)
I'd like to be able to query the db to find which columns are indexed
depending on the table to be searched so i can then create my