Re: New Setup

Hi, Go to /etc/init.d and type : ./mysql(d) restart _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Ian Phillips [EMAIL

Re: problem with libmysqlclient_r.so

Hi! Andrey == Andrey Kotrekhov [EMAIL PROTECTED] writes: cut Andrey #12 0x180e7cdc in mysql_real_connect () Andreyfrom /usr/local/mysql/lib/libmysqlclient.so.10 Andrey #13 0x1812f93c in MysqlConnection::real_connect (this=0x80c9c18, Andrey db=0x80fe8b0 zzz, host=0x80fb040

Strange Command on Load Data!

Dear all I had use the Load Data Command to import my CSV file from my client side of pc to the Mysql database which located in Server side. The command i type is follow: Load Data local infile 'c:\\Doucments and Settings\\jack\\Desktop\\Web\\test\\hkd_rate.csv' into table hkd_deposit1 fields

AW: AW: MySQL on OS X

Hi everyone, hi Erik With the instructions and the software package provided on http://www.entropy.ch/software/macosx/mysql/ it was really easy to get a running version of MySQL (my preliminary goal). I'm not sure if I can follow all your explanations about the server and client differences of

Re: more on 1049 errors

My MySQL connections are done with the PHP Apache module, which was compiled using the MySQL library of my MySQL installation. (I use Marc Liyanage's MySQL, but roll my own PHP build.) I did some poking around regarding Mac OS X file descriptors, as I've heard a little bit here and there about

RE: memory leaks in libmysqlclient.

Hi! domi == domi [EMAIL PROTECTED] writes: domi Hi ! domi Thank You for the response ! cut domi so I don't think it's solaris-problem. domi Ofcource it can still be my code but I have not found domi the problem... domi So I took a chance and passed this question to list. domi Maybe

Re: problem with max

hello in delphi the type for max(date) if tstring. the only problem is there is no CAST in mysql 3.23.49 bye - Original Message - From: Johnny Withers [EMAIL PROTECTED] To: 'Jean Bernard' [EMAIL PROTECTED] Sent: Thursday, April 25, 2002 2:46 PM Subject: RE: problem with max I'm

SQL Bugs/Missing INFO

Hi! Trent == Trent Creekmore [EMAIL PROTECTED] writes: Trent In the MySQL manual, the error codes are not available. This is a serious problem. I have an error that keeps coming up and no way to solve it. Trent The error code is 1064. I believe for the syntax, but a THOROUGH check indicated

Decimal field

Hello list, I try to enter data via a remote Zeos SQL Componet from Borland c++ builder. I have a decimal field in a table. The problem is when i enter for example 39.00 the table will show 39. If i enter 12.44 the value in the field shows 12.44 Is there a way to make 39.00 instead of 39 ?

Stumped

Dear Group members Well I'm a bit stumped I've gone around a few times trying to get mysql working again on my server. Here is a current list of processes running - and it seems that mysqld is running (twice) - bother are idle (I). Is it safe to send a kill command to these processes? (and

Access Denied

Hi All, Can someone help me figure out the following problem. If i fire the following command from D:\mysql\bin mysql --user=netaps --password=netaps --host=192.168.100.2 --port=3306 --database=netaps --execute=LOAD DATA INFILE 'D:\\NetapsFiles\\jobsequence.csv' INTO TABLE jobsequence FIELDS

Re: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

Is the socket file just a location for mySQL to place the socket information? i.e. the file doesn't have to be there, as Mysql will create it when it runs. Am I understanding this correctly? [EMAIL PROTECTED] --- Life must be lived as play. -

Re: Stumped

On Fri, 26 Apr 2002 18:27:24 +1000 Ian Phillips [EMAIL PROTECTED] wrote: Thanks to Gelu for his patience: unfortunately his suggestion of Gelu Go to /etc/init.d and type : ./mysql(d) restart didn't work for me, as I do not have init.d in /etc - I have searched for ti, but not there. but

Re: mysql client won't run

exec(): 0509-036 Cannot load program mysql because of the following errors: 0509-150 Dependent module libreadline.a(libreadline.so) could not be loaded. 0509-022 Cannot load module libreadline.a(libreadline.so). 0509-026 System error: A file or directory in

Locking Tables

Hi, What error occurs if i try to access (read or write) a table that was locked (LOCK TABLES mytable WRITE) by another thread? Dirso. PS: MYSQL - Before posting, please check: http://www.mysql.com/manual.php (the

Re: problem with libmysqlclient_r.so

äÏÂÒÙÊ ÄÅÎØ. Andrey Are mysql know about this!!! Sorry but if your OS doesn't support gethostbyname_r(), then mysql_real_connect() is not thread safe (I have just updated our documentation about this) Thank you. Another issue is that if your client dies in the dbug_ code, this means

Performance Select Table/Where

My first two questions could not be answered, so, maybe I'll be luck w/ third. A performance question: If I have user numbers and objects belonging to them(e.g.bills), is it better to have one table bills with many rows or to have one table for every user? This means, is it better to do a sql

Re: Stumped

Hi Ian, 1.What version of Linux use ? 2.Type top and you can see at least 4 mysqld processes.Is nothing bad.And for every new connected client apear a new mysqld process. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL

System Spec

Hi I would like to ak what spec should my PC/Server be in order to run MySQL on it? Thanks Amarjot - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the

Deadlock problem (with DBD::mysql, but not DBD::ADO!)

Hi, I sent the following e-mail to the msql-mysql-modules list earlier today regarding a deadlock error using DBD::mysql. I was advised by Jochen Wiedmann that DBD::mysql is simply a thin layer on top of the C interface, and that I should therefore forward my problem to this list, so here

How I got PHP talking to MYSQL

After two days of trying I cracked it. Modify /etc/my.cnf [client] socket=/tmp/mysock.sock [socket] socket=/tmp/mysock.sock Edit /usr/local/lib/php.ini mysql.default_socket=/tmp/mysql.sock Type mysqladmin --socket=/tmp/mysql.sock

Re: Locking Tables

What error occurs if i try to access (read or write) a table that was locked (LOCK TABLES mytable WRITE) by another thread? My belief is that you do not get an error. The thread attempting to access the locked table is stalled until the lock is released. If the lock is never released, you

Re: Performance Select Table/Where

My first two questions could not be answered, so, maybe I'll be luck w/ third. A performance question: If I have user numbers and objects belonging to them(e.g.bills), is it better to have one table bills with many rows or to have one table for every user? This means, is it better to do a

column restrict:fraction 10 ???

Hi! ydbxmhc == ydbxmhc Paul writes: ydbxmhc Good day, everyone, and thank you for your time! ydbxmhc I am not a member of the mailing list (I had to swear them off as ydbxmhc addictive =o) but am posting this question in the hope that some ydbxmhc generous soul will assist me anyway. cut

Re: Performance Select Table/Where

That's the point: Users are added about 10 times less than objects. But your objection about new columns is right, also about system performance. I would have said the main problem is on a query like show all users with their last object for an overview, this would be a very hard job (I think

Report to Recipient(s)

Incident Information:- Originator:[EMAIL PROTECTED] Recipients:[EMAIL PROTECTED] Subject: mysql Digest 26 Apr 2002 10:54:14 - Issue 1869 Message from [EMAIL PROTECTED] was quarantined because it contained banned content.

Re: Re: New Setup

Ian, Friday, April 26, 2002, 12:52:29 AM, you wrote: IP I now have two mysqld processes running on my server (Freebsd / apache), and IP no mysql (according to a ps command). IP What is the safe way to kill these two, and restart mysql? If you really want to kill, you may use kill PID (but not

Re: System Spec

Amarjot, Friday, April 26, 2002, 1:23:45 PM, you wrote: As I would like to ak what spec should my PC/Server be in order to run MySQL on As it? It depends on your OS and purpose of MySQL usage. Check the following links, you can find some info there:

Re: A question on a DELETE statement syntax

Andrew, Friday, April 26, 2002, 3:12:25 AM, you wrote: AW Hello, I am new to mysql - past the very basics - you may see a few silly AW questions - here is the first. AW I have a DELETE statement: AW delete bond_master,bond_data from bond_data where AW bond_master.cusip=bond_data.cusip and

Re: Strange Command on Load Data!

Jack, Friday, April 26, 2002, 10:22:52 AM, you wrote: J I had use the Load Data Command to import my CSV file from my client side J of pc to the Mysql database which located in Server side. J The command i type is follow: J Load Data local infile 'c:\\Doucments and J

Re: MySQL 3.23.33 mysqldump of mysql database has syntax errors in table creation

Tony, Friday, April 26, 2002, 12:15:00 AM, you wrote: TWDescription: TW When dumping the 'mysql' database, the dump file contains syntax errors, TW and I can't find where this has been rectified in later releases. TW Example dump using 'mysqldump -cl mysql': TW [snip]# TW # Table structure for

Re: Access Denied

Amit, Friday, April 26, 2002, 11:57:28 AM, you wrote: AL Can someone help me figure out the following problem. AL If i fire the following command from D:\mysql\bin mysql --user=netaps --password=netaps AL --host=192.168.100.2 --port=3306 --database=netaps AL --execute=LOAD DATA INFILE AL

RE: [MySQL] Access denied on LOAD DATA INFILE statement - no subject provided with posting

Amit, Perhaps try running your LOAD DATA INFILE statement typed at the command prompt of the mysql client, and maybe you will get more info as to what the problem is. You may have a MySQL installation where the 'LOAD DATA INFILE' statement is not permitted by default. However,

Sub-query support

Dear MySQL, It seems that sub queries are not supported in MySQL Version-3.23.48. In the new release do we have this support? If so, please let me know in which version i have to look into for this. Thanks and regards, R.M.Ramnarayanan, iNautix Technologies India Private Limited, Chennai,

Re: Update table1 from table2

Hi, I am using MySql Ver ll.15 distrib. 3.23.41 I want to write an sql query something like: update ddata set ddata.pubkey = pubdata.pubkey, ddata.title=pubdata.title where ddata.dkey=pubdata.dkey; This generates an error: ERROR 1109: Unknown table 'pubdata' in where clause and using

Re: left join and three ids problem

Hi, try this: SELECT courses.coursetitle,reservationid FROM courses,applicant LEFT JOIN reservation ON (reservation.applicantid = applicant.applicantid AND reservation.coursesid = courses.coursesid) WHERE applicant.applicantid = 1 This gives you all courses an reservationid0 if applicant has

Please Help Me

I am using MySql with Visual Basic. I Got an ERROR when trying to add a new record in situation as under. I have a table Company and a field in that table EmpName char (20) and one record is there value is = Piyush I am trying to add a new record I can add if the value of field is less then

RE: Uppercase first letter of each word

this is for php, if you are not using php then try something similar //use explode to create an array with one word in each item $sql_array = explode( , $sql_text) //loop thro the array while(list($val) = each($sql_array)) { $val = ucfirst ($val); $new_sql_text .= $val ;

Re: Installation question

Muriel, Friday, April 26, 2002, 1:14:02 AM, you wrote: M My ISP installed MYSQL -max-3.23.49a-pclinux-gnu-i686 on our M dedicated server. They discovered they did not install their client M libraries after I had already created users with the Grant permissions. How did you create users?

Re: Sub-query support

RRamasamymani, Friday, April 26, 2002, 2:32:01 PM, you wrote: R It seems that sub queries are not supported in MySQL Version-3.23.48. You can use JOIN instead of sub-selects, look at: http://www.mysql.com/doc/A/N/ANSI_diff_Sub-selects.html http://www.mysql.com/doc/J/O/JOIN.html R In

Optimizing InnoDB tables

If I have an InnoDB table, how can I optimize it (like OPTIMIZE TABLE for MyISAM tables)? I've seen previous posts from Heikki saying to use ALTER TABLE, as that effectively dumps and reimports the table, but is that true with the new 3.23.50 version that actually has a working ALTER TABLE? I

Replication slave crashes due to SEGV when master is down

Description: I'm running the precompiled binary of MySQL 3.23.49 on a Compaq Alpha system running Compaq Tru64 UNIX V5.1. I run a master mysqld on one machine and a replication slave on a second machine. Everything works fine, but when I shut down the master,

Re: problem with libmysqlclient_r.so

Andrey Kotrekhov writes: äÏÂÒÙÊ ÄÅÎØ. Hmm... I use mysql_init() in each thread but: 8.4.4.4 my_thread_init() . This is automatically called by my_init() and mysql_connect(). ~ And in manual: To get a threaded client where you can

Re: Please Help Me

Whats your INSERT statement look like? And does it give any errors back? -Nick I am using MySql with Visual Basic. I Got an ERROR when trying to add a new record in situation as under. I have a table Company and a field in that table EmpName char (20) and one record is there value is =

RE: Problem with JDBC2 driver across databases

Thanks Mark. I've now downloaded 2.0.13 and I'll see if the problem is still there. Meanwhile I've used a workaround involving two connections, one to each database, so the insert works. Not ideal, though. --Alan -Original Message- From: Mark Matthews [mailto:[EMAIL PROTECTED]] Sent:

RE: Problem with JDBC2 driver across databases

Thanks Jeff, I'll see if it fixes it. I've got round the problem in the meantime by opening two connections, one to each database, but that's a bit messy and shouldn't be necessary. Incidentally, the MySQL page for JDBC (http://www.mysql.com/downloads/api-jdbc.html) still offers version 2.0.4

Re: Performance Select Table/Where

I definitely think that, provided it is properly indexed, MySQL should NOT load the whole table in order to perform a well phrased query. That is the whole point of indexing the database - MySQL can go straight to the results. How large is your large blob? If it is large, and not involved in

Slave crashes with SEGV on master shutdown

Description: I'm running the pre-compiled Compaq Alpha (OSF1) version of MySQL 3.23.49 with master/slave replication. The master mysqld is running on one machine, the slave on another. Everything works fine until I shutdown the master server. The slave

query returns a BLOB for no reason

I apologize if this is a repost, but I've been having problems with my mail servers and don't know for sure what has gone out or come in recently. I am hoping someone can shed light on this for me. We have a fairly simple query that is pulling data from varchar(255) and integer(11) fields and

Killing a thread

Greetings, I'm new to the list and apologize if this question has already been answered. I'm trying to figure out how to make a thread die. From the processlist command of mysqladmin I get back a listing of unauthenticated user that I want to drop from their connection status. I issue the

Re: query returns a BLOB for no reason

At 10:12 -0400 4/26/02, Jerry Jackson wrote: I apologize if this is a repost, but I've been having problems with my mail servers and don't know for sure what has gone out or come in recently. I am hoping someone can shed light on this for me. We have a fairly simple query that is pulling data

sql command to examine blob data?

What Mysql function can I use to examine blob in a table. I need to display part of the blob in hex values. Shouldn't the following sql command work : select hex(substring(col1,1,10)) from table tbl1; Thanks - Before

Re: Re: Unable to get lock on tables for 4.0.1

Nick, Thursday, April 25, 2002, 11:16:02 PM, you wrote: NG Egor Egorov wrote: Hm ... I tested .. it works fine for me ... What error did you get when your user tried to lock tables? NG Here is the error message: NG Error NG SQL-query : NG Lock Table bugs write NG MySQL said: NG select command

Re: query returns a BLOB for no reason

Jerry, Friday, April 26, 2002, 5:12:57 PM, you wrote: JJ I am hoping someone can shed light on this for me. We have a fairly simple JJ query that is pulling data from varchar(255) and integer(11) fields and JJ concatenating the field contents into a single results column. The problem JJ is the

sql command to examine blob data?

What Mysql function can I use to examine blob in a table. I need to display part of the blob in hex values. Shouldn't the following sql command work : select hex(substring(col1,1,10)) from table tbl1; Thanks - Before

Re: How does DISTINCT really work ?

Fournier Jocelyn [Presence-PC] writes: Hi, I have the latest 4.0.2 source installed, and the problem is still here AFAIK : mysql \s -- mysql Ver 12.1 Distrib 4.0.2-alpha, for pc-linux-gnu (i686) -=[root@anedroide]=(/usr/local/mysql-4.0)# bk export -tpatch (13:29:52) #

status of 4.0

I can't seem to find any real currect new about a stable Mysql 4.0 release, anyone know more about this? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

Re: sql command to examine blob data?

What Mysql function can I use to examine blob in a table. I need to display part of the blob in hex values. Shouldn't the following sql command work : select hex(substring(col1,1,10)) from table tbl1; HEX() converts numbers, not strings. There is no function in MySQL for what you want.

Re: Strange Command on Load Data!

Hello, Jack! Special characters have a functional meaning to MySQL(and compilers as well). It is necessary to escape them for any other purpose than the host enviroments function. In MySQL \ is an escape character therefore, if you need to pass \ as a string you must escape it \\ . There is a

Re: Re: sql command to examine blob data?

Paul, Friday, April 26, 2002, 5:57:56 PM, you wrote: What Mysql function can I use to examine blob in a table. I need to display part of the blob in hex values. Shouldn't the following sql command work : select hex(substring(col1,1,10)) from table tbl1; PD HEX() converts numbers, not

Re: problem with libmysqlclient_r.so

For example, have you called mysql_thread_init() before calling mysql_real_connect() in all your threads ? However, to my understanding, mysql_thread_init() is not needed if only one database connection is used, and that database connection is established when the program starts, before any

Scheduling with MySQL

Hi all, I have a PHP based web interface that interacts with MySQL to let users insert data into a table called Messages. Once an entry is made in this table, other applications read and process the entries, modifying them where appropriate. I would like to add the capability to have this

Re: problem with libmysqlclient_r.so

Michael Chang writes: For example, have you called mysql_thread_init() before calling mysql_real_connect() in all your threads ? However, to my understanding, mysql_thread_init() is not needed if only one database connection is used, and that database connection is established when the

Re: Performance Select Table/Where

Hi Alec, thanks for this answer. a) My column is not involved by query b) But it is necessary to hold it in the database (and I don't want to set file_priv) c) And it's as long as a whole document, this means 5-10K I think, a Primary Key is as good as an Index. I will use one table for every

4.0.2 Replication still buggy...

Hey Sasha, I recently wiped my 4.0.2 slave clean and installed the latest 4.0.2, built from the BK tree. Then I synced it up with a nearby slave running 3.23.47 (using rsync after I had flushed the tables on the other slave and run a SLAVE STOP). I started it up and it ran for about a day

Re: status of 4.0

On Fri, Apr 26, 2002 at 09:54:37AM -0400, Brian Smith wrote: I can't seem to find any real currect new about a stable Mysql 4.0 release, anyone know more about this? The 4.0.x code is feeling pretty good with a few exceptions: full-text search (a few folks have encountered bugs), and

Re: Re: sql command to examine blob data?

At 18:12 +0300 4/26/02, Victoria Reznichenko wrote: Paul, Friday, April 26, 2002, 5:57:56 PM, you wrote: What Mysql function can I use to examine blob in a table. I need to display part of the blob in hex values. Shouldn't the following sql command work : select hex(substring(col1,1,10)) from

Re: left join and three ids problem

Works like a dream! thanks so much. thomas On 26 Apr 2002, Diana Soares wrote: Hi, try this: SELECT courses.coursetitle,reservationid FROM courses,applicant LEFT JOIN reservation ON (reservation.applicantid = applicant.applicantid AND reservation.coursesid = courses.coursesid) WHERE

Re: Scheduling with MySQL

I do not think MySQL has any scheduling abilities, clever or otherwise. MySQL just obeys orders. Scheduling (correctly, in my opinion) is the province of cron and suchlike. However, I would suggest, if you have control of the search tools, that you simply put in an extra timestamp field called

Re: dummy queries + csv dump

Maybe it would be enough if you created a little syntax window on your GUI and an Execute button beside it, so you could see what was going to be sent to the engine before clicking Execute. Just a thought, Arthur - Original Message - From: Petre Agenbag [EMAIL PROTECTED] To: [EMAIL

RE: query returns a BLOB for no reason

Victoria, you solved my problem!!! (after we spent way too much time trying to figure out what was wrong with our SQL syntax) Where should we ship the beer to? Thanks from all of us at BCA! - Jerry Jackson Director of Software Development

question about how to disable function...

Hello I installed MySQL version 4.0.1 apha-nt on win2k. I would like to know how to disable function described below: Word MySQL is present in more than half of rows, and as such, is effectively treated as a stopword (that is, with semantical

Re: Scheduling with MySQL

Minor change, I think it should be a datetime field not a timestamp field since timestamps are supposed to be updated by the database. On Fri, 26 Apr 2002 [EMAIL PROTECTED] wrote: Date: Fri, 26 Apr 2002 17:16:06 +0100 From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]

SQLRelay

Anyone know/using SQLRelay w/ MySQL? Any gotchas or wierdness in MT apps using SQLRelay? Sorry for the blast, didn't find alot in the deja archives. TIA, Chris - Before posting, please check:

Re: How does DISTINCT really work ?

Hi, So I assume in this case the only way to have distinct results is to use GROUP BY topic clause ? Regards, Jocelyn - Original Message - From: Sinisa Milivojevic [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED];

Duplicate Keys

Hi List Sorry for the newbie question. Im new to MySQL. I have a table that I don't know how many duplicate records it has, so how do I query and delete all the duplicate (or many multiple) records from a MySQL table ? Thanks in advance Oswaldo Castro

Re: Duplicate Keys

Hi, Try ALTER IGNORE TABLE your_table ADD UNIQUE (column_where_you_dont_want_duplicates); Regards, Jocelyn Fournier - Original Message - From: Oswaldo Castro [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, April 26, 2002 8:20 PM Subject: Duplicate Keys Hi List Sorry for

command 'service mysqld stop' FAILS

I'm running RedHat 7.2 with the default install of mysql. For an unknown reason, mysql refuses to shutdown on a reboot or by typing 'service mysqld stop'. It used to work and I can't think of anything that I changed. When I type 'service mysqld stop', I get: Stopping MySQL: [FAILED] Any

_indexed search by part of string field

Hello mysql, Is it possible to take indexed search by part of the string field (char\varchar) (eg find example by xam, ple, ex, mp.) Like a LIKE or REGEXP, but faster (indexed)? (find all fields containing what part) -- Best regards, Yuriy mailto:[EMAIL

RE: Duplicate Keys

There are couple of ways you can do it. 1) You can use the following sql to find out duplicate rows and then write few more sql to delete duplicate. SELECT column(s), count(*) FROM table-a GROUP BY column(s) HAVING count(*) 1; then massage the data with couple of more sqls. 2) This

mysqldump generates create table commands with wrong table name case.

mysqldump does not preserve table name case when dumping tables on my Windows platform. Distribution file name: mysql-3.23.49-win.zip C:\mysql\binmysqladmin version mysqladmin Ver 8.23 Distrib 3.23.49, for Win95/Win98 on i32 Copyright (C) 2000 MySQL AB MySQL Finland AB TCX DataKonsult AB

Re: 4.0.2 Replication still buggy...

On Friday 26 April 2002 10:11 am, Jeremy Zawodny wrote: Hey Sasha, I recently wiped my 4.0.2 slave clean and installed the latest 4.0.2, built from the BK tree. Then I synced it up with a nearby slave running 3.23.47 (using rsync after I had flushed the tables on the other slave and run a

mysql_real_query and escaping a semicolon

Hi, I have an insert command that I'm executing through the C API function mysql_real_query. One of my values is a string like this: '1;' When mysql_real_query sees the ;, it thinks it's the end of the statement. How can I prevent that from happening? Is there a way to escape it? Thanks

Report to Recipient(s)

Incident Information:- Originator:[EMAIL PROTECTED] Recipients:[EMAIL PROTECTED] Subject: mysql Digest 26 Apr 2002 19:59:31 - Issue 1870 Message from [EMAIL PROTECTED] was quarantined because it contained banned content.

MySQLdb and DateTime objects

I'm have a bit of trouble figuring out how to use a date field retrieved from MySQL when updating a record in another table. Rather than a date string, MySQLdb returns a DateTime object. At first, imagining that since it came out of a field, the date object would also then match the field in a

Potential bug

I'm writing to you about a potential bug. I am using (trying) the gui for managing the dbs, and it freezes if i hit a keystroke while looking at a query result. thanks, Mike Benson Web Development Children's Safety Village of Windsor and Essex County http://www.rotarysafetyvillage.com

Re: mysql_real_query and escaping a semicolon

At 14:03 -0600 4/26/02, Anna Fowles-Winkler wrote: Hi, I have an insert command that I'm executing through the C API function mysql_real_query. One of my values is a string like this: '1;' When mysql_real_query sees the ;, it thinks it's the end of the statement. That's unlikely. I'd guess

Re: mysql_real_query and escaping a semicolon

Well, the function is called like this: mysql_real_query( mysql_connection, query_string, strlen( query_string )); Wouldn't that pass the correct length? --Anna Paul DuBois wrote: At 14:03 -0600 4/26/02, Anna Fowles-Winkler wrote: Hi, I have an insert command that I'm executing through

Re: mysql_real_query and escaping a semicolon

At 14:37 -0600 4/26/02, Anna Fowles-Winkler wrote: Well, the function is called like this: mysql_real_query( mysql_connection, query_string, strlen( query_string )); Wouldn't that pass the correct length? Not necessarily. --Anna Paul DuBois wrote: At 14:03 -0600 4/26/02, Anna

Re: mysql_real_query and escaping a semicolon

Paul DuBois wrote: At 14:37 -0600 4/26/02, Anna Fowles-Winkler wrote: Well, the function is called like this: mysql_real_query( mysql_connection, query_string, strlen( query_string )); Wouldn't that pass the correct length? Not necessarily. Uhm... why not? Wouldn't strlen return the

WHERE ignored

Okay, I am having some trouble with MySQL that could *potentially* be quite serious. A little background first. I'm running PHP 4.2.0 (Release) and MySQL 3.23.49a over five servers. One server is a MySQL Master with PHP CGI version, two are MySQL slaves and the other two are Apache webservers

Re: mysql_real_query and escaping a semicolon

Paul DuBois wrote: At 14:37 -0600 4/26/02, Anna Fowles-Winkler wrote: Well, the function is called like this: mysql_real_query( mysql_connection, query_string, strlen( query_string )); Wouldn't that pass the correct length? Not necessarily. Uhm... why not? Wouldn't strlen

Re: mysql_real_query and escaping a semicolon

Paul DuBois wrote: Paul DuBois wrote: At 14:37 -0600 4/26/02, Anna Fowles-Winkler wrote: Well, the function is called like this: mysql_real_query( mysql_connection, query_string, strlen( query_string )); Wouldn't that pass the correct length? Not necessarily.

Re: WHERE ignored

On Fri, Apr 26, 2002 at 10:20:41PM +0100, Mike Hall wrote: SELECT MailID, MailBody, MailHeaders FROM Mail WHERE Sent = 0; UPDATE Mail SET Sent = 1 WHERE MailID = [whatever]; [..snip..] As I said, this script runs every five minutes - which means this query has been ran around 83,000 times

Re: mysql_real_query and escaping a semicolon

Anna Fowles-Winkler wrote: Paul DuBois wrote: Paul DuBois wrote: At 14:37 -0600 4/26/02, Anna Fowles-Winkler wrote: Well, the function is called like this: mysql_real_query( mysql_connection, query_string, strlen( query_string )); Wouldn't that pass the correct

RE: MySQLdb and DateTime objects

-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Nick Arnett [snip] What seemed to be the obvious solution was to use MySQLdb.times.format_TIMESTAMP() or MySQLdb.times.format_DATE()-- but that doesn't work, it returns an error: File

Multiple Sum Query

I have a table with a telephone number, rating period and minutes. I want to run a query grouped by telephone number that will have as columns: Phone Number | Sum(where rating period =1) | Sum(where rating period =2) | Sum(where rating period =3) I have had very bad luck so far, seems I can

Re: WHERE ignored

Is there any chance at all that a field name is appearing in your WHERE clause? For example: UPDATE foo SET flag = 0 WHERE foo_id = foo_id; foo_id = foo_id of course matches all. No, the query is hard coded to WHERE Sent = 0. Not much room for that kind of error in this example, but

What next

I was able to start the mysql server using this suugested by Egor Egor safe_mysqld [1] 15476 user_obscured:/# Starting mysqld demon with databases from /usr/local/var nohup /nfs/usr/libexec/mysqld --basedir=/usr/local --datadir=/usr/local/var --port =30100 but after this response, the ssh

Followup: Mysql Bug Report, Random crashes, reason unknown

Hello All Many Thanks specialy goto Egor Egorov. We changed the RAM in the Server .. MySQL has now been Running (without Crash) for over 48 h .. Problem solved ! Thanks again for your Support ! Cheers Gavin Woodhatch NetZone Ltd.

  1   2   >