A bit long, but consulting docs DuBois aren't yielding solutions apparant
to me...
I'm converting a database where valuelists were controlled with a custom
routine that read values from a text file. Selections of a specific
valuelist were saved to a single field in the database, and each
Hi!
You may want to try out Intel's C++ compiler for Linux if you are using
an
ix86 CPU. We used it here at work and it resulted in code that ran more
than
twice as fast, though we have never tried it with MySQL.
I wonder whether Intel's C++ compiler accept those flags. Are those flags
Hi Ken,
Here are the values:
kern.maxfiles: 24616
kern.maxfilesperproc: 22154
They are slightly less than 25716, is there any way to check if this upper
limit becoming reached sometimes?
Now there are question about innodb tables and 4.0.1.
1. What can be gained by switching to innodb inside
hi everybody,
I have an OpenBSD 3.0 box running MySQL here, in my opinion setup correctly
and everything runs smooth. now I have the challenge to migrate an m$Access
based application called WinCard to play correctly with MySQL. the problem
is, that it is not possible to enter new records from
Hi,
mmh, maybe it's not a mysql-problem...
Yes, I read through the numerous threads about this topic but I can't
solve my problem
After compiling php-4.1.1 with mysql support (mysql-3.23.47) as a DSO
(./configure --enable-libgcc --with-mysql=/opt/mysql-3.23.47
Hi, all mysql team
As we know, use safe_mysqld or mysql.server
we can startup Mysql instance.
But how can i know when all the mysqld daemons
really startup except use command ps?
Thanks in advance.
Robert Li
Computer Associates
Hello
how to install mysql client only to connect server
in windowsNt and Linux
right now i'am working in server
please mail to
[EMAIL PROTECTED]
_
Join the worlds largest e-mail service with MSN Hotmail.
http://www.hotmail.com
Robert,
`mysqladmin ping` will print mysqld is alive if the server is running,
or error message in any other case.
Peter
On Wed, 20 Feb 2002, Li, Robert wrote:
Hi, all mysql team
As we know, use safe_mysqld or mysql.server
we can startup Mysql instance.
But how can i know when all the
Hi there,
I am using MySQL v3.23.40 on Windows NT. When creating various MyISAM
tables the files saved are of the form *.frm *.MYD and *.MYI. So far so
good. When I copy these files over to a Linux box though some of the
*.MYD and *.MYI extensions appear as lowercase *.myd and *.myi
This causes
On Wed, Feb 20, 2002 at 11:38:31AM +0100, [EMAIL PROTECTED] wrote:
sql,query
The above is for antispam filter.
I have a need for an interval data type. It would contain start and end
of a certain time event. Since it is not possible to have two different
events at the same place and at the
I maintain 3 machines running MySQL.
Machine 1: Redhat 6.2 (Pentium 133, 40 megs, 1.5 gig)
An attempt to upgrade the server from version 3.23.46 to 3.23.49 via rpm
upgrade generated no errors or warnings but the resulting mysqld server
crashed. Reinstallation of an earlier version was required
You may simply copy or move logrotate from /etc/cron.daily in /etc/cron.hourly.
Logrotate will then be executed hourly, have a look into /etc/logrotate.conf,
/etc/logrotate.d and determine which files are due to be rotated. But as you cannot
set other delays but daily,weekly,monthly (see man
root writes:
Description:
When i execute the following query on my database:
SELECT retaillastdone_.* FROM retaillastdone_ WHERE
(retaillastdone_.source_=mercury AND retaillastdone_.timestamp_ BETWEEN
97864920 AND 978735599099) ORDER BY
[EMAIL PROTECTED] writes:
Description:
When I run a ./configure --prefix=/usr/local/mysql --with-libwrap the configure
completes but the make fails.
Making all in sql
make[2]: Entering directory `/usr/local/src/mysql-3.23.49/sql'
Making all in share
make[3]: Entering directory
Description:
A standard test fails. This is on PowerPC 64-bit Linux which
is very new and we have only just finished with glibc as
64-bit. Thus, the syscalls, glibc and the compiler itself are
all suspect -- so I don't expect anyone can really track this
Hi all, I have a thorny problem and I hope this is the right place, I've been
everywhere else I could think of. I have limited skills in this area.
I have a site with content management run by mysql/php (just to be original), using
two databases on the same machine. db1 is the working copy for
Hi!
I need to SELECT some rows using a lengthy WHERE-clause and then to UPDATE these rows
just to set a flag. What is the best way to do this (performance-wise)? Being able to
do that in one single query would be great because otherwise I had to use transactions
to be sure to match _exactly_
Good Morning Alexander!
Looks like you have tuned your system pretty well.
They are slightly less than 25716, is there any way to check if this
upper
limit becoming reached sometimes?
sysctl kern.openfiles will tell you how many are open now but there is
no way to know if the upper limit is
Hello I have a query that goes through and gets the
data out of three tables without a problems. Now the
task at hand is to compair that out put against three
identiacal tables not displaying any duplicate date.
Tables:
a
a.aocode , a.CaseNo , a.CaseName
b.
b.ao_code , b.initials
c
Hi there,
I was following the instructions to compile the latest version of mysql
for Mac OS X, when I ran into a few errors.
I downloaded the source file as per the instructions from Apple
(http://developer.apple.com/internet/macosx/osdb.html), and then
followed the instructions on mysql
Hi, i have a table like this
Key Field-1
A string1
A string2
A string3
B string1
B string 2
I want to create a query to get the following result (only one line by key
field):
A - string1,string2,string3
B - string1,string2
I try to use the Sum function but
- Original Message -
From: Javier [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, February 20, 2002 2:47 PM
Subject: Sum function question
Hi, i have a table like this
Key Field-1
A string1
A string2
A string3
B string1
B string 2
I
On Wednesday 20 February 2002 09:20, Web boy wrote:
You want to use UNION. If I remember correctly its a fairly new feature for
MySQL, but its a standard SQL thing. From the manual:
SELECT ...
UNION [ALL]
SELECT ...
[UNION
SELECT ...]
UNION is implemented in MySQL 4.0.0.
UNION is used
Hi list,
Where can I find an online tutorial / example on how to use the C API
for mysql?
TIA
George
(mysql, query, sql)
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
Hi all,
I am trying to put together an inventory management system for my company
an I was thinking to do it using mysql for the database, Red Hat Linux with
apache for the server.
I opted for a web like environment for this project because there are so
many different computers that need to
No reason, you have the right idea especially if you are dealing with
multiple platforms
-Original Message-
From: Cip [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 20, 2002 8:54 AM
To: [EMAIL PROTECTED]
Subject: Inventory management system based on mysql
Hi all,
I am trying to
Do you have also recompiled apache after compiling php ?
Am Mit, 2002-02-20 um 10.04 schrieb Andre Konopka:
Hi,
mmh, maybe it's not a mysql-problem...
Yes, I read through the numerous threads about this topic but I can't
solve my problem
After compiling php-4.1.1 with mysql support
Below is two scripts. The first one connects fine. The second gives the
following error.
Parse error: parse error in /usr/www/users/abc/connect.php on line 1
What is the problem with the second script? Thanks in advance - Craig
#1 - Works
---
HTML
HEAD
TITLE
The two passwords in the connections are different perhaps???
- Original Message -
From: Craig Westerman [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, February 20, 2002 3:24 PM
Subject: Connect question
Below is two scripts. The first one connects fine. The second gives the
Why bother with the line :
if ($dbcnx != FALSE)
When you could use :
if (!$dbcnz) . ?
- Original Message -
From: Craig Westerman [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, February 20, 2002 3:24 PM
Subject: Connect question
Below is two scripts. The first
I am trying to run multiple versions of MySQL (not simultaneously) on my
Windows box.
One is NuSphere's 3.23.44 with Gemini tables and the other is Max 3.23.49.
Do I only need to put the base files into two separate directories and then
modify the my.ini to point to the version I want to use
Now I can not open my all databases. The error following:
[root@linuxserver /root] # mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with;or \g.
Your MySQL connection id is 1 to server version: 3.22.32
Type 'help' for help.
mysql use mysql;
ERROR 1044: Access denied
Exactly what the error message says. In other words you do not have the
correct permissions to access the mysql database.
- Original Message -
From: bc203 [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, February 20, 2002 3:31 PM
Subject: What is error code 1044 ?
Now I can
shashidhara,
Wednesday, February 20, 2002, 11:51:59 AM, you wrote:
sn Hello
sn how to install mysql client only to connect server
sn in windowsNt and Linux
sn right now i'am working in server
sn please mail to
sn [EMAIL PROTECTED]
You can use a standart client program for Linux
George,
Wednesday, February 20, 2002, 4:51:32 PM, you wrote:
GL Hi list,
GL Where can I find an online tutorial / example on how to use the C API
GL for mysql?
Look in MySQL online documentation about C API:
http://www.mysql.com/doc/C/C/C.html
GL George
GL (mysql, query, sql)
--
Tim,
Tuesday, February 19, 2002, 9:57:07 PM, you wrote:
TW Hopefully someone out there can help me as I haven't been able to find any
TW documentation on this that applies.
TW I am running MySQL version 3.22.32 on a FreeBSD v4.4 machine. I am getting
TW Error 2013: Lost connection to MySQL
Bob,
Wednesday, February 20, 2002, 2:01:12 AM, you wrote:
BR I seem to have forgotten how to get into MySQL and work.
BR (It's been a while but I'm starting up again. I get these
BR errors: bob@sfpetard:~ mysqladmin create library
BR mysqladmin: CREATE DATABASE failed; error: 'Access denied
Why?
Victoria Reznichenko wrote:
Vincent,
Sunday, February 17, 2002, 9:49:55 PM, you wrote:
VS Hello,
VS according to the docs:
VSFor the moment, GRANT only supports host, table, database, and column names
up to 60
VS characters long.
VS A user name can be up to 16 characters.
Thanks, I will have a look at the official site. Is anybody aware of a
non-oficial site that contains an example with a real db as backend.
(With real db I mean tables with a few thousand+ records per table and
advanced queries with multiple joins) and then how one can optimise the
c code to run
Had a similar problem a few years back. System worked fine for a number
of months then started crashing whenever I recompiled the kernel. Turned
out to be a defective secondary cache (yes it was a Pentium and yes it
was a number of years ago). Showed up only under heavy cpu load. Try
Hello,
I am new with MySQL and have it running on Windws 2000 server and
programming with VC++ 6.0
Now converting from SQL 7.0 to MySQL
I wonder if there is a way to print out the data structure of the table in
MySQL?
Regards
Theo van Stratum
Albanet Ltd
(Technical Manager, Senior Programmer)
Scalper,
Wednesday, February 20, 2002, 5:28:41 PM, you wrote:
S I am trying to run multiple versions of MySQL (not simultaneously) on my
S Windows box.
S One is NuSphere's 3.23.44 with Gemini tables and the other is Max 3.23.49.
S Do I only need to put the base files into two separate
bc203,
Wednesday, February 20, 2002, 5:31:03 PM, you wrote:
b Now I can not open my all databases. The error following:
b [root@linuxserver /root] # mysql -u root -p
b Enter password:
b Welcome to the MySQL monitor. Commands end with;or \g.
b Your MySQL connection id is 1 to server version:
mysql,query
Hi , is there any way of performing something like the below statement?
select * from table1,table2 where table1.column1 like table2.column2
thanks in advance
Rich
-
Before posting, please check:
Hi,
I am trying to extract blob data from a query using the C API functions
(actually I am using Delphi). I understand the structure of the result set
and need to know the length of the blob field to extract it.
As far as I can tell the only way to find the length of the fields is by
using the
Hello sir,
I am finding Problem with connecting JSP and mysql,
it gives no error as well as exception,no output is coming out.
please help me in this problem
anticipating quick response
Thanking you!
subodh
-
Before
to create a second instance of the same table
and this will probably show the relationship twice
SELECT p1.lname, p1.fname, p2.lname, p2.fname FROM members AS 'p1' LEFT JOIN
members AS 'p2' ON p1.engagedto = p2.id
not sure if you can do the LEFT JOIN table AS 'table2' or not, can't get to
Looking through the MySQL stuff online, I still can't come up with a
statement to pull data from one table based on data from another.
Table1 Contains:
orderid
Table2 Contains:
orderid
otherfield1
otherfield2
I want to get the data from table 2 based on a matching orderid first pulled
from
Hello
I'm new to MySQL, Unix and Replication.
I would like to know if in a scenario where I have one master and
several slaves I can convert one of the slaves to master in the event
my master goes down. Once I can bring the master back up, how to I
reverse the operation? Does any one know how to
SELECT Table1.orderid, Table2.otherfield1, Table2.otherfield2
FROM Table1, Table2
WHERE Table1.orderid = Table2.orderid;
--Greg Johnson
-Original Message-
From: SpyProductions Support Team [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 20, 2002 12:31 PM
To: [EMAIL PROTECTED]
Description:
problem with test rpl15, FreeBSD 4.0, gcc version 2.95.2 19991024
How-To-Repeat:
Fix:
Submitter-Id: [EMAIL PROTECTED]
Originator:Gestore minimo
Organization:
MySQL support: [none ]
Synopsis: Don't know how much this affect the general
Richard Shade
Systems Administrator
(936)559-2280
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 20, 2002 11:39 AM
To: Shade, Richard
Subject: Re: MYSQL HELP
Your message cannot be posted because it appears to be either spam or
On Mon, 18 Feb 2002, David Steinbrunner wrote:
[EMAIL PROTECTED] wrote:
Good, Free Mac GUI to mySQL?
The only free GUI client for mySQL for the Mac that I know of would be
CocoaSQL: http://homepage.mac.com/mxcantor/ which is only for Mac OS X.
GNUe Forms and Designer have recently started
Description:
When I try to run, I get the following output:
bin/safe_mysqld --user=mysql
410
# ./bin/my_print_defaults: syntax error at line 1: `(' unexpected
How-To-Repeat:
I used gtar to untar the binary Solaris 8 version. I get the error eny time I
try and start mysql.
Fix:
Richard,
Does anyone know what is wrong with this syntax...
Select H.FinishCode, L.RowID
From CallHistory As H, BD2.CallList As L
Where (H.CallTime in(Select MAX(CallTime) From CallHistory Where H.RowID =
L.RowID)
AND H.RowID = L.RowID);
Sub-selects not (yet) permitted by MySQL (RTFM:
Hi,
I wonder if anyone can offer me some advice with this one:
I have a table called 'iq_data' holding just a primary key and a field
called 'iq_data'.
+++--+-+-++
| Field | Type | Null | Key | Default | Extra |
use LAST_INSERT_ID() to get the last inserted id
http://www.mysql.com/doc/G/e/Getting_unique_ID.html
and
'The most recently generated ID is maintained in the server on a
per-connection basis. It will not be changed by another client. It will not
even be changed if you update another
SELECT LAST_INSERT_ID() will return the last auto_increment key written. This value
is connection-specific, so that inserts performed on other connections will not affect
it (in other words, you'll get the last key generated by user 1, regardless of what
user 2 does in the meantime).
--Greg
Hi,
I think you can try to use REPLACE INTO table (a,b,c,d) SELECT e,f,g,h FROM
table2 WHERE field=what_you_want.
Best Regards,
Jocelyn Fournier
Presence-PC
- Original Message -
From: Felix Richter [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, February 20, 2002 3:01 PM
How would you use a temporary table? Is that the most efficient way?
David
-Original Message-
From: DL Neil [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 20, 2002 11:03 AM
To: Shade, Richard; [EMAIL PROTECTED]
Subject: Re: MYSQL HELP
Richard,
Does anyone know what is wrong
Hello,
I am having a difficult time figuring out how to get a certain specific
result from the database .
Example tables:
table1
ID|name
---
1 |15
2 |25
3 |50
table2
ID|code
---
1 |1
2 |2
3 |2
My query
select * from table1,table2 WHERE table1.ID = table2.code
The current query
From: [EMAIL PROTECTED]
My query
select * from table1,table2 WHERE table1.ID = table2.code
Query results
1 2 2
Desired results
1 2
Try:
SELECT * FROM table1,table2
WHERE table1.ID = table2.code
GROUP BY table2.code
You'll find this someplace in:
MySQL(mysql-server-3.23.36-1) is working find now, but I need upgrade to
MySQL-4.0.0-2.i386.rpm and this error appears.
[root@switch newrad]# rpm -Uvh MySQL-4.0.0-2.i386.rpm
error: failed dependencies :
MySQL-server conflicts with mysql-server-3.23.36-1
libmysqlclient.so.10 is
MySQL(mysql-server-3.23.36-1) is working find now, but I need upgrade to
MySQL-4.0.0-2.i386.rpm and this error appears.
[root@switch newrad]# rpm -Uvh MySQL-4.0.0-2.i386.rpm
error: failed dependencies :
MySQL-server conflicts with mysql-server-3.23.36-1
libmysqlclient.so.10 is
On Wednesday 20 February 2002 02:06, Anvar Hussain K.M. wrote:
Hello,
I don't feel the the table sizet will be a problem. But how would the
database function with such a huge number of queries per second.
If I read right, you will be taking a maximum (presently) of 42 channals
each taking
On Wednesday 20 February 2002 05:51, Sasa Babic wrote:
On Wed, Feb 20, 2002 at 11:38:31AM +0100, [EMAIL PROTECTED] wrote:
sql,query
The above is for antispam filter.
I have a need for an interval data type. It would contain start and end
of a certain time event. Since it is not possible
Hello,
Have a look at :
http://www.compagnie.com/stef/solution1.jpg
http://www.compagnie.com/stef/solution2.jpg
I'm searching for a solution to change a high traffic mysql server with a
distributed system.
1)Is the solution 1 is good for a writing + reading access ? Are there
problems with
Hi,
On Wed, 2002-02-20 at 14:44, SplitSlim wrote:
I need some help, this is a mission critical server and it has
CRASHED!
Details:FreeBSD on INTEL, MySQL v3.23.36 (FreeBSD Port)
020219 22:52:01 mysqld restarted
mysqld got signal 11;
The manual section 'Debugging a MySQL server' tells you
Hello,
I searched the manual but it seems like MySQL does not support ANSI SQL
CHECK constraints. These are often used to check that rows inserted into
tables meet specified criteria. For example table T created as follows
CREATE TABLE T (
X INT,
CHECK (X = 10)
);
has a check constraint
Hi Andre,
On Wed, 2002-02-20 at 19:04, Andre Konopka wrote:
mmh, maybe it's not a mysql-problem...
Indeed, doesn't look like it.
Yes, I read through the numerous threads about this topic but I can't
solve my problem
After compiling php-4.1.1 with mysql support (mysql-3.23.47) as a DSO
David,
How would you use a temporary table? Is that the most efficient way?
Use SELECT INTO temp_tbl to replace the sub-select clause.
Rewrite the existing SELECT into a join with the temp_tbl.
Is there another way?
=dn
Richard,
Does anyone know what is wrong with this syntax...
Just a trivial question.
How does dual locations work?
I am based in our Brisbane Australia office and am using MySQL as a backend
for a company Intranet. Our parent company is based in Hayward, California
and has recently converted an old DOS based database over to MySQL. We are
both in the
Hi Neil,
On Wed, 2002-02-20 at 20:51, Neil Freeman wrote:
I am using MySQL v3.23.40 on Windows NT. When creating various MyISAM
tables the files saved are of the form *.frm *.MYD and *.MYI. So far so
good. When I copy these files over to a Linux box though some of the
*.MYD and *.MYI
his is my first post here so please excuse any irrelevancies.
I am trying to load a .csv file that contains 41943 Records of Data.
I am only able to load 20972 Records. (it seems to skip almost every-other
record).
The file, located @:
Hi, I am a new user of MYSQL, when I use JDBC to
connect MYSQL, I got exception:
SQLException: Server configuration denies access to
data source.
Could some one kindly help me ?
Thanks a lot.
Jeff Zhao
Here is my program, it is very simple
import java.sql.*;
public class LoadDriver
{
Hi there,
I'm having quite a bit of trouble with an application I'm writing on Linux,
using MySQL.
The database connectivity stuff works fine, all my queries return sane
results, etc, but I can't run the application under gdb.
When I try to connect to the database when under gdb, I get:
Access
Hi Neil,
On Thu, 2002-02-21 at 08:26, Neil Silvester wrote:
Just a trivial question.
How does dual locations work?
I am based in our Brisbane Australia office and am using MySQL as a backend
for a company Intranet. Our parent company is based in Hayward, California
and has recently
You can also try:
Select SUBSTRING( MAX( CONCAT(LPAD(calltime,6,'0'),finishcode) ), 7) AS
finishcode,
0+LEFT( MAX( CONCAT(LPAD(calltime,6,'0'),finishcode )), 6) AS calltime
From callhistory As H,calllist As L
where
H.rowid = L.rowid
group by H.rowid
This is from:
Hi,
On Thu, 2002-02-21 at 03:11, subodh kumar wrote:
I am finding Problem with connecting JSP and mysql,
it gives no error as well as exception,no output is coming out.
please help me in this problem
anticipating quick response
I don't mean to be negative, but considering you're basically
I have created a table in the mysql db, using phpmyadmin with the following
statement:
create table books
( isbn char(13) not null,author char(30),title(60),price float(4,2),primary
key(isbn));
which works fine and creates the table i need the problem comes when i try
to insert some values into
Everyone,
I experienced table deadlock on my MySQL server...my client program does a
Table Write lock before writing to it...but suddenly the computer
hangs-up...do, other client got stuck and waiting for the table to be free
for writing...
But as I know...only the thread who does locking can do
My guess. . .
I have seen this problem with other databases . . . don't know if it is
true for MySQL as well. Try to change to your field definition to
float(5,2) as it may be counting the (.) as part of your field size.
So if you number is xx.xx you will need 5,2. 4,2 would give you xx.x
Thanks Arjen,
seems like a bit of a fiddle but not a bad solution considering some of the
other options. Unfortunately I also need the row level locking of innodb
so it's not going to work in my case. This lead me to ponder, if this
sort of row level protection was added would it be at the
Dear sir,
I am using MySQL database
I just wanted to use transaction.so as per manual i
have to make table type as Innodb.
Then i had set Innodb startup options as follows
innodb_data_file_path = ibdata1:2000M;ibdata2:2000M
innodb_data_home_dir = c:\ibdata
set-variable =
Hope this makes sense
I'm seeing random hung reads() after a mysql insert that appears to be
related to a sig alarm race condition. The basic workflow of this program
is
while (1)
recvfrom() /* few hundred packets a sec */
parse packet
insert into sql
However, once per second a sig
Hi Nilesh,
On Thu, 2002-02-21 at 15:14, Nilesh Deshpande wrote:
I am using MySQL database
I just wanted to use transaction.so as per manual i
have to make table type as Innodb.
Then i had set Innodb startup options as follows
innodb_data_file_path = ibdata1:2000M;ibdata2:2000M
At 21:14 20/02/2002 -0800, Nilesh Deshpande wrote:
Hi!
Very strange the printed messages you sent.
What MySQL release version are you using ? I did the test with
your start InnoDB set with 3.23.48 and got:
c:\mysql\binmysqld-max --standalone --console
InnoDB: The first specified data file
At 21:14 20/02/2002 -0800, Nilesh Deshpande wrote:
Hi,
Now I assume that the text you sent is from our documentation.
For to build an InnoDB table:
mysql create table table_name (id int)type=innodb;
Query OK, 0 rows affected (0.14 sec)
Regards,
Miguel
Dear sir,
I am using MySQL database
I
Is there another way as I do not have that version of
MYSQL installed on my server?
THanks-
KCK
--- Tod Harter [EMAIL PROTECTED] wrote:
On Wednesday 20 February 2002 09:20, Web boy wrote:
You want to use UNION. If I remember correctly its a
fairly new feature for
MySQL, but its a standard
Hi,
Try this:
select * from table1,table2 where table1.column1 like
concat(table2.column2,'%');
Anvar.
At 04:57 PM 20/02/2002 +, you wrote:
mysql,query
Hi , is there any way of performing something like the below statement?
select * from table1,table2 where table1.column1 like
On Wed, Feb 06, 2002 at 10:02:02AM -0600, Todd Newbold wrote:
Hi everyone,
When using replicate-ignore-table in mysql, does filtering happen
before or after transmission from the master to the slave?
Is the directive on the slave? If so, that's where it happens.
--
Jeremy D. Zawodny,
Hi!
Its kind of a subtle point, but innodb's locking not only locks rows, it
locks the ABSENCE of rows. If I understand correctly this means that
something like:
BEGIN WORK
SELECT COUNT(*) FROM table WHERE starttime? AND endtime?
(check the count)
INSERT INTO table (if count is zero)
Hello everybody,
here is a strange thing that creates me nightmares ...
How-To-Repeat:
Stage 1 . Using a my SQL GUI :
Create a simple Table ...
create table FAKE (bidon integer)
Everything works fine ...
Stage 2. Using a C compiler and MyODBC3.51 Driver (actually I use Borland as
C
Wolfgang Pichler wrote:
Do you have also recompiled apache after compiling php ?
YES
Am Mit, 2002-02-20 um 10.04 schrieb Andre Konopka:
Hi,
mmh, maybe it's not a mysql-problem...
Yes, I read through the numerous threads about this topic but I can't
solve my problem
After
Yes, I read through the numerous threads about this topic but I can't
solve my problem
After compiling php-4.1.1 with mysql support (mysql-3.23.47) as a DSO
(./configure --enable-libgcc --with-mysql=/opt/mysql-3.23.47
--with-apxs=/opt/apache-1.3.23/bin/apxs)
apache complains with the
Hey all,
Just did a compile and install of v4.01 for multiprocessor Sparc. Server
has started, runs OK, have fiddled with privileges successfully...
Naturally, next step: I¹d like to test everything.
But now, I get a Segmentation Fault immediately at run-all-tests¹ script in
sql-bench.
Any
Oops,
the syntax is
SELECT ... FROM ... WHERE .. LOCK IN SHARE MODE;
Heikki
-Original Message-
From: Heikki Tuuri [EMAIL PROTECTED]
To: [EMAIL PROTECTED] [EMAIL PROTECTED]
Date: Thursday, February 21, 2002 9:27 AM
Subject: Re: Fake interval data type
Hi!
Its kind of a subtle point,
Hi,
-Original Message-
From: Fabrice Schleifer [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 20, 2002 11:31 PM
To: [EMAIL PROTECTED]
Subject: MyODBC Blocking Table for DROP request ?
Hello everybody,
here is a strange thing that creates me nightmares ...
How-To-Repeat:
98 matches
Mail list logo