Using Access as front-end for Blob.

Anyone know how to use access as front end for accessing blobs in mysql. I have found some sample code for storing blobs in mysql, but for whatever reason when I export the tables to mysql and link them it stops working. Even though the blobs remain and can be accessed without corruption from o

Re: do i need an index for this?

Hmmw your syntax should ork. Possibly try CREATE INDEX urlindex ON internet_usage (time(8)); W 8hich will only use the first charaters of your time field, it should make the index significantly smaller in size. Though I'm not completly sure shorting time field this way is legal, but you can alway

Re: Using Access as client all fields are marked "#Deleted"

I've seen this before and do not exactly remember why, think it had something to do with relationships and links, try removing all relationships and see if that helps, if not try deleting tables and relinking them from scratch (found the link manager doesn't always fix problems for some reason)

MaxProxy with MYSQL Control Center.

Has anyone tried MaxProxy, it claims to allow you to use any MySQL pogram to access the their new MAX SAP solution. it seems to work, but it causes MySQL Control Center to crash, anyone else had this problem? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubs

mysql with SAS

Has anybody out there used sas as a frontend of MYSQL. It is a great datamanagement and statisics program, but it seems to have a few problems dealing with mysql. One, it really wants to use cursors (which mysql doesn't support yet) but thats fine. In the absence of that when you set mysql as a

Re: Why are Duplicate keys allowed???

This is perfectly legal and right. A null should not be used for a value, and null should be used where a value will be put but has not been yet, so if I plan on putting 3 entries in where they are all the same but that in future will be different this is correct. Anyways two NULLS should not b

Re: speeding up fulltext

Mark wrote: Why don't you just always put a limit 1000 on it, do you ever need more than that? Hi, I have a fulltext index on a table with 80,000 rows. when I do a search for a common word it is very slow, for example: select count(*) from resources where match title,keywords against('common w

Re: Does mysql cache results?

Read the Mysql reference manual on optimizations. http://www.mysql.com/documentation/mysql/bychapter/index.html#Query_Speed Should help you out. Russ wrote: Hi, I'm doing some web development and have mysql (3.23.x) installed to test with (win2k, but I don't think this question is particularly p

Re: Selecting with JOIN, GROUP BY and MAX

don't think these would do what I want, I need the record with the max date *for each unit*. Each of these would just select the one unit that had the max date. Steve --- John Larsen <[EMAIL PROTECTED]> wrote: Try just doing a WHERE to select the record with the max date. SELEC

group by to return 1 row.

Is it at all possible to group by and have it return all variables from a single row based on a max() criteria of a single variable? For instance in SPSS I can sort by id number descending then in an aggregate have it say that newvar2=first(newvar) or last(newvar).?? Just a thought?? any ideas

group before join

Does anybody know if there is a way to aggregate a table then join it to another table? I assume this would be possible with a subquery as in SELECT * FROM t1 WHERE t1.a=(SELECT sum(t2.b) FROM t2 group by t2.c); Except when I do it with 4.1alpha I get error "[root] ERROR 1240: Subselect returns mo