Hi Jed,
you aree totally right. The statement I typed should indeed be: WHERE
tableName.manufacturersID=12
Meaning I got the ambiguity error.
thx for the tip,
Wilbert
- Original Message -
From: "Jed Verity" <[EMAIL PROTECTED]>
To: "Wilbert Enserink" <[EMAIL PROTECTED]>; <[EMA
Jose,
- Original Message -
From: ""JSL"" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Monday, September 02, 2002 11:49 PM
Subject: Maximum number of tables
>
> - Original Message -
> From: "JSL" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Monday, Septem
Hello, Abhilash,
If you just want the number of days between two dates, you don't need
FROM_DAYS. FROM_DAYS gives you a date. This should be all you need:
Select TO_DAYS(CURDATE()) - TO_DAYS('2001-08-30');
HTH,
Jed
On the threshold of genius, [EMAIL PROTECTED] wrote:
> Hi,
> My intention is
Hi,
My intention is to get the datedifference(in no of days) between
the
current date and a previously entered date which is in a table(of
course
this date is lower in value than the current date).When I used this
query:
select FROM_DAYS(TO_DAYS(CURDATE()) - TO_DAYS('2001-08-30'));
Here
>Description:
A specific query in the format of:
SELECT DISTINCT a.*, b.* FROM privatemessage LEFT JOIN b ON (b.x = a.y);
Is causing a segfault. This worked fine in the 3.23 series.
>How-To-Repeat:
DROP TABLE IF EXISTS privatemessage;
CREATE TABLE privatemessage (
privatemessageid int(10)
Sir,
We used the following code for connecting Visual Basic
6.0 with MySql = 3.23.41 .
Mysql was running in Linux Red Hat server 7.2
The VB application was in Window NT node
The provider used was MySQLProv
The code is
Option explicit
Pu
Niki Crook
Technical Consultant
For Home Building Society (08) 9323-5583> [EMAIL PROTECTED]
ASG Limited and
ASG (Asia Pacific) Pty Ltd
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hello,
MySQL 4.0.3-beta, the world's most popular Open Source Database, has been
released and is now avail
Thankx for the reply Egorov,Hillyer and Neil.
Timestamp has solved my purpose.
Actually we are porting an application from oracle to mysql. In Oracle there
were some tables which were using sysdate as default date, therefore we
wanted something similar functionality, as it was very difficult to
hi all:)
int main(void)
{
.
rs=mysql_store_result(&connection);//get result to rs
..
mysql_free_result(rs);// it is necessary ???
rs=mysql_store_result(&connection);// get result to rs again.
}
Help?,
I installed 3.23.52 on a RedHat 7.3 machine. Everything was just fine until I
rebooted later for another reason. Now I can't start the daemon. I tried
deleting /var/lib/mysql/mysql.sock as root. It deleted, but to no avail. Any
idea what I have done wrong? I don't understand sockets. Th
I would like to see the triggers/stored procedures/views
in MySQL also. And the only estimate I saw somewhere was
"around version 5.0".
But think about this this way: in the complex enterprise-level
system you would probably need some kind of application
server instead of direct client-db access.
At 23:57 +0100 9/2/02, Rolf Howarth wrote:
>>RH> I'm using MySQL 3.23.51. I have a table which started giving 127 errors.
>>
>>[skip]
>>
>>RH> It "recovers" my table but I end up with only 1030 out of 27497 rows,
>>RH> so that's not a log of help!
>>
>>RH> Running myisamchk -r -e gives a similar r
Hi. I'm connecting to a remote mySQL server via myODBC from a VB
application. Is this connection secure? If not, how can I make it so?
Would I have to encrypt the data myself somehow or is there some sort of
secure connex like SSL for port 80?
Any help appreciated.
Cheers,
.ben
--
ben joy
Sorry for the MySQL newbie question ... but are there not primary/foreign
key constraints in MySQL 3? I can't imagine that this is right. Perhaps
I'm just overlooking something
Thanks.
Neal
-
Before posting, please check:
At 9:09 +1200 9/3/02, Defryn, Guy wrote:
>I have installed mysql from the ports collection on FreeBSD and it
>was working fine.
>
>I would like to move the /tmp/mysql.sock file ( or is it safe to
>leave it there?) so I
>Created a my.cnf file with the following options
>[mysqld]
>port=3306
>socke
According to the documentation under section 4.3.9 to get openssl
working with mysql you need to configure mysql with the --with-vio
--with-openssl.
When I add the as arguments to ./configure and then compile it I get a
mysqld that will run but try to do anything with it and the client
freez
>RH> I'm using MySQL 3.23.51. I have a table which started giving 127 errors.
>
>[skip]
>
>RH> It "recovers" my table but I end up with only 1030 out of 27497 rows,
>RH> so that's not a log of help!
>
>RH> Running myisamchk -r -e gives a similar result (only 1030 rows are
>RH> recovered), as does
Hi all...
MySQL version 4.0.3-beta
Compaq Deskpro PIII 933MHz
256MB RAM, 92MB SWAP
Binary distribution
>uname -a
Linux homer 2.4.19 #2 Thu Aug 15 19:53:55 NZST 2002 i686 unknown
I don't have another test machine unfortunately, so I don't know if the
problem is specific to my machine/database or
I have installed mysql from the ports collection on FreeBSD and it was working fine.
I would like to move the /tmp/mysql.sock file ( or is it safe to leave it there?) so I
Created a my.cnf file with the following options
[mysqld]
port=3306
socket=/usr/local/mysql/mysql.sock
I take down the mys
Hello,
Im not sure that im sending this mail to the correct people, but Im really
desperate right now.
I have a problem with a SELECT JOIN query.
I have two tables, one which contains Articles, and one which contains
ArticleUpdates. What I would like to do, is to have a report of Articles,
whic
At 10:20 -0700 9/2/02, Sqlcoders.com Programming Dept wrote:
>Please see http://www.mysql.com/downloads/mysql-4.0.html,
>specifically the link for "You can find how to upgrade from MySQL 3.23 Here
>(http://www.mysql.com/doc/en/Upgrading-from-3.23.html)"
>
>..."
>In general what you have to do when
At 14:41 +0200 9/2/02, David Bordas wrote:
>Hi all,
>
>Just a little question on the MyISAM table lock implementation ...
>I just see ( with show full processlist ) that my version of mysql ( 3.23.45
>binary linux tar.gz ) locked my MyISAM table at every query and not only for
>update / delete / i
At 12:39 -0400 9/2/02, [EMAIL PROTECTED] wrote:
>Chuck Amadi <[EMAIL PROTECTED]> wrote:
>
>>Hi Sorry but i nedd to be spoon fed Ýcan i just unzip the
>>MySql-4.0.2-alpha-win.zip into my C:\mysql folder to upgrade and confirm
>>Yes to All at the prompt
>>as i don't want to loose any Projects that a
Hello list,
Here in my company people are concerned about which database to choose to
start implementing a new application client-server. As the only person here
with large experience in this field of activity is me, I am not very much
inclined to our mysql due to its lack of resources like trigge
- Original Message -
From: "JSL" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, September 02, 2002 5:05 PM
Subject: Maximum number of tables
>
> Subject: Maximum number of tables
>
> > Does anyone know what the maximum number of tables a
> > INNODB can store is? >
>
> > Thank
| May be I'm blind, :-) but you provided dump of another table than you
used
| in the query. What is the structure of table 'b2posts'?
You're right, here it is:
CREATE TABLE b2posts (
ID int(10) unsigned NOT NULL auto_increment,
post_author int(4) NOT NULL default '0',
post_date datetime NO
Javier,
it may be that the dbExpress interface is still lagging behind MySQL
development.
If I recall right, people have complained loudly in Borland newsgroups that
dbExpress created a new connection for each SQL query it issues to MySQL.
That makes the use of transactions impossible with it.
I just installed MySQL from RPM and can connect to it via shell using
the MySQL command, but I can't get anything else to connect to it.
MySQL Connection Failed: Can't connect to local MySQL server through
socket '/tmp/mysql.sock' (2)
Thoughts?
Matt Wiseman
-
Sounds like TCP/IP is not running on your machine.
- Original Message -
From: "guilherme.afm" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, September 02, 2002 10:45 AM
Subject: ERROR 2004
I downloaded mysql, i am not sure about the version,
number but i think is the last sta
On Mon, Sep 02, 2002 at 03:35:28AM -0700, John Stanforth wrote:
>
> Jeremy and Michael,
>
> What compiler versions are you using? (just the gcc -v) I'm
> wondering especially since MySQL has a warning posted about gcc 2.96
> with 2.4 kernels.
gcc version 2.95.4 20011002 (Debian prerelease)
> W
You don't have TCP/IP networking installed on your computer.
guilherme.afm wrote:
>I downloaded mysql, i am not sure about the version,
>number but i think is the last stable version. And i use
>it under Win98.
>
>when i type:
>mysql -u root
>to try to login for the first time, i get the follo
Chuck Amadi <[EMAIL PROTECTED]> wrote:
>Hi Sorry but i nedd to be spoon fed can i just unzip the
>MySql-4.0.2-alpha-win.zip into my C:\mysql folder to upgrade and confirm
>Yes to All at the prompt
>as i don't want to loose any Projects that are currently in MySql v3.2.3.
>
>Sorry 4 sounding du
I'm a little surprised that MySQL isn't giving you an error on the ambiguity
of manufacturersID=12. What happens if you specify
tableName.manufacturersID=12?
HTH,
Jed
On the threshold of genius, Wilbert Enserink wrote:
> Hi all,
>
>
> I'm having troubles with a good selection statement in my
At 16:14 02/09/02 +0300, Nick Kostirya wrote:
Hi,
>Hi, All.
>
>I cannot build mysql mysql-3.23.52-win-src.zip (and
>mysql-3.23.51-win-src.zip, and mysql-max-4.0.1-alpha-win.zip).
>Error arise when I build string.lib.
Please read the instructions at (you need the assembler compiler):
http://www.
Please see http://www.mysql.com/downloads/mysql-4.0.html,
specifically the link for "You can find how to upgrade from MySQL 3.23 Here
(http://www.mysql.com/doc/en/Upgrading-from-3.23.html)"
..."
In general what you have to do when upgrading to 4.0 from an earlier MySQL
version:
Run the mysql_fix
Another bug with "create table ... select ..." statement and control
flow functions: see Threads for July 2002.
This bug affects Version 4.0.3 (I have experienced it with LinuxRH7.3,
Windows NT SP6, Windows 2000 SP2).
Try this:
"create table ciccio select if('2002'='2002','Y','N')"
"select * from
Subject: Maximum number of tables
> Does anyone know what the maximum number of tables a
> INNODB can store is? >
> Thanks,
>
> José Lourenço>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php (the manu
Hi Tod, thanks for your answer.
I changed the code to this
Q->SQL->Clear();
Q->SQL->Add("SET AUTOCOMMIT=0");
Q->ExecSQL();
Q->SQL->Clear();
Q->SQL->Add("BEGIN");
Q->ExecSQL();
Q->SQL->Clear();
Q->SQL->Add("INSERT INTO regn_info VALUES('t1','test1')");
Q->ExecSQL();
Q->SQL->Clear();
Q->SQL->A
> On good database servers (eg. PROGRESS)
It's unjust to make this comparison
For example, you can not compare what you don't know about one RDBMS(doesn't
matter if is MySQL or not) with other RDBMS which is familiar for you.
Regards,
Gelu
_
G
Artem,
Monday, September 02, 2002, 12:44:30 PM, you wrote:
AVR> Thursday, August 15, 2002, you wrote:
AVR>>> In case of repliacation circle (A->B->A) query 'flush log' on any of
AVR>>> this servers create endless loop, with creating new binary log file
AVR>>> on each iteration. (about 30 ne
Chugh,
Monday, September 02, 2002, 3:41:27 PM, you wrote:
CS> Can we define sysdate or curdate as default date for a column of
CS> datatype 'date' while creating a table?
You can't define result of function as a default value.
Take a look at TIMESTAMP column type:
http://www.mysql.c
Rolf,
Monday, September 02, 2002, 3:38:06 PM, you wrote:
RH> I'm using MySQL 3.23.51. I have a table which started giving 127 errors.
[skip]
RH> It "recovers" my table but I end up with only 1030 out of 27497 rows,
RH> so that's not a log of help!
RH> Running myisamchk -r -e gives a similar r
I am trying to link to a MySQL table from MS Access 2000.
All columns are OK apart from the TIME column which is displayed as
a varying date and a fixed time e.g. "27/02/2001 23:51:12" and
"30/12/2002 23:51:12".
Also the the TIME field for the first record is empty the rest are not.
Any ide
I downloaded mysql, i am not sure about the version,
number but i think is the last stable version. And i use
it under Win98.
when i type:
mysql -u root
to try to login for the first time, i get the following
error message:
ERROR 2004: Can´t create TCP/IP socket (10047)
I did the same thing with
Hi Sorry but i nedd to be spoon fed can i just unzip the
MySql-4.0.2-alpha-win.zip into my C:\mysql folder to upgrade and confirm
Yes to All at the prompt
as i don't want to loose any Projects that are currently in MySql v3.2.3.
Sorry 4 sounding dumb but i feel abit queesey prior upgrade I hav
Still haven't recieved a simple answer when i unzip the
mysql-4.0.2-alpha-win.zip Do i simply extract into C:\mysql Folder and
override everthing .
as i have working db's so i just would like confirmation prior to
proceeding.
The MySql Doc's don't clarify this I assume you do but i thought i'l
On Mon, 2 Sep 2002, Marian wrote:
>
> Why mysql corrupt tables if filesystem if full ... ?
>
> On good database servers (eg. PROGRESS) process shutdown server
> (protetcting data).
>
> sytem:
> linux-2.2.19
> mysql-3.23-38
Good sys admins don't let filesystems become full
Andy
On Monday 02 September 2002 09:27 am, Derk van der Harst wrote:
> Hello everyone,
>
> how can I insert records with the Euro sign into the mysql database?
> When i try to insert the euro sign i get the err message 'query is empty'.
> Can somebody help?
>
> thanks
> Derk
What happens if you escape
Are the MySQL MYD/MYI file formats documented anywhere? Are they any
utilities that will dump these out for debug purposes?
-Rolf
--
Rolf Howarth, Square Box Systems Ltd, Stratford-upon-Avon UK.
-
Before posting, please check:
Hi,
This error occur because you don't have in your computer "ml.exe".
For this you must install MASM32 or NT DDK.
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
[
Marian wrote:
> Why mysql corrupt tables if filesystem if full ... ?
>
> On good database servers (eg. PROGRESS) process shutdown server
> (protetcting data).
>
> sytem:
> linux-2.2.19
> mysql-3.23-38
>
>
> -
> Bef
Hello
Mozzi wrote:
> Don't understand it still
> It doesn't give me errors in logfile orf when I type show server stutus.
> Yet it isn't replicating !!
> Any ideas ?
> I even tryed checking file sizes between servers on the .MYD file and
> it isn't working
1. On the server do a: mysqlbinlog
Shashank Tripathi wrote:
>
> Hi Lucas,
>
> | Does anyone know what the maximum number of rows a
> | MyISAM table can store is? We currently have a table
> | We're afraid there is hard, implementation imposed limit
> | of unsigned int (2^32) on the number of rows. Before trying
>
Hi, All.
I cannot build mysql mysql-3.23.52-win-src.zip (and
mysql-3.23.51-win-src.zip, and mysql-max-4.0.1-alpha-win.zip).
Error arise when I build string.lib.
Configuration: strings - Win32 Debug
Performing Custom Build Step on .\Strxmov.asm
' tempfile.b
Dear Chugh,
> Can we define sysdate or curdate as default date for a column of
> datatype 'date' while creating a table?
The question is ambiguous:
- if a table is created with a column defined to be a TIMESTAMP data type,
then every time a row is INSERTed or UPDATEd, the current date will be
If what you are looking for is the current date to be used as date of
creation, then remain unchanged, you will have to specify sysdate as a value
during an insert. You may benefit from the timestamp datatype, which sets
itself to the current date when any DML statements (insert, update) are
perfo
Hello everyone,
how can I insert records with the Euro sign into the mysql database?
When i try to insert the euro sign i get the err message 'query is empty'.
Can somebody help?
thanks
Derk
-
Before posting, please check:
Hi, All.
I cannot build mysql mysql-3.23.52-win-src.zip (and
mysql-3.23.51-win-src.zip, and mysql-max-4.0.1-alpha-win.zip).
Error arise when I build string.lib.
Configuration: strings - Win32 Debug
Performing Custom Build Step on .\Strxmov.asm
' tempfile.ba
Scott,
Sunday, September 01, 2002, 9:23:38 PM, you wrote:
SB> The instructions that I have to install MySQL, tells me to "cd to the bin
SB> directory and run this command: ./mysql_install_db"
SB> The problem is that my system can't find this file. Any suggestions?
Scott, you provided not enoug
Alexander,
Sunday, September 01, 2002, 11:33:56 PM, you wrote:
AP> How can I set my mysqld-nt.exe to run different charset
AP> for example cp1251.
Currently you can't use different character sets with one MySQL
server.
AP> I tried mysqld-nt.exe --default-charset-set=cp1251
AP> but it started se
abdul,
Saturday, August 31, 2002, 8:05:27 PM, you wrote:
aÚÇ> Wrong Sorting in arabic alphabets
aÚÇ> Hi,
aÚÇ> This bug is for Arabic alphabets.
aÚÇ> I am using mysql 32.23.52
What character set do you use? There is no character set for arabic
language in MySQL.
--
For technical support c
Matthew,
Saturday, August 31, 2002, 10:41:27 PM, you wrote:
MM> Here is the evil query:
MM> SELECT DISTINCT * FROM b2posts WHERE 1=1 AND ID = 124 AND ((post_title
MM> LIKE '%%') OR (post_content LIKE '') OR (post_title LIKE '%%') OR
MM> (post_content LIKE '%%')) AND post_date < '2002-08-31 14:31:
Hi all,
Just a little question on the MyISAM table lock implementation ...
I just see ( with show full processlist ) that my version of mysql ( 3.23.45
binary linux tar.gz ) locked my MyISAM table at every query and not only for
update / delete / insert.
Why is it locking table for select query ?
Dear All!
Can we define sysdate or curdate as default date for a column of
datatype 'date' while creating a table?
Regards
Sql, mysql, query
-
Before posting, please check:
http://www.mysql.com/manual.php (the man
I'm using MySQL 3.23.51. I have a table which started giving 127 errors.
Running myisamchk -i on it gives:
>Checking MyISAM file: /Users/rolf/WBD/back/clip.MYI
>Data records: 27497 Deleted blocks: 0
>./bin/myisamchk: warning: 9 clients is using or hasn't closed the
>table properly
>-
Hi Lucas,
| Does anyone know what the maximum number of rows a
| MyISAM table can store is? We currently have a table
| We're afraid there is hard, implementation imposed limit
| of unsigned int (2^32) on the number of rows. Before trying
My guess is that the limit is not in t
Don't understand it still
It doesn't give me errors in logfile orf when I type show server stutus.
Yet it isn't replicating !!
Any ideas ?
I even tryed checking file sizes between servers on the .MYD file and it
isn't working
Mozzi
Dicky Wahyu Purnomo wrote:
> Pada Mon, 02 Sep 2002 12:51:50 +02
Dean,
Which MDAC version do you use with ODBC ?
Henk
-Original Message-
From: Dean Browett [mailto:[EMAIL PROTECTED]]
Sent: maandag 2 september 2002 13:38
To: [EMAIL PROTECTED]
Subject: problems adding records to mysql db using odbc/access 2000
Hi,
Can someone tell me how I can add a
Why mysql corrupt tables if filesystem if full ... ?
On good database servers (eg. PROGRESS) process shutdown server
(protetcting data).
sytem:
linux-2.2.19
mysql-3.23-38
-
Before posting, please check:
http://
Does anyone know what the maximum number of rows a
MyISAM table can store is? We currently have a table
(27 GB .MYD, 17GB .MYI) holding more than 2^31 rows:
mysql> select count(*) from BigTable;
++
| count(*) |
++
| 947945 |
++
1 row in set (0.09 sec)
We
Hi all,
I'm using MySQL 4.0.2 alpha-max with Inno DB and Borland Builder 6.0 to
connect to MySQL. I'm trying to use the new dbExpress component for Borland
to connect to MySQL using the libmysql.dll
I have been making some tests with transactions using the dbExpress
components and the normal ODB
Hi,
Can someone tell me how I can add a record to a mysql table via an Access
2000 interface using ODBC ver 2.50.39.
The primary key on the msyql db is set to auto_increment. When I link to
these tables via Access/ODBC the field type in Access is marked as a
'number' data type. Since the tables
Hello!
Almar van Pel wrote:
>Hello,
>
>I was trying to create a simple perl program, where my domains where listed
>followed by there DNS records.
>But It loops once, and then ends with error DBD::mysql::st fetch failed:
>fetch() without execute() at test.cgi line 61.
>
>I thougt this was the ea
Pada Mon, 02 Sep 2002 12:51:50 +0200
Mozzi <[EMAIL PROTECTED]> menulis :
> Heya Dicky
> How are you ? Havn't seen you in a while ;-)
>
> kay what I did was
> >RESET MASTER and RESET SLAVE
> And restartted slave
> That worked!!!
>
> Now what I want to know is when I give the command >show slave
On Mon, 2002-09-02 at 11:37, Harald Fuchs wrote:
> In article <1030961610.8175.5.camel@pascal>,
> Martin Waite <[EMAIL PROTECTED]> writes:
>
> > Hi,
> > You need to use two separate database and statement handles - you can
> > only have one active query per handle.
>
> > eg.
>
> > $dbh1 = DBI-
Hi all,
I'm having troubles with a good selection statement in my query.
I have three tables:
tableAds, tableProducts and tableManufacturer. They all have unique ID's
defined.
In the tableProducts there is a column named manufacturerID. So I know which
product was made by which manufacturer.
I
Heya Dicky
How are you ? Havn't seen you in a while ;-)
kay what I did was
>RESET MASTER and RESET SLAVE
And restartted slave
That worked!!!
Now what I want to know is when I give the command >show slave status I
get the following
mysql> show slave status;
+---+-+--
Jeremy and Michael,
What compiler versions are you using? (just the gcc -v) I'm wondering
especially since MySQL has a warning posted about gcc 2.96 with 2.4 kernels.
Which reminds me, what specific kernel versions are you guys using?
(Jeremy, is yours a custom kernel from Redhat source or L
OpenSSL-0.9.7-beta3
>Description:
gcc -O3 -DDBUG_OFF -O2 -fno-strength-reduce -o test-ssl test-ssl.o
-L/usr/local/ssl/lib -L/usr/local/lib ../dbug/libdbug.a libvio.a ../mysys/libmysys.a
../strings/libmystrings.a libvio.a -L/usr/lib -lssl -lcrypto -lz -lcrypt -lm -pthread
/usr/lib/libc.so.4: WA
Hi,
You need to use two separate database and statement handles - you can
only have one active query per handle.
eg.
$dbh1 = DBI->connect(...);
$dbh2 = DBI->connect(...);
$sth1 = $dbh1->prepare( ... );
$sth1->execute(...);
while ( $sth1->fetch() ) {
$sth2 = $dbh2->prepare( ... );
can you show us, your my.cnf configuration for replication only
master and slave ... ;-)
my first guest is : the slave working db is not being set properly ... so when master
doing query on DB A on table B, the slave try to look at DB "blank" on table B.
see on Replicate-do-db column on s
No, switching to 4.0.2 didn't help either, and here is an additional clue
which may help: all mysql threads on the 4.0.* are in the "sending data"
state, while for the 3.23 the state is changing all the time to "writing
to the net", "connecting" and others. It seems as though the 4.0 version
has p
Hello Victoria,
Thursday, August 15, 2002, you wrote:
AVR>> In case of repliacation circle (A->B->A) query 'flush log' on any of
AVR>> this servers create endless loop, with creating new binary log file
AVR>> on each iteration. (about 30 new files every second in my case)
> Thanks for bug r
I can't understans it though.
I did a mysql dump and transported that to the new server and then
created the tables that way.
So the two must be absolutely identical. (I include them @ the bottom of
post)
Again I get the same error.
Could it be that the status of that particular username has ch
mysql is driving me mad (3)
Many thanks for your help guys, I have the problem cracked. I, for the
umpteenth time dropped the database and recreated it. then from the cli I
put in the maximum value of characters. and there after it worked from my
prog. Very strange!
Thanks again
bob
Hi folks,
I just started playing around with libmysqld and I would like to have some
clarification concerning making connections to remote server.
My first tries are pretty simple so far. I just linked some of my old lil
code against libmysqld which worked (from the view compiling) immediately
a
Scott,
MySQL is available in two 'flavors': source code and (binary) executables.
Which one did you intend to download/install?
Which OpSys are you using?
Please advise,
=dn
> The instructions that I have to install MySQL, tells me to "cd to the bin
> directory and run this command: ./mysql_in
Hi Okan,
Well, the only solution I know of, to diffrentiate the two servers are
to provide different argument on the command line. The server will
allways read any of the files; my.ini or my.cnf first, and there set the
parameters, after that it will take the command line arguments. This
means th
Hi.
I badly need the documentation to the mySQL client-server TCP/IP
communication protocol.
I'm trying to build some measurement system with VEE 6 from Agilent
Technologies, mySQL and Apache.
There is no possibility in VEE to use ODBC, so I've decided to make some VEE
programming of the mySQL po
89 matches
Mail list logo