Nested query issue in MySQL 4.1

Hello all I have a problem to report. There is a SELECT query that selects data from three tables according to certain criteria. It goes like this: SELECT bglavna.T001, bpolja.ID AS ID2, bpotpolja.TEKST FROM (bglavna INNER JOIN bpolja ON bglavna.ID=bpolja.FK) INNER JOIN bpotpolja ON bpolja.ID=bpo

Dumping mysql databases that have BLOB column

Greetings Does anyone know the exact syntax to dump all mysql databases, but some of them have blob columns. When I execute mysqldump --all-databases mysqldump doesn't work properly whein it reaches these blobs. So I need only syntax to backup everything and restore everything back without having

MySQL BLOB fields and large binary data

Greetings Seemingly MySQL has a persistant problem that I could not solve whatever I tried to do. It seems that it is impossible to send large amount of binary data to mysql's BLOB field. It is written in manual that 4.0x versions do not have limit for max_allowed_packet. It is also written that b

Memory allocation error in MySQL

Greetings Recently I have a great problem. My whole project depends on it and some people are not satisfied with my aplication because of it. I use database for storing into InnoDB tables word documents into BLOBs, and some other information about docs into standard column types. However, after a

UNICODE in MySQL

Greetings all I was wandering whether MySQL (4.0.4 or higher) in combination with InnoDB support UNICODE. If I store central European characters using MyODBC from VB, am I sure that they are stored in UNICODE in InnoDB table file and that they can be returned in the same form on every machine? Th

MySQL subquery that works

Greetings! I am aware that MySQL does not support subqueries. I have a 3 gb large database of bibliographic records. Database is designed by a model that is accepted by almost every library system, but there is one problem. When searching that database, nested queries are needed and there's a diff

MySQL and UPDATE query

well, but when using VB and MyODBC or just mysql client, every Field_name's value bocomes 0 (zero). What did I do wrong? Thank you all Bruno Batarelo - Before posting, please check: http://www.mysql.com/manual.p

MySQL BLOB & Visual Basic

Greetings. I try to save 7MB large binary string to mysql blob field in the latest mysql server. I use innodb tables. Error I receive from myodbc driver says: Memory allocation error. Here is my.ini extract: set-variable=max_allowed_packet=30M set-variable=wait_timeout=10 set-variable = innod

MySQL BLOB field - reliable or NOT?

I belive that I have a little bit bigger problem with MySQL, and for now, no one told me a solution. Problem is with BLOB fields. That type of field behaves OK if I use INSERT INTO statement. But the problem is that it is impossible to use INSERT INTO when I need to send a string full of binary ch

BLOB and ADO

Greetings There is a persistant problem while trying to insert a string from within VB 6.0 application to the LONGBLOB field. I use ADO and code for adding new record is as followes: TabelaTekst.AddNew TabelaTekst!Polje = BinaryString TabelaTekst.Update and error is: "Multiple-step operatio

Delete

Greetings In the comments section (delete speed) somebody wrote that that it is much faster to delete results of previously executed select query. How can I do that when delete from..where in(select query); is not possible? Regards Bruno

BLOB field and ADO

Greetings! Has anyone ever had the following problem with ADO ODBC connection: I create a table with a BLOB field. From MySQL shell I update that field using insert into statement and all works perfectly. But when I try to execute that query from VB usnig ADO and ODBC connection (MyODBC 2.50 or

Backslash BUG?

Greetings I use latest stabile version of MySQL. Please, try to create temp table or normal table and from mysql.exe try to insert a backslash symbol into a field. Here is an example: Enter password: ** Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 441