Hi,
Can some one send me the sample working code of C API
for MYSQL for the following functions(The platform on
which MySQl data base was downloaded is WINDOWS NT-4.0
work station):
Functions for which I need the dample code:
mysql_real_escape_string()
mysql_escape_string()
Regards,
Ravi
Ok, I'm going to make a guess here. You're using Apache web server with
php4 to store and retrieve info from a mysql DB, right?
If this is correct then this is not a mysql problem but an apache/php
problem. Go to the php site and have a read of the user commented on-line
manual. In the
You have a concurrent process reading/writing the mysql sock, like the default php
binary distribution which has built-in mysql support. read the php docs on this and
then build your own php with shared mysql support, or trace the other application
reading/writing the mysql.sock
gl
rene
On
Hi,
Trying to generate mysql 3.23.38 from source distribution, i got the error :
checking for tgetent in -lncurses... no
checking for tgetent in -lcurses... no
checking for tgetent in -ltermcap... no
checking for termcat functions library ...configure:error:No curses/termcap library
found
Tonu Samuel wrote:
On 09 May 2001 09:43:59 +0100, Eugénio Veiga wrote:
Hi
Does any body if is possible in windows 9x to implement odbc for MySql
with ssl ?
There exists any driver for this ?
Well, I do not know much about ODBC. But anyway if you tell MySQL with
SSL then you mean
Hi Rolf,
Your guess is not true.I am using MySQL C-API for
accessing the My SQL data base on Windows N T 4.0.
Regards,
Ravi
--- Rolf Hopkins [EMAIL PROTECTED] wrote:
Ok, I'm going to make a guess here. You're using
Apache web server with
php4 to store and retrieve info from a mysql DB,
VVM Ravikumar Sarma Chengalvala writes:
Hi,
1.
I am using MySQL3.23 on WindowsNT4.0 platform.
2.
Whenever I try to use mysql_real_escape_string()
method,it works well with the compiler and fails while
linking.I am using VC++6.0 as environment .The reason
that I have traced out is:
i)
Peter,
I have found rather strange things when I have played with
O_SYNC, fsync, and fdatasync this weekend.
On Linux-Compaq Alpha, opening the file with the O_SYNC option
(which makes the OS to do the fsync after each write) speeded
up autocommit inserts by a factor of 3. I was able to insert
Steve,
you should set autocommit=0 and only call commit after the
whole batch of inserts.
so then if I'm inserting via a mysqldump file I should
append commit; to the last line of the file?
yes, put on the first line of the dump file
set autocommit = 0;
and on the last line
Dear Friends,
I am a newbie at MYSQL.I am up with a problem that involves creating a
database which has to work in a client server environment.My friends
suggested me to use mysql and thence was my entry to it.With very little
time left for the deadline,I need your kind help to finish the
Can anybody please help me with the making of this database or atleast
guide me with the making of this..please.
Thank You
I suggest you start reading on database normalization (www.devshed.com has
an article on this in the mysql part of their website).
Bye,
B.
Hi,
I guess that termcap or curses library is not installed.
Perhaps my question wasn't accurate enought.
The problem is that i don't know how to install these libraries. Do you ?
What package do they belong to ?
Thanks.
- Original Message -
From: Joseph Bueno [EMAIL PROTECTED]
To:
Dan,
At 03:02 PM 5/11/01 -0500, you wrote:
In the last episode (May 11), Heikki Tuuri said:
Dan Nelson wrote:
No ANALYZE TABLE - correct key and subkey cardinality counts work
wonders for complex queries (probably easy to add).
InnoDB does the estimation of cardinalities required by
Hi,
Since you don't even say on what platform (Linux, BSD, Solaris,...)
you are trying to build MySQL, it is hard to give you specific answers.
If you are using some Linux distro based on RPM (RedHat, Mandrake,..)
you should search for a ncurses-devel-something.rpm (something depends
on your
What's your datatype?
Cal
http://www.calevans.com
-Original Message-
From: Tyrone Mills [mailto:[EMAIL PROTECTED]]
Sent: Sunday, May 13, 2001 10:59 AM
To: Mysql@Lists. Mysql. Com
Subject: Duplicate entry '0' for key 1
Importance: High
Why is it that a seemingly random intervals
I don't see how this could possibly be an urgent request. You haven't even started
the project design yet.
Now, if the project were all done, and you're scheduled to go live with it tomorrow,
and you suddenly discover that all your indexes are corrupt, and the boss is cursing
your name --
Here's the CREATE TABLE syntax I used on the latest table to do this to
me...
CREATE TABLE site_users (
user_id INTEGER UNSIGNED DEFAULT '0' NOT NULL AUTO_INCREMENT,
user_name VARCHAR(20) BINARY NOT NULL,
user_password VARCHAR(20) BINARY NOT NULL,
user_referrer_id INTEGER UNSIGNED NOT NULL,
Other than the fact that I don't think you need to define a UNIQUE key for a
field that is marked as a primary key, it looks ok. I just stuffed it into
my tmp database and added 46616 records to it without a problem. That means
it's got to be your MySQL config.
Cal
http://www.calevans.com
Thanks Cal,
Anything in particular in the config I should be looking for?
Thanks,
Tyrone
-Original Message-
From: Cal Evans [mailto:[EMAIL PROTECTED]]
Sent: Sunday, May 13, 2001 9:40 AM
To: Mysql@Lists. Mysql. Com
Subject: RE: Duplicate entry '0' for key 1
Other than the fact that I
Hello,
I just installed the latest Mysql (2-28-gamma) from a
binary RPM and noticed a few problems:
1. /usr/bin/perl5 dependency fails - solution: rpm
--nodeps -ivh Mysqlrpm
2. mysql.sock is in /var/lib/mysql/ dir instead of
temp where clients like mysqladmin seem
Hi there
I have run into a problem, I have changed all my code from using ADO and
MSACCESS to SQL statements using the MYSQL API, however, some of my fields
have a single quotation in them, and now this interfears with my syntax and
I am getting problems, is there a way to overcome this? I know
Escape the single quote with '' (2 single quotes).
Depends on what language you are using, some languages like PHP have a
built-in function to do this. others like VFP have things like strtran().
Cal
http://www.calevans.com
-Original Message-
From: Warren van der Merwe [mailto:[EMAIL
Hello group -- I'm a newbie using phpMyAdmin to manage a test database.
Here's my Q: In Table A, lets say Column X is of type SET. Can the allowed
values of Column X be defined by the values of Column Y in Table B, *AND* be
automatically updated when the values of Column Y in Table B change?
I'm trying to compile the mysqlgui source currently available on mysql.com
(version 1.7.5). I've successfully compiled/installed the packages
fltk-1.0.11 and flek-0.1.1 (as suggested by the doc/README.TXT file
supplied with mysqlgui), as well as the fl_editor-0.4 package. The test
programs
Hi guys,
Hope you can help. I'll give you the source code for my
overwriteProduct.php3 first I think:
?php
if (count($DBHOST)==0)
include(/home/stud/yrf/bsccs4/c9803057/phpincludes/dbFunctions.php3);
$dbcnx = myConnect();
echo 1;
while (list
Hi,
Try
$saveQuery = UPDATE $table_product SET PROD_PRICE =
'$value' WHERE PROD_ID = '$key';
instead of
$saveQuery = UPDATE $table_product SET PROD_PRICE =
\$value\ WHERE PROD_ID = \$key\;
Jocelyn Fournier
Presence-PC
www.presence-pc.com
Dans un e-mail daté du 14/05/2001 01:37:19 Paris,
When I installed from RedHat disc, if I ran mysql_install_db prior to setting the
password, I was unable to use mysq, b/c couldn't find mysql.sock. If I install, and
simply issue password, and start mysql up, the initial tables, mysql and test were
created. Running mysql_install_db continually
Hi~ Everybody~^^
This problem is occured incorrect of SQL statment, I think.
First, $saveQuery's value is printed and from printed value, check if SQL
statement is right.
and if SQL statement is right, check part of Database Connection etc..
Have a nice day~
- Original Message -
From:
Hmm... thanks to all who helped. It was a spelling error. How embarrasing.
Thanks again.
Matt
--
From: [EMAIL PROTECTED][SMTP:[EMAIL PROTECTED]]
Sent: 14 May 2001 01:59
To: M.G. Devney C9803057; [EMAIL PROTECTED]
Subject: Re: MySQL-php UPDATE errors
Hi~
On Fri, May 11, 2001 at 11:39:32AM -0700, Eric J. Schwertfeger wrote:
Aside from what's in the manual, I have a little to offer. I just
got InnoDB working yesterday, so take what I have to say with a
grain of salt.
And I'll add a bit, too. :-)
Gemini: Currently in Beta testing, with no
What you want is 'foreign keys', a feature which MySQL does not support.
It's on the TODO list though...
If you really wanted, you could scan table B periodically and update the
Table A definition, but this is a very hack-ish way of doing it. You
probably want to do all this work in your API
On Fri, May 11, 2001 at 07:48:04PM +0530, [EMAIL PROTECTED] wrote:
I am facing great problems beacuse of Mysql server which is not able
to take load.
My apache is working fine even when the load average shoots of to
130 but my mysql server goes sleep when the load of apache shoots
above
I have a problem with MySQL installed in my home
directory(I am not a root).
The server runs, but I can't manage it. I can't create
a database etc.
For example, when I write as below, I get message:
/a/grdfsv1/home3/m5051236/mysql/bin/mysqladmin create
testdb
On Sun, May 13, 2001 at 06:53:49PM -0700, Shtykh Roman wrote:
I have a problem with MySQL installed in my home directory(I am not
a root). The server runs, but I can't manage it. I can't create a
database etc. For example, when I write as below, I get message:
Is there a limit to the number of inner join statements within an sql
statement. I am using the following statement:
SELECT DISTINCT suburb_def.Suburb, church_location.Name, church_location.URL
FROM (suburb_def
INNER JOIN church_location ON suburb_def.ID = church_location.Suburb)
Hi!
I can use the grammer 'LOAD DATA LOCAL INFILE...' to import the local file to
server database.But how can I export the query result from the server to local file?.
hehe
[EMAIL PROTECTED]
On Thu, May 10, 2001 at 03:51:59PM -0400, Chris Foreman wrote:
I would like to use MySQL for a high-availability application
(available 24 hours per day, 7 days per week) using replication to
minimize down times. The volume of transactions will be about one
million per week. Can anyone
trying to install mysql 3.23.37 on a solaris 8 for
intel box. the configure script aborts. here is the
screen output:
==
loading cache ./config.cache
checking host system type... i386-pc-solaris2.8
checking target system type...
On Fri, May 11, 2001 at 01:23:00PM +0300, Kissandrakis S. George wrote:
i installed replication between two mysql servers
Now what?
Relax. Have a drink. Read a book. :-)
is there any software which does insert,deletes,updates on the
master and select on both machines or on slave('s)
Hi,
I am getting the following exception regularly. After getting this
I have to restart the DB.
Please let me know, is there any remedy for this.
Please help me out.
With Regards,
Saravanakumar.M
12:21:23 PM java.io.IOException: Broken pipe
12:21:23 PM at
Hi everyone,
I am having trouble transfering a blob (image) from Microsoft SQL server to MySql. I
am using VB code and the ADo objects / recordsets to transfer the information and all
is going well except when i try to transfer an image into a blob field. I have
debugged this in VB and it
Hi,
I got the following error regularly.
java.sql.SQLException message given: General error: Incorrect key file for
table: 'ALERTUSERPROPS'. Try to repair it
According to the help document I executed the ' isamchk
ALERTUSERPROPERTIES.ISM ` and the problem is solved. Please
i have created a database ,Now i want to copy it on the server. Is there any way to do
it or i have to make tables on the servers
if anybody knows
please reply a.e.a possible.
_
Chat with your friends as soon as they come online. Get Rediff
Hello,
I've been experiencing some problem starting mysqld automatically. The
host (venus) OS is running FreeBSD-4.3 Stable. So there are startup
script at /usr/local/etc/rc.d/ called mysql-server.sh. When system
boots up it starts mysql daemon. But as soon as I can access console,
mysqld
44 matches
Mail list logo