***
NOTICE: This transmission contains information relating to
Schlumberger's business activities in Libya. If you are a
"United States (U.S.) Person" (i.e., U.S. Citizen; Permanent
Resident Alien "green card holder"; emplo
Hi,
First at all, I want to appologize if somebody else ever
send this question here.
Would you please help me to solve my problem regarding
installing MySQL.
The error ocured when I 'make'. Last lines from 'make' are:
=
Mak
Aha, much appreciated...your words "therefore the target table may not
appear in the SELECT clause" have made it clear to me...but can I assume
that if I was to use aliases, then I would be able to sneak past this
problem? :)
John :^)
Benjamin Pflugmann wrote:
> Hi.
>
> As is described so
Hi.
On Tue, Oct 02, 2001 at 03:53:12PM +1000, [EMAIL PROTECTED] wrote:
> Aha, much appreciated...your words "therefore the target table may not
> appear in the SELECT clause" have made it clear to me...but can I assume
> that if I was to use aliases, then I would be able to sneak past this
> prob
Hi.
On Tue, Oct 02, 2001 at 01:43:48PM +0800, [EMAIL PROTECTED] wrote:
> > because a newline will indicate a new record, new lines
> > have to be escaped. Else, you couldn't reasonably distinguish what's
> > content and what's record seperator.
>
> Thanks for the reply. Seems to me mySQL should
Hello Nate,
Monday, 24 September, 2001, 19:56:47, you wrote:
NF> I built my database and then used the command:
NF> ALTER TABLE disc ADD FULLTEXT (title,recentdata,specialsound,uniqueid)
NF> But if I try to search with this command:
NF> SELECT title, recentdata, specialsound,uniqueid FROM disc W
Hi.
On Tue, Oct 02, 2001 at 07:25:38AM +0200, [EMAIL PROTECTED] wrote:
[...]
> first thanks for your answer.
> Your example does not work because the IdentNrS field is not in the table
> Bestellungen_Status.
Sorry, but there is no such table "Bestellungen_Status"? You mean
Bestellungen_Status_Te
Hi.
On Mon, Oct 01, 2001 at 07:54:37PM -0700, [EMAIL PROTECTED] wrote:
>
> Hi there,
>
> I have a many-to-many relationship:
>
> ind table
> -
> id = 4, name = Joe
> id = 5, name = Jane
>
> bus_ctr table
> -
> id = 1, name = downtown mall
> id = 2, name = sunshine mall
> i
Hi.
On Tue, Oct 02, 2001 at 07:25:38AM +0200, [EMAIL PROTECTED] wrote:
[...]
> first thanks for your answer.
> Your example does not work because the IdentNrS field is not in the table
> Bestellungen_Status.
Sorry, but there is no such table "Bestellungen_Status"? You mean
Bestellungen_Status_Te
> because a newline will indicate a new record, new lines
> have to be escaped. Else, you couldn't reasonably distinguish what's
> content and what's record seperator.
Thanks for the reply. Seems to me mySQL should give me the \n I'm asking
for rather than assuming that's not what I mean and esca
Hi.
On Tue, Oct 02, 2001 at 11:52:21AM +0800, [EMAIL PROTECTED] wrote:
> I have a batch file called mysql.txt containing the single line,
>
> select "test \n test";
>
> My command for running this file is:
>
> mysql -N -B stud < mysql.txt > out.txt
>
> After running the command, out.txt conta
Hi to All,
I've got some problem with MySQL 3.23.42 on NetBSD 1.5.2.
I compile the sorce only with 'configure --prefix=/usr/local/mysql'.
The 'make' is OK but if I try 'make test' it fail:...
# make test
cd mysql-test ; ./mysql-test-run
Installing Test Databases
Removing Stale Files
Installing M
> Select
>
b.IdentNrA,b.Menge,b.Preis,b.ArtPosition,c.Artikel_Status,d.beschTitel,e.Str
> asse,e.PLZ,e.Stadt,e.Land
> From
> Bestellungen_Status_Text f right join (BestellungenAdr e inner join
> Bestellungen a using(IdentNrS)) using (BestellStatus) inner join
> BestellungenP b using (IdentNrS) inn
Hi.
mysqladmin is part of the client package. You have to install that, too.
Bye,
Benjamin.
On Tue, Oct 02, 2001 at 02:51:36AM -, [EMAIL PROTECTED] wrote:
> >Description:
> Install Script did not create mysqladmin
[...]
--
[EMAIL PROTECTED]
--
Hi.
As is described somewhere (http://www.mysql.com/doc/R/E/REPLACE.html),
REPLACE mainly behaves like INSERT and therefore the target table may
not appear in the SELECT clause (as described here:
http://www.mysql.com/doc/I/N/INSERT_SELECT.html).
Sorry, but it seems you have to use a temporary t
Hi.
On Tue, Oct 02, 2001 at 08:18:50AM +0700, [EMAIL PROTECTED] wrote:
> Hi,
> I have data on more than 1 database with same schema. How could I use SQL
> statement to retrieve it for display in 1 time?
There is no SQL command to do that (yet). In the upcoming version 4.0
there is suppor
Hi.
On Mon, Oct 01, 2001 at 08:32:42PM -0400, [EMAIL PROTECTED] wrote:
> I don't know anything about MySQL, Ive just been trying(with no luck)to
> install a forum(Snitz forum from www.snitz.com) on my website. My website is
> Linux/MySQL/Chilisoft! Im running out of support my host hasn't gotte
Hi.
On Mon, Oct 01, 2001 at 02:05:05PM -0700, [EMAIL PROTECTED] wrote:
> I want to start logging all queries on a mySQL server, but it is already
> running. I would prefer not to shut it down, but if I have to, then I am not
> sure how to start it up again without binding it to my logged-in self,
Hi.
On Mon, Oct 01, 2001 at 04:48:36PM -0400, [EMAIL PROTECTED] wrote:
> I'm trying to remove rows from one table where a column matches another
> column in a seperate table..
>
> I have mysql 3.22.32:
>
> DELETE TemporaryUsers_ToMessWith.* FROM TemporaryUsers_ToMessWith,
> Advantage_Backup WHE
Hi.
A quick search for "temporary files" results in
http://www.mysql.com/doc/T/e/Temporary_files.html
The best guess is that it is the result of massive sorting.
Why this happens (or better: is noticible) only on the new server, I
have no idea of.
Bye,
Benjamin.
On Mon, Oct 01, 2001
Hi.
On Mon, Oct 01, 2001 at 11:20:24AM -0700, [EMAIL PROTECTED] wrote:
[...]
> # at 4
> #010917 0:46:33 server id 1 Start: binlog v 1, server v 3.23.36-log
> created 010917 0:46:33
>
> Now, what is the issue here? Are these log files getting created each time
> the server restarts?
Yes, a
Hi.
On Mon, Oct 01, 2001 at 10:50:51AM -0700, [EMAIL PROTECTED] wrote:
> I need some help,
>
> I need to know how MySQL would handle different language character stes. In
> particular, I need to know how MySQL would handle 2 Byte Characters. Does
> this mean my VarChar (30) would only be able
Hi.
On Mon, Oct 01, 2001 at 01:51:35PM -0300, [EMAIL PROTECTED] wrote:
> Hi list members,
> I've just downloaded and installed MySQL 3.23.XX for an HPUX 11.00. Every
> time I try connect to it I must insert a record in the table user for the PC
> (host) in which I'm trying the connection.
You kn
ln -s /tmp/mysql.sock /var/lib/mysql/mysql.sock to create a symlink.
Nite
M;)
-Original Message-
From: Avtar Dhillon [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 01, 2001 9:46 PM
To: sql-list
Subject: socket problem
Hi All,
I m trying to install mysql on linux machine fr
Hi.
Sorry, but how does this problem relate to MySQL?
Bye,
Benjamin.
On Mon, Oct 01, 2001 at 11:29:13AM -0400, [EMAIL PROTECTED] wrote:
> Hello list members,
>
> I am running mysql on a linux server. I can connect to it using telnet and
> also using mysql client. I am given all the p
Hi.
On Mon, Oct 01, 2001 at 04:53:33PM +0400, [EMAIL PROTECTED] wrote:
> Hello mysql,
>
> Could anyone tell me if heap tables are cyrrently working with
> replication.
>
> As I remember some time ago you might get problems then server
> restarts (so empty it's heap tables) there fore sl
Hi.
On Sun, Oct 01, 2000 at 03:48:36PM +0530, [EMAIL PROTECTED] wrote:
> Hello,
>
> Does MySQL Support Distributed Database.
No. It "only" supports replication.
> If not, then what's the way out?
Depends on your needs. Describe them and someone might know an answer.
Bye,
Benjamin.
Hi.
You know, mysql_insert_id returns a 64 bit integer (see
http://www.mysql.com/doc/m/y/mysql_insert_id.html)? Though, ignoring
this, you should normally get a steady 0 returned.
Another possible cause of failure could be that you did not recompile
your application and therefore have a version
Hi.
On Mon, Oct 01, 2001 at 10:04:50AM +0200, [EMAIL PROTECTED] wrote:
>
> how can i link three tables with joins on one table?
>
> Select
> b.IdentNrA,b.Menge,b.Preis,b.ArtPosition,c.Artikel_Status,d.beschTitel,e.Str
> asse,e.PLZ,e.Stadt,e.Land
> From
> Bestellungen_Status_Text f right join (B
I have a batch file called mysql.txt containing the single line,
select "test \n test";
My command for running this file is:
mysql -N -B stud < mysql.txt > out.txt
After running the command, out.txt contains "test \n test" -- with the
"\n" appearing literally, instead of a newline character. I
Hi All,
I m trying to install mysql on linux machine from binary file.After performing
all the steps given in documents for installation , when i try to change the passwd
using "mysqladmin" , it gives the error..
error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock
On Tue, 02 Oct 2001 14:37, Paul DuBois wrote:
> At 10:45 AM +1200 10/2/01, marcus davy wrote:
> >On Mon, 01 Oct 2001 14:44, Paul DuBois wrote:
> >> At 11:44 AM +1200 10/1/01, marcus davy wrote:
> >> >If you specify the keyword IGNORE in an INSERT, any rows that
> >> > duplicate an existing PRIM
At 12:23 PM +1000 10/2/01, Bruce Collins wrote:
>Hello,
>I have a mySQL database with a large table of
>athletic performances where every athlete has
>a row for every performance. My problem is to
>make a column which is a sequential count of
>each athlete's performances. The table is in
>chronolo
Hi there,
I have a many-to-many relationship:
ind table
-
id = 4, name = Joe
id = 5, name = Jane
bus_ctr table
-
id = 1, name = downtown mall
id = 2, name = sunshine mall
id = 3, name = express shop
mm_ind_bus_ctr table (many to many association table)
>Description:
Install Script did not create mysqladmin
>How-To-Repeat:
>Fix:
>Submitter-Id:
>Originator:root
>Organization:
>MySQL support: [none | licence | email support | extended email support ]
>Synopsis:
>Severity:
>Priority:
>Category:
Hi,
When I try and use the REPLACE function such as:
REPLACE INTO table1 SELECT table2.ID, table2.Modified FROM table1 INNER JOIN table2 ON
table1.Company=table2.Company;
I get:
ERROR 1066: Not unique table/alias: 'table1'
Here is the description of both tables:
mysql> describe table1;
+---
At 10:45 AM +1200 10/2/01, marcus davy wrote:
>On Mon, 01 Oct 2001 14:44, Paul DuBois wrote:
>> At 11:44 AM +1200 10/1/01, marcus davy wrote:
>> >If you specify the keyword IGNORE in an INSERT, any rows that duplicate
>> >an existing PRIMARY or UNIQUE key in the table are ignored and are not
>>
Hello,
I have a mySQL database with a large table of
athletic performances where every athlete has
a row for every performance. My problem is to
make a column which is a sequential count of
each athlete's performances. The table is in
chronological order. Have been trying with PHP
but I am very mu
> What is required to be installed on webserver (redhat linux i686) as far
as
> msql client , C++ , compiler ,mysql header files , and mysql client
library
If you are talking about development in C with MySQL, you will need
MySQL-client, MySQL-devel, MySQL-shared. As for C++ I think there is a
My
Hi,
I have data on more than 1 database with same schema. How could I use SQL
statement to retrieve it for display in 1 time? Pls describe with PHP code.
thanks
SF
-
Before posting, please check:
http://www.mysql.
Sometimes mysqld gets signal 11 (segmentation fault), it crashes, and
safe_mysqld restarts it, anyways I cannot get it to generate a core dump
file. I am using FreeBSD 4.2. Any ideas?
---
Spinlock
Creator of EmpireQuest
http://www.empirequest.com
---
I don't know anything about MySQL, Ive just been trying(with no luck)to
install a forum(Snitz forum from www.snitz.com) on my website. My website is
Linux/MySQL/Chilisoft! Im running out of support my host hasn't gotten back
with me, and Snitz support doesn't know. So I got to messing around w
From: <[EMAIL PROTECTED]>
> MySQL said: You have an error in your SQL syntax near 'order by
> 'Variable_name' ASC' at line 1
>
> Any ideas as to what this means, and how to fix it?
Hi Dave,
How 'bout sending us the entire SQL statement, please.
---
Rodney Broom
Programmer: Desert.Net
-
Hi,
MySQL said: You have an error in your SQL syntax near 'order by
'Variable_name' ASC' at line 1
Any ideas as to what this means, and how to fix it?
Thanks, Dave
-
Before posting, please check:
http://www.mysql.com/manu
I have written some ISAPI filters and extensions that use the MySQL C
API. By using the MySQL C API, you don't need to install MyODBC, and your
data access will be a little faster, compared to MyODBC. The C API also is
extremely easy to use.
I have, however, found an apparent problem with th
On Mon, 01 Oct 2001 14:44, Paul DuBois wrote:
> At 11:44 AM +1200 10/1/01, marcus davy wrote:
> >If you specify the keyword IGNORE in an INSERT, any rows that duplicate
> >an existing PRIMARY or UNIQUE key in the table are ignored and are not
> >inserted.
> >But the last_insert_id() function still
I was using gcc not g++
---
Spinlock
Creator of EmpireQuest
http://www.empirequest.com
On Mon, 1 Oct 2001, Brian Reichert wrote:
> On Thu, Sep 27, 2001 at 07:19:02PM -0600, Spinlock wrote:
> > Hello. I am running mySQL 3.23.42 on FreeBSD 4.2.
> >
> > I have compiled it with InnoDB and
On Thu, Sep 27, 2001 at 07:19:02PM -0600, Spinlock wrote:
> Hello. I am running mySQL 3.23.42 on FreeBSD 4.2.
>
> I have compiled it with InnoDB and full debug to help figure out why it
> keeps crashing. I've done a few core dumps and I'll paste 3 of them, it
> keeps on crashing in the same funct
Hi,
I have an application written in MS Access 2000 which has linked tables from
a MYSQL database.
I'm having a problem running queries which update the linked tables. I can
update individual records ok from Access, but as soon as i tried to run a
query, the query failes saying X number of recor
I want to start logging all queries on a mySQL server, but it is already
running. I would prefer not to shut it down, but if I have to, then I am not
sure how to start it up again without binding it to my logged-in self, so
that when I log out of the system, the program doesn't stop. Is there anyw
I'm trying to remove rows from one table where a column matches another
column in a seperate table..
I have mysql 3.22.32:
DELETE TemporaryUsers_ToMessWith.* FROM TemporaryUsers_ToMessWith,
Advantage_Backup WHERE Advantage_Backup.TempAccountNumber =
TemporaryUsers_ToMessWith.TempAccountNumber AN
Could someone explain to me how/when mysql uses temp files.. running a
new dedicated db server with twice as much ram as the old one, and the
new one keeps dumping 400+mb data into a temp file when the database is
searched, both with LIKE and MATCH/AGAINST statements... i have never
looked to see
At 2001-10-01T17:31:46Z, "Lou DAmbrosio" <[EMAIL PROTECTED]> writes:
> What is required to be installed on webserver (redhat linux i686) as far
> as msql client , C++ , compiler ,mysql header files , and mysql client
> library
To do what?
--
Kirk Strauser
Internet Software Engineer
NMotion, In
I've been scouting around for hosts that offer both W2k/NT support as well
as mySQL, but I haven't been able round up one! is there a good reason for
this? It seems to me that the hosting public is just not educated that mySQL
even can run on NT.
Thoughts?
Dave Carter
Chief Web Architect
Acceler
With basedir and datadir=/var/lib/mysql the error is:
011001 16:16:42 /usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13)
With basedir=/var/lib/mysql and datadir not set:
/usr/libexec/mysqld: Can't change dir to '/var/lib/mysql/var/' (Errcode: 2)
011001 16:18:23 Aborting
011001
Thank you so much! That worked.
*big sigh of relief*
Erica
> -Original Message-
> From: Carsten H. Pedersen [mailto:[EMAIL PROTECTED]]
> Sent: Monday, October 01, 2001 12:48 PM
> To: Erica Douglass
> Subject: RE: User Permissions Issue (Easy questions?)
>
>
> > Hi,
> >
> > I am wor
Look in the contrib section of the website. There are scripts for
exporting Access databases to mysql.
Curtis
On Mon, 1 Oct 2001 [EMAIL PROTECTED] wrote:
> On Mon, 1 Oct 2001, Andreas Schmidt wrote:
>
> > Hi List
> >
> > I want to migrate from a NT-Server to a Linux Server. Therefore I'm
> >
You probably want a unique index for those cols. Check out:
http://www.mysql.com/doc/C/R/CREATE_TABLE.html (search for unique in page)
and
http://www.mysql.com/doc/C/R/CREATE_INDEX.html
-Joe
> -Original Message-
> From: Robert Martin [mailto:[EMAIL PROTECTED]]
> Sent: Monday, October
grant alter, create, delete, drop, insert, select, update, index ON
name_of_database.* to name_of_database TO username@localhost identified by
"password" with grant option;
then
grant alter, create, delete, drop, insert, select, update, index ON
name_of_database.* to name_of_database TO userna
Robert Martin wrote:
> Hi,
>
> I?m still learning sql so I hope this doesn?t sound to basic.
>
> I would like to find out if there is a way to insert a record only when (X and Y) do
>not exist.
> I have the value to check against stored in a variable.
ALTER TABLE table ADD UNIQUE u_xy_idx ( x,
Hi,
Im still learning sql so I hope this doesnt sound to basic.
I would like to find out if there is a way to insert a record only when (X and Y) do
not exist.
I have the value to check against stored in a variable.
My table looks like the following:
ID | X | Y
-
1 | 10
Hi,
Im still learning sql so I hope this doesnt sound to basic.
I would like to find out if there is a way to insert a record only when (X and Y) do
not exist.
I have the value to check against stored in a variable.
My table looks like the following:
ID | X | Y
-
1 | 10
Hi,
I am working with an internal database. We add a user using the
following statements:
create database name_of_database;
GRANT alter, create, delete, drop, insert, select, update, index ON
name_of_database TO username@localhost identified by "password" with
grant option;
GRANT alter, create
At 14:18 01/10/2001 -0400, melissa allman wrote:
Hi,
If you link the MySQL table using MyODBC you can build an Append
Query on Access which inform you the number of rows from the
record set and at the end the number of rows which had successfully
processed.
If you want to avoid duplication of reco
Roger writes:
> Hi,
> Anyone know how to use MySQL in
> an ISAPI (Borland Delphi 5 Web Broker technology, or genl ISAPI)
> application?
I don't have any experience with ISAPI, but as far as I know
the major point is that your programs have to be thread safe
and use a thread safe version of the
You can use the same basic way as if you where using M$ or IB using the
MyODBC or ?
I use ASTA and connect through that way. If you need more let me know I'll
try and help you out.
M;)
> Hi,
> Anyone know how to use MySQL in
> an ISAPI (Borland Delphi 5 Web Broker technology, or genl ISAPI)
> a
fi-claudemir writes:
> I 'm trying to use a sub-select to delete the lines that are in the
> table2 but are not in the table1
> but I didn't get it.
If you had bothered to read the manual you would've known
that subselects aren't implemented yet, and there's no way
to specify more than one tab
Hi,
Anyone know how to use MySQL in
an ISAPI (Borland Delphi 5 Web Broker technology, or genl ISAPI)
application?
Thanks,
Roger
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.my
Hi,
I have done the following
$./bin/mysql -uroot mysql
Reading table information for completion of table and
column names
You can turn off this feature to get a quicker startup
with -A
Welcome to the MySQL monitor. Commands end with ; or
\g.
Your MySQL connection id is 12 to server version
Hi People,
I'm new to this list, so forgive me if I sound like a newbie. Anyhow, here's
my issue...
I have a script that notifies me when there are mySQL errors in one of my
PHP scripts. Today I just got an error saying that "MySQL server was gone."
I checked it out and noticed that it was still
Hi,
I am working on a project that involves using a form to populate a MYSQL
table.
I then need to transfer these records to an Access database. I want to have a
flag on the MYSQL table to indicate that the record was successfully sent to
Access.
It could be an on/off or Y/N value. I am trying
Hi
I'working with two tables (table1 and table2).
I 'm trying to use a sub-select to delete the lines that are in the
table2 but are not in the table1
but I didn't get it.
Below the way I've tried:
DELETE FROM Table1 SELECT Table1.* FROM Table1 LEFT JOIN Table2 ON
Table1.ID=Table2.ID WHERE T
Awesome!!! Thanks u so much Deepanshu.
Yes we changed it to 755 and we can see all the pages in the browser and
also in the ftp software.
But i still cannot transfer files from my computer to the web directory. I
can overwrite the existing pages like index.html and can see the changes in
the web
I need some help,
I need to know how MySQL would handle different language character stes. In
particular, I need to know how MySQL would handle 2 Byte Characters. Does
this mean my VarChar (30) would only be able to hold 15 characters, or does
it understand that, and automatically adjust for it
>Description:
Setting basedir=/var/lib/mysql produces the error message:
/usr/libexec/mysqld: Can't change dir to '/var/lib/mysql/var/' (Errcode: 2)
with datadir not set to anything
Setting datadir=/var/lib/mysql produces the error message:
011001 13:32:27 /usr/libexec/m
Hi list members:
What is required to be installed on webserver (redhat linux i686) as far as
msql client , C++ , compiler ,mysql header files , and mysql client library
.
Any help would be greatly appreciated.
THANKS
LOUIE
-
B
This helps you convert the data to a MySQL database (a much faster and more
robust datastore than JET).
If you need to access the data from both platforms, including existing
Access applications, install MyODBC on NT, create a suitable ODBC DSN and,
then, in Access, use File > Get External Data
Can the administrator grant me rights to transfer files to a specific folder
and if yes how do i do it?
Also earlier i could view the default index.html page through the web now i
get the error messgae Forbidden
You don't have permission to access / on this server.
What am i missing. I am very
Hi list members,
I've just downloaded and installed MySQL 3.23.XX for an HPUX 11.00. Every
time I try connect to it I must insert a record in the table user for the PC
(host) in which I'm trying the connection.
Is there any way to avoid this and allow any user on any host to connect ?
Thanks
Ing.
Dave Lake wrote:
>
> Hi Folks
>
> I have used MySQL for some time and am just getting my head around PHP. I
> looked across a number of PHP sites for some input on this but failing to
> find an answer thought I would ask some MySQL users (surely many of you are
> using PHP right? ;-) ) for help.
Hello list members,
I am running mysql on a linux server. I can connect to it using telnet and
also using mysql client. I am given all the permissions. I am trying to
create a few php pages and want to ftp them to the linux server . I am using
WS_FTP. i can view the folder where i need to put th
"Srinivasa T.N." <[EMAIL PROTECTED]> writes:
> Well, if I use the SQL statements specific to MySQL in my application,
> then won't I loose portability??
For the most part - there are certain tricks you can try, which takes
advantage of text which looks like comments to other databases.
If you w
On Mon, 1 Oct 2001, Andreas Schmidt wrote:
> Hi List
>
> I want to migrate from a NT-Server to a Linux Server. Therefore I'm
> looking
> for a solution to run my existing MS-Access-Databases under MySQL. Is
> there a chance to point from a MySQL-DB to a MS-Access-DB in order that
> my data can st
Hi List
I want to migrate from a NT-Server to a Linux Server. Therefore I'm
looking
for a solution to run my existing MS-Access-Databases under MySQL. Is
there a chance to point from a MySQL-DB to a MS-Access-DB in order that
my data can stay within the MS-Access-DB?
Andi
-
Hello!
I am looking for a free-ware data-mining package, preferably one that
would be somehow geared-up for use with MySQL.
I must say, I am more interested in scientific data-mining rather than
business applications, so perhaps something too focused on sales
etc. won't do.
If there is no fr
Hello mysql,
Could anyone tell me if heap tables are cyrrently working with
replication.
As I remember some time ago you might get problems then server
restarts (so empty it's heap tables) there fore slave does not and
so it gets dublicate key errors on inserts to this tables, which is
Hi everybody: here is a new version of moodss.
Check it out! (or at least the screenshots at
http://jfontain.free.fr/moodss3.gif or
http://jfontain.free.fr/moodss4.gif :).
### CHANGES ###
--- version 14.6 ---
in threshold alert email message, it is now possible to attach the
screenshot of
Hello,
Does MySQL Support Distributed Database .If not, then what's the way out ?
Manish Mehta
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the lis
Hello
Firstly, this is my first query, so I can only hope I have sent it to the
correct list!
I am using the C API for MySQL, and using the mysql_insert_id() function to
get the last id assigned in an AUTO INCREMENT column. Orignially I was using
3.22.32 and everything worked fine. Upon upgradin
Hi Srinivas !!!
> -Original Message-
> From: Srinivasa T.N. [mailto:[EMAIL PROTECTED]]
> Sent: Monday, October 01, 2001 12:56 AM
> To: [EMAIL PROTECTED]
> Cc: [EMAIL PROTECTED]
> Subject: Re: unixODBC..
>
>
> Well, if I use the SQL statements specific to MySQL in my application,
> then wo
Hallo,
how can i link three tables with joins on one table?
Select
b.IdentNrA,b.Menge,b.Preis,b.ArtPosition,c.Artikel_Status,d.beschTitel,e.Str
asse,e.PLZ,e.Stadt,e.Land
From
Bestellungen_Status_Text f right join (BestellungenAdr e inner join
Bestellungen a using(IdentNrS)) using (BestellStatus)
Hi.
On Mon, Oct 01, 2001 at 12:30:10AM -0400, [EMAIL PROTECTED] wrote:
> Paul DuBois> INSERT IGNORE can't fully assess whether the record is to be
> ignored
> Paul DuBois> until the record's contents have been generated.
>
> And why can't it wait until after the ignore/don't ignore assessment be
Well, if I use the SQL statements specific to MySQL in my application,
then won't I loose portability??
Seenu.
Venu wrote:
>You can execute any valid SQL statements through SQLExecDirect API. Please
>check the MySQL document, http://www.mysql.com/documentation/index.html,
>which can guide you
93 matches
Mail list logo
