Re: help with storing a large binary number as bigint

You could use the mysql CAST or CONVERT functions Byron.Albert wrote: Hey all, This should be a relatively simple question but after looking through the manual for a while I didn't see how to do it. I am working in php and need to store a large binary number in the database. When I try and

Order by leads to an empty set.

Hi all, I have a strange problem and I can't really understand what's going on! mysql SELECT n.nid, n.sticky, n.created FROM node n WHERE n.type='image' AND (n.uid = 1 OR n.status = 1) ORDER BY n.created desc; Empty set (0.00 sec) mysql SELECT n.nid, n.sticky, n.created FROM node n WHERE

Re: Order by leads to an empty set.

On Tue, May 09, 2006 at 12:13:41PM -0400, Rhino wrote: - Original Message - From: Mohammed Sameer [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Tuesday, May 09, 2006 9:56 AM Subject: Order by leads to an empty set. Hi all, I have a strange problem and I can't really

Re: Formatting Date to make counts easy.

Payne wrote: Hi, I having a problem doing a simple count with the way date is format 2005-12-11 21:49:36, what I am wanting to do is a simple count where it only returns just the date. What do i need to do to get it where is (2005-12-11) and for that matter switch the date to us format.

stored procedure - updating record by record

_using mysql5 _I have a table points with (atleast) following fields points_id (int, primary key), logged (datetime), sale_points(float), available_points(float) When a new row is inserted available_points is set to the value of sale_points I need to update the available points for each

explicit row locking in InnoDB

need some urgent help im using InnoBD database type...i need to explicitly lock a row and keep it locked until i explicitly unlock that row.. it would be great if u could provide me with sql statements as a solution for the above... thanks

Re: stopping server from pid file error

On Fri, Mar 18, 2005 at 11:02:50AM -0600, sharif islam wrote: # mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql STOPPING server from pid file /var/lib/mysql/mymachine.pid 050318 11:01:31 mysqld ended [EMAIL PROTECTED] mysql]# ls -la /var/lib/mysql total 40

Re: AW: [PHP] How to argue with ASP people...

snip On Fri, Dec 31, 2004 at 05:17:27PM -0600, Bob Ramsey wrote: The only snage with the header function is that you must not print or echo anything to the browser before you use it. In other words you can't do this: html body pI moved you to another page./p ?php header(Location:

Re: MySQL blocking ACPI suspend

On Sat, Jul 17, 2004 at 11:25:33PM +0200, Loic Minier wrote: Did other MySQL users experience this? I can confirm this on Debian testing and fedora core 2 -- -- Katoob Main Developer Linux registered user #224950, ICQ #58475622 -- Don't send me any attachment in Micro$oft

Please help me optimize a MySQL server.

Hi, I'm running a MySQL server on a duel P III 1G, with 2 GB RAM. MySQL 4.0.18 compiled from source. We have 2 webservers running apache, And this is the backend database server. The server is really slow. a select on a table with 138,247 rows takes about 1.6 - 2+ seconds, I have about 50% CPU

[uniball@gmx.net: Re: Please help me optimize a MySQL server.]

sorry Egor Egorov, Mutt sent the mail to your private inbox ;) resending to the mailing list. On Wed, May 19, 2004 at 02:02:29PM +0300, Egor Egorov wrote: Mohammed Sameer [EMAIL PROTECTED] wrote: I'm running a MySQL server on a duel P III 1G, with 2 GB RAM. MySQL 4.0.18 compiled from source

Re: Please help me optimize a MySQL server.

look for better hardware/or clustering ? On May 19, 2004, at 3:26 AM, Mohammed Sameer wrote: Hi, I'm running a MySQL server on a duel P III 1G, with 2 GB RAM. MySQL 4.0.18 compiled from source. We have 2 webservers running apache, And this is the backend database server. The server

Re: Please help me optimize a MySQL server.

Sameer wrote: On Wed, May 19, 2004 at 08:47:28AM -0400, Brent Baisley wrote: Something that small shouldn't really need optimizing. What is the size of your data (mb?, gb?) and what does your query look like? If you are doing a wild card search on a large text field without a full text

