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 co

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. Here

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 n.ty

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: > Sent: Tuesday, May 09, 2006 9:56 AM > Subject: Order by leads to an empty set. > > > >Hi all, >

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

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 > dr

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: AW: [PHP] How to argue with ASP people...

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: > > > > I moved you to another page. > http://someotherpage.com";); ?> >

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 (.D

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 id

[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. > >

Re: Please help me optimize a MySQL server.

l P III with 2 GB RAM and a RAID controller. Do you think there is much to be done, or shall I 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

Re: Please help me optimize a MySQL server.

connection, Same for the 2 webservers. I verified this now. > > On May 19, 2004, at 10:34 AM, Mohammed 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 > &g

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

http://windowsmedia.com/mediaguide/default.asp ' for key 1 Duplicate entry 'k6m1-2001-08-13-08:00:00- http://64.14.197.173/Lang/Main.asp?S=123456&SR=238977&R=[direct] &lang=EN ' for key 1 Thanx Sameer -- you wrote: paste in the full error message, and if you made &#

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

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 righ

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

Binary Data mysql_real_escape_

FIF\0^A^A\0\0^ A\0^A\0\0ÿÛ\0C\0^H^F^F^G^F^E^H^G^G^G ^H\n^L^T\r^L^K^K^L^Y^R^S^O^T^]\Z^_^^^]\Z^\^\ $.\' \' at line 1 HWhat might be the problem Please help Sameer -- http://www.dypatil.edu For Better tomorrow --

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

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 I says that mysql_connect Fatal error: Call to undefined function: mysql_connect() in /var/www/html/rcmms/appl.php on line 5 Please advice Sameer -- http

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 sh

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 did