Hi Bill,
It worked! Thanks so much for your help, and for your suggestions about
formatting queries. I haven't worked much with complicated queries, and
this was my first time posting to this list.
Thanks for the help!
-Lisi
At 05:11 AM 2/8/03 -0500, Bill Easton wrote:
Lisi,
First,
Ok, I've tried that but it gave me an error.
I have a more complex query that use more tables, and I need to specify
something like:
count(table_name.*)
... but here MySQL tells me that there is an error near this expression, so
I need to use instead:
count(table_name.a_column_name)
I would
Hi,
Dan Nelson schrieb:
In the last episode (Feb 12), Jeff Bearer said:
I've recently learned that Oracle has the ability to partition table
data, Oracle9i's list partitioning feature.
http://www.oracle.com/oramag/oracle/02-jan/index.html?o12part.html
I'm trying to find out if
One of my mysql databases has developed a tendancy to corrupt a table,
repairable by the repair table query, but it's both alarming and
inconvenient to have the database shut itself down.
this is the report from repair table:
| moonshotj.picture | repair | info | Wrong bytesec: 0-0-0 at
On Tue, 2003-02-11 at 15:39, Curtis Maurand wrote:
The manual suggests that the password function is really for intenal mysql
functions. Ideally you should use the encode or md5_encode functions.
update user set password=encode('password', 'salt') where user =
'your_user';
Unless
I am still stuck with my full text search engine. I have experemented
with
different approaches to seleting search results and figure out that
having temporary tables is about 300 times faster than doing 'inner
joins'
The table:
+---+--+--+-+-+---+
|
On Wednesday 12 February 2003 09:45, Octavian Rasnita wrote:
Can I create my own my.cnf file if I am not the administrator of MySQL but
I just have a database?
It's a global option, not a user specific option.
Ask your database administrator...
- Original Message -
From: Egor
On Wednesday 12 February 2003 01:50, misiek at pld dot org dot pl wrote:
Description:
Wrong translation of YES/NO for Polish language. They are swapped.
Same bug in mysql 4.0.10.
How-To-Repeat:
Look into sql/share/polish/errmsg.txt
Fix:
Here is patch that fixes
I have used dbScripter a lot for this kind of work. It is definitely NOT
necessary to own Access to use it.
One of its nice features is its database profiles. These function as data
and syntax translation tables. For example, if a column type doesn't exist
in the target, substitute another column
On Thu, Feb 13, 2003 at 03:04:08PM +0300, Artem Koutchine wrote:
homemade fulltext searchsystem
The query is:
SELECT DISTINCT w0.l_id FROM law_words as w0
inner join law_words as w1 on w0.l_id=w1.l_id
inner join law_words as w2 on w0.l_id=w2.l_id
inner join law_words as w3 on
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Arthur, et al --
...and then Arthur Fuller said...
%
% I have used dbScripter a lot for this kind of work. It is definitely NOT
% necessary to own Access to use it.
Cool! That's what I wanted to pin down. So if someone sends me an
Access .MDB
Hello friends!
The MySQL-4.0.9-gamma to windows supports sub select?
Ex.: select ... from ... where ... in (select.)
If not, has some version that supports it?
Thanks,
e.
_
MSN Hotmail, o maior webmail do Brasil.
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi, all --
I have a system info table:
bash-2.05a$ echo 'describe easyadmin.vsites;' | mysql ...
Field TypeNullKey Default Extra
sitenum int(11) PRI NULLauto_increment
host varchar(250)
Since DBScripter uses ODBC, you'll have to set up a Data Source in the ODBC
manager in Windows for any database you wish to access with the product.
For that you'll need an Access driver, but you can download that driver from
MS at no cost. It would be nice if DBScripter would be ported to LINUX
Try
select CONCAT(CONCAT(LTRIM(RTRIM(host)),'.'), LTRIM(RTRIM(domain))) from ...
The LTRIM and RTRIM will get rid of any white spaces you may have. If there
aren't any
then simply
select CONCAT(CONCAT(host,'.'), domain) from ...
---
Rob
**
Rob Cherry
mailto:[EMAIL
Why 2 CONCATs? Why not simply:
mysql -Be select CONCAT(host,'.',domain) from easyadmin.vsites where
adminuser=davidtg
Duncan
---
Duncan Salada
Titan Systems Corporation
301-925-3222 x375
-Original Message-
From: Rob [mailto:[EMAIL
Elby,
The MySQL-4.0.9-gamma to windows supports sub select?
Nope. Subselect are supported as of 4.1.
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
iConnect GmbH http://iConnect.de
Heesestr. 6, 12169 Berlin (Germany)
Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3
HI,
Thanks all for the suggestions given for load data... It indeed helped
me a lot.
Right now i am using J/connector version 3 .
Load data local works fine with version 3.
I hit a new problem. It works fine when there are below 2 records
in the file. When i tried wiht 4,00,000
I have an application which is being converted from access to mysql, and have
the need to create a second database under the mysql implementation. Is there
a way that i can create this second database via an ODBC object, or do I need
to at least specify the database be created as part of the
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Ahmed S K Anis wrote:
HI,
Thanks all for the suggestions given for load data... It indeed helped
me a lot.
Right now i am using J/connector version 3 .
Load data local works fine with version 3.
I hit a new problem. It works fine when
In the meantime, you can almost always perform the equivalent of a
sub-select using an inner join (and sometimes a temp table).
For example, a query to select all customers in the province of Ontario:
SELECT * FROM Customers
WHERE CityID IN( SELECT CityID FROM Cities WHERE ProvinceID = ON )
Can
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Dave --
...and then Christensen, Dave said...
%
% Since DBScripter uses ODBC, you'll have to set up a Data Source in the ODBC
% manager in Windows for any database you wish to access with the product.
Oh, I get it... ODBC means Windows. That
Hi all,
I was wondering if anyone could help me with this issue. I have a TEXT
field in my database, It contains HTML, when I edit the field through a web
browser it updates fine with no problems. But If I manually edit with
MySQL-Front or NaviCat and use the BLOB-TEXT editor It freezes up. I
I am having problems setting up replication between two 4.0.10
servers.
What I did so far:
- generate a dump of the current state of the server using
'mysqldump' (its a mix of mostly innodb tables and some MyISAM
tables)
- dropped all databases from the slave
- imported the dump into
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Duncan Rob, et al --
...and then Salada, Duncan said...
%
% Why 2 CONCATs? Why not simply:
%
% mysql -Be select CONCAT(host,'.',domain) from easyadmin.vsites where
% adminuser=davidtg
Hey, cool! That's *exactly* what I needed. Works perfectly.
Mark, Steff,
- Original Message -
From: Mark Matthews [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Wednesday, February 12, 2003 3:09 AM
Subject: Re: Transaction problems using InnoDB, not locked with LOCKTABLES
-BEGIN PGP SIGNED
I don't think it is possible at the moment, and pretty sure its not standard SQL but
it would still be neat to have
SELECT aField, COLUMN_IF( some_expression, 'afield2' AS 'aColumn' ) FROM aTable
So in this example, if the expression was true, include that column in the result set,
otherwise
Yes, it is sometimes hard to find functions because they tend to be lumped
into general categories with each page having a fair bit of functions listed
(e.g. http://www.mysql.com/doc/en/String_functions.html). The categories
are pretty good for separating them, but sometimes it's hard to tell
I believe the same is true of urSQL. However, you do need to set up an
ODBC data source and this requires the MS Access driver. The easiest way
to get the driver is to install MS Access, but I think it is possible to
install the driver without MS Access...
On Thu, 13 Feb 2003, Arthur Fuller
It's dead simple to create a MySQL database -- it's just a directory under
mysql\data. If you want to do it from Access, just determine where the
mysql\data directory is and then create the subdirectory.
Hth,
Arthur
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
:Putting
: links for each
: function under the categories might help with that. The
: links could go to
: the specific place on the big page (there would be no
: need for a separate
: page for each one). Of course, this is probably OT at this point.
Try
Hi - this is a repost [sorry]
We have installed MYSQL Ver 8.23 Distrib 3.23.54, for sun-solaris2.8 on
sparc from a binary onto a 6 processor server with 6 gig of ram but we are
seeing very slow imports. A 16M export takes 7 minutes, a 60M export takes
over an hour.
I have tuned my.cnf but
On Thu, Feb 13, 2003 at 05:57:54PM +0300, Artem Koutchine wrote:
The effect is you limit the possible rows to a small amount really
quick
with a simple join. The details of the search are handled bij a like
which
can get as complicated as you like using OR`s, NOT`s etc; it won`t
need
I'm trying to add a new column into a table, but I have received the folow
message:
[Des057] ERROR 7: Error on rename of '.\vendas\pedidos.MYI' to
'.\vendas\#sql2-6f0-15.MYI' (Errcode: 13)
Please, help me.
-
Before posting,
On Thu, Feb 13, 2003 at 09:57:06AM -0500, Luc Foisy wrote:
I don't think it is possible at the moment, and pretty sure its not standard SQL but
it would still be neat to have
SELECT aField, COLUMN_IF( some_expression, 'afield2' AS 'aColumn' ) FROM aTable
So in this example, if the
Here's another way to do it which works well with multiple slaves:
http://mtop.sourceforge.net/utils/purge_replication_log
This script is run on the slave and the master. When run on the slave it
updates a table in the master which keeps track of the log position for
each slave. When run on
Hello Sir,
I have problem connecting to mysql in dos-prompt..
Error is : can't connect to mysql on localhost 10061)..
What does it mean?
I also try another method to solve this problem by typing
mysqld-nt --install
error prompts saying that the service already exists.
The current server
On Thu, 13 Feb 2003 13:35:33 -0300
Sauer - brfree [EMAIL PROTECTED] wrote:
I'm trying to add a new column into a table, but I have received the folow
message:
[Des057] ERROR 7: Error on rename of '.\vendas\pedidos.MYI' to
'.\vendas\#sql2-6f0-15.MYI' (Errcode: 13)
There is something wrong
Scott Wong writes:
Version: Mysql 4.0.10-gamma
Description: Mysql client loses connection when doing a multi-table delete if one
table is innodb and the other is myISAM.
How to Repeat :
drop table parent;
drop table child;
CREATE TABLE parent(id INT NOT NULL,
Hello
There is a bug in both MySQL-Front and NaviCat where updating a field
before retrieving all the record in the data result hangs up the thread as
they use mysql_use_result() feature. Try using some other Front Ends.
Insane
- Original Message -
From: Daniel Negron/KBE [EMAIL
On Sunday 09 February 2003 13:10, Dmitry Kosoy wrote:
It is good for MyISAM tables.
For Innodb it puts on separate disk frm files only.
And what about Innodb tables of the specific database?
You can put different ibdata files on separate disks.
Regards,
Dmitry
Is there any way to put
On Thursday 13 February 2003 16:43, Johannes Ullrich wrote:
I am having problems setting up replication between two 4.0.10
servers.
What I did so far:
- generate a dump of the current state of the server using
'mysqldump' (its a mix of mostly innodb tables and some MyISAM
tables)
-
On Wednesday 12 February 2003 18:26, Ben Clewett wrote:
I am using 4.0.10-gamma-max-nt, with 100% innodb, and cannot get Foreign
Keys to create.
The help files give this example:
CREATE TABLE child(id INT, parent_id INT, INDEX par_ind (parent_id),
FOREIGN KEY (parent_id)
On Thursday 13 February 2003 10:00, eliran wrote:
My name is Eliran and I'm working at Rimed company in Israel.
We consider to use MySql as a database for our application.
I installed MySql 3.23 on window XP.
I want to know what I must do in order to be able to run the C++ example it
give me
On Thursday 13 February 2003 15:03, Elby Vaz wrote:
The MySQL-4.0.9-gamma to windows supports sub select?
Nope.
Ex.: select ... from ... where ... in (select.)
If not, has some version that supports it?
Subselects will come in 4.1
--
For technical support contracts, goto
Sauer,
I'm trying to add a new column into a table, but I have received the folow
message:
[Des057] ERROR 7: Error on rename of '.\vendas\pedidos.MYI' to
'.\vendas\#sql2-6f0-15.MYI' (Errcode: 13)
Which MySQL version? Guess you're running MySQL under Win2K or WinXP.
I had the same kind of
If that is done with the engine already running, will the DB be recognized
without a restart?
Also - do you happen to know if I am able to determine where the mysql/data
directory resides from a given DB connection? It will not always be the same
location for the different installs that
This is weird, all of a sudden it starts working, if it happens again
though I will try another front end. Thank you for your advice
Thank you,
---
-Daniel Negron
// \\
Luc, Zak,
SELECT aField, COLUMN_IF( some_expression, 'afield2' AS 'aColumn' ) FROM aTable
You can use a WHERE clause to get an effect like this.
SELECT CASE expression
WHEN 'value'
THEN column
...
ELSE 'default result'
END
FROM Table;
Or
On Tuesday 11 February 2003 19:53, The Mindflayer wrote:
mysql -V:
mysql Ver 11.15 Distrib 3.23.41, for redhat-linux-gnu (i386)
(Upgrading may not be an option.)
Not subscribed to the list, so please CC me on any responses.
I'd submit this to bugs@, but my MySQL version is way out of date
At 23:47 +0800 2/13/03, [EMAIL PROTECTED] wrote:
Hello Sir,
I have problem connecting to mysql in dos-prompt..
Error is : can't connect to mysql on localhost 10061)..
What does it mean?
I also try another method to solve this problem by typing
mysqld-nt --install
error prompts saying that the
Ellen,
Error is : can't connect to mysql on localhost 10061)..
I also try another method to solve this problem by typing
mysqld-nt --install
error prompts saying that the service already exists.
The current server installed is : c:\Apache\mysql\bin\mysqld-nt.exe
Start
Dear All,
It would appear that setting:
set-variable= open_files_limit = 200
Within the [mysqld] stanza in a data/my.cnf does not appear to work as
mysqld exits with:
ERROR: unknown variable 'open_files_limit = 200'
Yet a bin/mysqladmin variables has:
open_files_limit 0
I cannot
At 16:40 + 2/13/03, [EMAIL PROTECTED] wrote:
If that is done with the engine already running, will the DB be recognized
without a restart?
Yes.
Also - do you happen to know if I am able to determine where the mysql/data
directory resides from a given DB connection? It will not always
Heikki,
Thanks for the reply.
My confusion is that we are only using 1 table within our lock
area of the code. The error is coming back on the connection
which is not doing any table locks. The error comes when we are in
the middle of a transaction block.
Is there some reason
Are you tring to create a fulltext index on a blob field?
If so - it won't work - fulltext can use only text fields.
Cheers,
Andrew
-Original Message-
From: Sauer - brfree [mailto:[EMAIL PROTECTED]]
Sent: 13 February 2003 16:36
To: Lista Mysql 1
Subject: Error 7 - Errorcode 13
I'm
At 18:45 +0200 2/13/03, Victoria Reznichenko wrote:
On Tuesday 11 February 2003 19:53, The Mindflayer wrote:
mysql -V:
mysql Ver 11.15 Distrib 3.23.41, for redhat-linux-gnu (i386)
(Upgrading may not be an option.)
Not subscribed to the list, so please CC me on any responses.
I'd submit
At 16:56 + 2/13/03, [EMAIL PROTECTED] wrote:
Dear All,
It would appear that setting:
set-variable= open_files_limit = 200
Within the [mysqld] stanza in a data/my.cnf does not appear to work as
mysqld exits with:
ERROR: unknown variable 'open_files_limit = 200'
That's odd. What
Hi all,
I have similar problems as Kris posted on 12/17/2002. I didn't find any
solution, so I write this e-mail.
If I connect to mysql in console with:
mysql -u username -p
then everything works fine. MySQL is 3.23.53-max-nt running on WinXP and
on the same machine I am trying to connect to
Hello,
I'm having an odd problem with my MySQL server that I thought someone might
have some ideas on.
Setup:
MySQL 4.0.10-max
Mac OS X Server 10.2.3
DP G4 1.25 GHz
1G RAM
MySQL data and temp files on 400G striped RAID array (off an Acard hardware
controller) that is 90% empty
Clients accessing
Is there a way to get a row number returned with any select query?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this
Hmmm, what about GRANTs on user 'username@machine_name'?
On Thu February 13 2003 18:44, Branko Kaucic wrote:
Hi all,
I have similar problems as Kris posted on 12/17/2002. I didn't find any
solution, so I write this e-mail.
If I connect to mysql in console with:
mysql -u username -p
then
At 18:44 +0100 2/13/03, Branko Kaucic wrote:
Hi all,
I have similar problems as Kris posted on 12/17/2002. I didn't find any
solution, so I write this e-mail.
If I connect to mysql in console with:
mysql -u username -p
then everything works fine. MySQL is 3.23.53-max-nt running on WinXP and
on
Steff,
- Original Message -
From: [EMAIL PROTECTED]
To: Heikki Tuuri [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Thursday, February 13, 2003 7:21 PM
Subject: Re: Transaction problems using InnoDB, not locked with LOCKTABLES
Heikki,
Thanks for the reply.
My confusion is that
Hi,
I just have installed the MySQL on a Suse linux.
I would like to administrate it from Win2k with MySQL Control Center 0.8.9
beta. But I can't make new user in the control center. I think, I have to
enable at the linux consol
that the root (SQL root) could be administrate the SQL server on my
Thanks to all. Now it works!
Branko
On Thu, 13 Feb 2003, Martin Hudec wrote:
Hmmm, what about GRANTs on user 'username@machine_name'?
On Thu February 13 2003 18:44, Branko Kaucic wrote:
Hi all,
I have similar problems as Kris posted on 12/17/2002. I didn't find any
solution, so I
: Is there a way to get a row number returned with any select query?
Row number is not available for some queries (ex.DELETE FROM table_name)
for efficiency. You can disable it with a dummy WHERE clause:
DELETE FROM table_name WHERE 1 0;
It will be slower, but you'll get the
Heikki,
I wish I could reproduce this outside of production. To this point
the only place we have seen this is in production. I did turn the
logging on for MySql and the connection number assigned for all
the SQL which we would have expected to be within a transaction
did not change.
Hi Stefan,
Thanks for your reply!
The table has just been created, and has therefore no deleted entries. ID 1-1000 was
created by myself, ID 1002 was created when a new user registered at the website. ID
1001, 1003, 1004, etc is sorted correctly.
There is three tables in the database which
Check the user 'repl' has REPLICATION SLAVE privilege.
Ah. that fixed it. Actually, the real reason was that I had not
yet updated the mysql tables and the new privileges did not take
effect as a result.
mysql_fix_privilege_tables , followed by the 'GRANT' command
and 'flush privileges' fixed
There is no relevant data or use to this number.
It is the row number of the returned result set, purely for display.
I was hoping there was some kind of function just to drop a number in there, regarless
of any data that is stored in the table or regardless of the order the resultset
appears.
I stated to implement something like Oracle's ROWNUM ...
but noone's listening ... therefore I build an UDF ...
-Ursprüngliche Nachricht-
Von: Luc Foisy [mailto:[EMAIL PROTECTED]]
Gesendet: Donnerstag, 13. Februar 2003 20:00
An: MYSQL-List (E-mail)
Betreff: RE: Row numbers
There
-Original Message-
From: Zak Greant [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 13, 2003 10:38 AM
To: [EMAIL PROTECTED]
Subject: Re: MySQL Feature
On Thu, Feb 13, 2003 at 09:57:06AM -0500, Luc Foisy wrote:
I don't think it is possible at the moment, and pretty sure
I still don't understand do you mean the actual row number or just a
display number.
- Original Message -
From: Luc Foisy [EMAIL PROTECTED]
To: MYSQL-List (E-mail) [EMAIL PROTECTED]
Sent: Thursday, February 13, 2003 6:59 PM
Subject: RE: Row numbers
There is no relevant data or use to
Hi. I'm new to the list, just installed mysql 4.0.10-gamma on Unix,
BSDI 4.x to take advantage of the new Union command.
I've run across an error have narrowed it down. I don't know if this
is correct behavior documented somewhere I can't find, or if it's a bug.
It's an odd error, so, I will
I think I know what you are asking for. Create an int field with auto_increment set.
Make that field the first field in your table.
i.e.
CREATE TABLE my_table (
id int(11) auto_increment NOT NULL,
other_data ...
PRIMARY KEY (id)
);
Then, when you want rowid for
You can use user variables; example:
mysql describe library_master;
+-+--+--+-+-++
| Field | Type | Null | Key | Default | Extra |
+-+--+--+-+-++
|
Scott Wong writes:
Version: Mysql 4.0.10-gamma
Description: ERROR 1105: Unknown error after issuing a multi-table delete on
parent/child table.
if there's no foreign keys .. works ok.
How to Repeat :
drop table parent;
drop table child;
CREATE TABLE parent(id INT NOT NULL,
Auto-inc column would be the obvious answer, but that's and intrusive
answer.
Jerry
- Original Message -
From: Jerry [EMAIL PROTECTED]
To: Luc Foisy [EMAIL PROTECTED]
Cc: MYSQL-List (E-mail) [EMAIL PROTECTED]
Sent: Thursday, February 13, 2003 7:10 PM
Subject: Re: Row numbers
I still
Steff,
a note on terminology: every query inside InnoDB always happens inside a
transaction. In the AUTOCOMMIT=1 case there just is an automatic commit done
at the end of each SQL statement.
In your log below I cannot see how connection 7 could ever receive the error
Table 'productsprovided'
Karth,
I just have installed the MySQL on a Suse linux.
I would like to administrate it from Win2k with MySQL Control Center 0.8.9
beta. But I can't make new user in the control center.
Obviously, you're logged in to the MySQL server as a user who doesn't
have the privileges to create new
Viktor,
I have a couple of tables in a MySQL database. In one of the tables,
PhpMyAdmin sorts very strange. ID 1002 is places between ID 21 and
ID 22. Any idea why?
The table has just been created, and has therefore no deleted entries. ID 1-1000 was
created by myself, ID 1002 was created
The control center doesn't have a command to flush the tables or reload the
user tables. So the new user won't have access until you do:
mysqladmin -u some user with authority -ppassword -hyour db host
reload
Curtis
Stefan Hinz said:
Karáth,
I just have installed the MySQL on a Suse linux.
-Ursprüngliche Nachricht-
Von: Martin Rösch [mailto:[EMAIL PROTECTED]]
Gesendet: Donnerstag, 13. Februar 2003 13:20
An: [EMAIL PROTECTED]
Betreff: NullPointerException in the Java Connector
Hi,
attached is my report.
Thank you for your good work.
Kind regards
Martin Rösch
I still don't understand do you mean the actual row
number or just a
display number.
There is no relevant data or use to this number.
It is the row number of the returned result set, purely
for display.
That means no field exists or should exist in the database. I only want to
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Martin Rösch wrote:
-Ursprüngliche Nachricht-
Von: Martin Rösch [mailto:[EMAIL PROTECTED]]
Gesendet: Donnerstag, 13. Februar 2003 13:20
An: [EMAIL PROTECTED]
Betreff: NullPointerException in the Java Connector
Hi,
attached is my report.
I access a msyql server (apache/mysql/php) from my w2k workstation using
phpMyAdmin. I do not have command line access.
When I use the link to load a local data file it responds that it is not
allowed. I read the mysql docs and see it is now disabled by default.
In 4.2.4 one paragraph says If you
Heikki,
The application which is having this problem is used to read an
XML document and update a database. The application is part of a
website, so there are always other interactions with the database
while the loader is running. The log below was created at a time
when no one was
I've got MySQL installed via RPM on a Red Hat 8.0 machine. How do I
enable InnoDB?
--
John Oliver, CCNAhttp://www.john-oliver.net/
Linux/UNIX/network consulting http://www.john-oliver.net/resume/
*** sendmail, Apache, ftp, DNS, spam filtering
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
[EMAIL PROTECTED] wrote:
Heikki,
The application which is having this problem is used to read an
XML document and update a database. The application is part of a
website, so there are always other interactions with the database
while the
On 13 Feb 2003, at 15:31, Luc Foisy wrote:
Using variables is the best response to my question. I just dislike
using them cause they are ugly to work with because of the session
persistance and because I have to issue multiple queries to do the
job.
Using variables seems to be the way to do
Hello
I have downloaded 4.1 source and successfully compiled it.
When i use the mysql client as a root it works without problems.
If i use the client as a different user when i try to use the 'use
DATABASE' command i get a segmentation fault.
Here is a backtrace of the stack when the program
At 19:55 +0100 2/13/03, Viktor Vasiliou wrote:
Hi Stefan,
Thanks for your reply!
The table has just been created, and has therefore no deleted
entries. ID 1-1000 was created by myself, ID 1002 was created when a
new user registered at the website. ID 1001, 1003, 1004, etc is
sorted
Giorgos Gaganis wrote:
Hello
I have downloaded 4.1 source and successfully compiled it.
When i use the mysql client as a root it works without problems.
If i use the client as a different user when i try to use the 'use
DATABASE' command i get a segmentation fault.
Here is a backtrace of the
platform:
os: freebsd-4.5
qt: 3.1.1 (no threads, no opengl, no xft)
mysqlcc source version: 0.8.9 (mysqlcc.pro.in modified to remove thread
from CONFIG).
compile error:
gmake -v
GNU Make version 3.79.1, by Richard Stallman and Roland McGrath.
Built for i386--freebsd4.3
gcc -v
gcc version
At 12:43 -0800 2/13/03, John Oliver wrote:
I've got MySQL installed via RPM on a Red Hat 8.0 machine. How do I
enable InnoDB?
If it's MySQL 4, install the -Max RPM on top of your existing installation
to get a server with InnoDB enabled. If it's MySQL = 4, InnoDB is
included already; you
I thought of a new feature... XSLT's position()-like functionality
in the new releases of MySQL.
position(), in XSLT, returns position of the node in the document tree.
In MySQL it would return position of the record in the returned result set
(from SELECT query):
Example:
SELECT
Hi Mark,
Good call. The way we understand the SQL log it looks like all
of the SQL commands we had expected to be part of the
transaction are on connection 7, while the counter incrementation
which is done outside of the transaction was done on connection
12.
At one point we
Is auto completion a feature that only works in Mysql4?
Cheers
Sql,query
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request
Hi sinisa,
I tried this patch.
It came up with undefined symbol for ER_MULTI_TABLE_UPDATE_DELETE_WITH_INNODB on
compile
so i went ahead and added to include/mysqld_error.h for testing.
i'm not sure if it's the right place or the right error code but it made mysql compile
***
1 - 100 of 124 matches
Mail list logo