Re: Apache + php + MYSQL

Hi, How do i check whether PHP has MYsql support built or not Please help Sameer -- you wrote: On Tuesday 21 May 2002 09:51, Robert Vetter wrote: On Tuesday 21 May 2002 10:38, Sameer Maggon wrote: in /var/www/html/rcmms/appl.php on line 5 Hello, 1. make shure the PHP module

Apache + php + MYSQL

Hi, I have my Database in MYSQL and wanna use PHP on Apache At the starting of the page I have given ?php $query = SELECT * FROM appl; // Establish a connection to the MySQL DBMS $connection = mysql_connect(linuxsrv, sameer, sameer); // Use the rcmms database mysql_select_db(rcmms

BLOB - JPG

Hi, If i have a JPG file, how can i put it into the database / table in MYsql with one field defined as BLOB.. Please help Sameer -- http://www.dypatil.edu For Better tomorrow - Before posting, please

Re: Re: store JPG in MySQL DB

Hi, That explains me a problem but i could not see strmov() function any where, while linking with -lmysqlclient also it gives unreferenced function.. I am using Mysql 3.23 Please help Sameer -- you wrote: Sameer, Monday, May 20, 2002, 11:17:48 AM, you wrote: SM Can you please

Binary Data mysql_real_escape_

^]\Z^_^^^]\Z^\^\ $.\' \' at line 1 HWhat might be the problem Please help Sameer -- http://www.dypatil.edu For Better tomorrow - Before posting, please check: http://www.mysql.com/manual.php

Mysql Connection from Webserver

Hi, I am using ASP and using IIS webserver.. I have a Mysql server installed on a linux box. what is the connectstring that i have to use to connect and gather data from my Mysql server Sameer -- http://www.dypatil.edu For Better tomorrow

Insert into Table

Hi, I have a table in which i have a field of VARCHAR(255), i am picking up URLs from a file and INSERTING into mysql table, i am using MySQL C API, the problem is that file contains 6700 records and it is just inserting few records like 100 or so, what may be the probnlem Please help Sameer

Please help - Inserting

Hi, I have a table in which i have a field of VARCHAR(255), i am picking up URLs from a file and INSERTING into mysql table, i am using MySQL C API, the problem is that file contains 6700 records and it is just inserting few records like 100 or so, what may be the probnlem Please help Sameer

query - primary key

, after 104 items, it gives an error, DUPLICATE ENTRY I have checked the file, they are not duplicate What do i do Please help Sameer -- http://www.dypatil.edu For Better tomorrow - Before posting, please

Re: query - primary key

:00:00- http://64.14.197.173/Lang/Main.asp?S=123456SR=238977R=[direct] lang=EN ' for key 1 Thanx Sameer -- you wrote: paste in the full error message, and if you made 'id' a TINYINT AUTO_INCREMENT, think very very carefully about the rage of a TINYINT. -- Dan Nelson [EMAIL

Re: query - primary key

Hi, Firstly, how do i correct that error of BAD text coz i actually have a text file which has a HISTORY dump from IE. Secondly what about the Duplicate Entry stuff, its comming for all the URLs why?? Regards Sameer -- you wrote: I'd take a look at this error first; you seem

store JPG in MySQL DB

Hi, Can i have a table in which i can store my JPG file somehow in MYSQL database. like i can do it in Oracle Sameer -- http://www.dypatil.edu For Better tomorrow - Before posting, please check

Re: store JPG in MySQL DB

Hi, Can you please put some light on it.. How i can do it, or is it described in manual Sameer -- you wrote: Hi Hi, Can i have a table in which i can store my JPG file somehow in MYSQL database. Absolutely. just declare a BLOB column, and load your images rightinto

Problems Creating BDB Type Tables

Dear Sir, We are developing supply chain management where we are using EJB and mysql as back end. We want to use transaction safe tables, but I tried 'show variables;' command to know about table support for mysql support. Only 'have_isam' is 'YES' all other are 'NO'. Does this means I