MySQL Database Forum

I have a field in a table that is defined as a BLOB. I need to convert the data in the field from a BLOB to JPG format. Is this possible? Can someone provide some information on how to do this? :confused:

I read a while back that MySQL will only use one index per query. (If this is not so, please tell me and point me to a doc that gives a good explanation of MySQL's current index usage policy). I'm using MySQL 4.2.x. Here's my dilemma. 1) --------- I have two tables that have records with a FULLTEXT index text field in each of them. ...

Any idea where can I get a copy of the libmysql dll with ssl enabled? Al

Hi, I'm writing an Sql Statement to total the sale of an order TotalSale=(TotalSale + (QtyShipped * Price)). I have the syntax & it works great. However, I'd like to add Tax + Freight that is derived from another table. How do I get it to add only once. Here's the Statement:

I'm new in the PHP/MySQL arena - - which is more common - to use DSNs or to implicitly code the connection strings in the pages?

Hello, I have a table (PEOPLE) with the following information (Id, Name) I have another table (CLASSES) with the following information (Id, Course, Section, Term) I want to get all the people's names that have are in section 12345 and that are graduating in term 1000.

This is my sample error in my MySQL Log New value of fp=(nil) failed sanity check, terminating stack trace! Please read http://www.mysql.com/doc/en/Using_stack_trace.html and follow instructions on how to resolve the stack trace. Resolved stack trace is much more helpful in diagnosing the problem, so please do resolve it Trying to get...

Hello Everyone, I've run into a problem that I can't seem to wrap my head around and I need some help. I know this might not be the *exact* right place to ask for help but since my problem *is* with databases and my database of choice *is* mysql, I thought I'd start here. Here's the problem: I am attempting to create a representation...

I have a table with links, a log table to record clicks, and a vote table to record votes on the links. Is it possible to get the link data, the click count, vote count and vote total in one query? I can get the click count OK, but as soon as I add the vote count to the query, it multiplies them; e.g. for a link with 14 clicks and 2...

This is a multi-part message in MIME format. ------=_NextPart_000_0000_3AC4C749.9C1CB016 Content-Type: multipart/alternative; boundary="----=_NextPart_001_0001_EF906472.5CE0414B" ------=_NextPart_001_0001_EF906472.5CE0414B Content-Type: text/plain; charset="iso-8859-1"

From:Mr.Joseph Thabiso E-mail Address:jthabiso01@webmail.co.za Dear Sir/Madam, STRICTLY CONFIDENTIAL AND URGENT! The South Africa economy has witnessed a steady growth since the end of Apartheid. Within the Ministry of Energy & Mineral Resources where I worked as director of Auditing and Project Implementation, Mining and Quarrying

Folks, My internet access is intermitent until I get my own connection inside the next ten days - I say this so that I can thank in advance who ever gives a few seconds to read/answer my query... Basically - I have three columns in my table... product name hash, product tax code and a unique numeric record id. A product can contain one...

I have a table with three text columns and one time column (say text1, text2, text3, and time). I wrote a query to select the rows where any of the text columns contains a certain keyword: select * from table1 where text1 like 'keyword' OR text2 like 'keyword' OR text3 like 'keyword';

I have a hosted account - I'm getting this error now..... Any reason that I can hunt down to figure out why I should be getting it?

Hello I have problem with my MySQL server and transactions. I installed MySQL server 5.0.11 with MySQL administrator & MySql Query Browser on Win XP Prof. I would like to use transactions, so I have read the manual ana I thought I knew how to do it. I set the tables type to InnoDB (i can't use BDB) and change the default mysqld.exe to...

Hello all, I have two tables tab_a id(int) tab_b id(int)

I'm trying to set them up using this guide: http://www.webmasterstop.com/48-4.html the first time I did this, it worked fine, and after a month, it stopped working (Dreamweaver; no tables found all of a sudden), so I uninstalled mysql + phpmyadmin and tried again. when I load up localhost/phpAdmin on my comp it says: #1045 - Access...

I'll start off by saying I am using MySQL v4.0 and my question is...how do I get mysqldump to dump the actual binary values store in a blob? Here is an example: -- Create a test table create table dummy(col1 blob); -- Next insert a null ascii character (0) insert into dummy values (char(0)); -- To verify there is actually something there...

hi all, I am a newbie .....I have compiled the source code of mysql-4.1.9 on PPC-Linux Its not giving any errors during configure,make or make install. But,when i try to start the server using mysqld_safe...its throwing error like this..

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi! I'm working in a project in C++ using MySQL C API (Win98/Dev-C++ 4.9.9.8/MySQL DevPak/MySQL 4.1.13) and I want to know if it's possible to setup the server environment language (--language) via mysql_options() function.

Hi I have discovered this great program and I wish to use it for data import from dbf to MySql. I wonder if there is possibilty to schedule automatic data import ?

Hello, We sent you an email a while ago, because you now qualify for a much lower rate based on the biggest rate drop in years. You can now get $327,000 for as little as $617 a month! Bad credit? Doesn't matter, ^low rates are fixed no matter what! Follow this link to process your application and a 24 hour approval:

hello, i have been using phpmyadmin, and was trying to import a text file, which is at www.secmaritsolutions.com/d.txt into a database, which has 4 fields, each varchar with a length of 100, comma delimited, however it seems to input into a strange order, results are at www.secmaritsolutions.com/pro.php i chose comma for the field...

I need to do in SQL the following psuedo-code, and I'm stuck: IF ((COUNT(*) FROM a WHERE column_a=1)>0) THEN INSERT INTO TABLE b ENDIF

Hi, I incorporated a function in my code that whenever I use a string variable in an sql statement if the string contains a single quote it will encase it in double quotes else single quotes. Queston: How do you handle a string that contains both single & double quotes (i.e. 12'X7") Here's the function: