t send the data in a unicode INSERT statement via ODBC from C++
/ MFC.
Do you think that could be the issue? If so, do you have a suggestion on how to
do it better?
Thank you again for your help!
Sincerely,
Andreas Iwanowski
-Original Message-
From: Janusz Paśkiewicz [mailto:ad...@multip
Has no one encountered this before? There has got to be a solution, and
I still haven't found it... So if you have any input please let me know!
-Original Message-
From: Andreas Iwanowski [mailto:namez...@afim.info]
Sent: Tuesday, August 24, 2010 2:48 PM
To: mysql@lists.mysq
Hello everyone!
I am using an MFC unicode project that uses ODBC to access a MySQL
5.1.50 database via the MySQL ODBC 5.1.6 driver.
character_set_connection is set to utf8 (Which I believe is the default
for the driver)
One of the tables contains two LONGBLOB columns, and the table default
charset
Hello everyone!
I am using an MFC unicode project that uses ODBC to access a MySQL
5.1.50 database via the MySQL ODBC 5.1.6 driver.
One of the tables contains two LONGBLOB columns, and the table default
charset is utf-8 (since the application is unicode).
However, when inserting into the LONGBLOB
Mysql versions used:
PC: Ver 5.0.51b-community-nt for Win32 on ia32 (MySQL Community Edition (GPL))
Server: mysqld Ver 5.0.38-Ubuntu_0ubuntu1-log for pc-linux-gnu on i486 (Ubuntu
7.04 distribution)
Thank you very much for any assistance and Kind regards
Andreas Müller
--
MySQL General Mailin
ers to see those rows
I once read that if an auto_increment column is set to NULL then it
will become a new number in the sequence but I was not able to get
this to work.
Any other solutions?
/Andreas Pardeike
On 2 apr 2009, at 10.11, Scott Haneda wrote:
Add a column of type timestamp which, b
ve this problem by copying the rows to a temporary
table,
then delete them and insert them from the temporary table but this
moves my
huge payload around which I really want to avoid.
How can I solve this in a better way?
/Andreas Pardeike
--
MySQL General Mailing List
For list archives: htt
ve this problem by copying the rows to a temporary
table,
then delete them and insert them from the temporary table but this
moves my
huge payload around which I really want to avoid.
How can I solve this in a better way?
/Andreas Pardeike
--
MySQL General Mailing List
For list archives: htt
Hi,
Thanks for your input. Yes I can logon to the server and I will try this
command next time it hangs. Will let you know what I see.
Best regards,
Andreas
---
On Sat, Aug 23, 2008 at 5:32 PM, Johnny Withers <[EMAIL PROTECTED]>wrote:
> There are all kinds of logs mysql will pro
dmesg nor ps -aux | grep my.
How can I see what the mysql server is struggling with? I'd like to enable
some sort of logging, but I'm not sure how to do it. Can anyone help me out
a little here?
Thanks and best regards,
Andreas
or the new system - somehow.
I hope someone will be able to assist me a little here.
Thanks and best regards,
Andreas
Hello MySQL community,
I have a table that contains a foreign key, e.g.
ID - Local unique key
UserID - Foreign key
Data
Is it possible to do a JOIN on the Users table to replace UserID with
the name of the user,
as in the Name column of the Users table?
I've tried several JOINS, but I JOIN the
I would suggest you order by something that includes a fulltext index on
the specific column.
Maybe check out the documentation on the MATCH()AGAINST() systax as well
as fulltext searches in general.
For example:
SELECT Col1, Col2, Score AS MATCH(TextCol) AGAINST ("") WHERE ... ORDER
BY Score;
Ho
7;@',1) using latin1)));
---
-Original Message-
From: Martijn Tonies [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 24, 2007 12:09 PM
To: Andreas Iwanowski
Cc: mysql@lists.mysql.com
Subject: Re: View with Subselect for User ID
Hello Andreas,
>I tried the following stat
Hello Christian,
Thank you very much for this reply. It was very helpful, and the user
matching part works as it should.
Is there any way to JOIN on two tables, so I can match the Users.GroupID
field against a JOIN on Groups.ID?
Also, I tried adding a WHERE clause after the join to compare
Users.
Hello MySQL experts,
I am trying to create a view whose access is based on a User ID that
need to be looked up in a different table.
Here is an example of what I'm trying to do:
CREATE OR REPLACE ALGORITHM=UNDEFINED [EMAIL PROTECTED] SQL
SECURITY DEFINER VIEW `shared_v` AS select `Shared`.`ID` AS
If you are under windows, you should try Textpad
(http://www.textpad.com/)
In any case, a hex editor will do what you're looking for.
Hope to help,
Andy
-Original Message-
From: molemenacer [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 19, 2007 6:44 AM
To: mysql@lists.mysql.com
Sub
pened, the server was always shut
down properly.
-Andy
-Original Message-
From: Jerry Schwartz [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 01, 2007 4:10 PM
To: Andreas Iwanowski
Cc: mysql@lists.mysql.com
Subject: RE: Fulltext search dilemma (IN BOOLEAN MODE)
Sorry, I have no idea wh
[EMAIL PROTECTED]
Sent: Thursday, February 01, 2007 1:52 PM
To: Andreas Iwanowski; mysql@lists.mysql.com
Subject: RE: Fulltext search dilemma (IN BOOLEAN MODE)
Unless you changed the minimum word length, "Key" would be ignored
because it is too short. I would think the quotation marks at the
Hello MySQL experts,
I'm trying to do a full text search on an indexed Keywords column that
contains quotation marks, and it's giving me a headache.
Suppose there are records in the database containing the folling
keywords:
1. "Miami Beach" City
2. "Key West" Florida
3. "Key West" Beach Florida
ue
Could this be a problem with rewriteBatchedStatements? Any ideas?
Thanks,
Andreas
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Daniel Kasak schrieb:
Andreas Moroder wrote:
Daniel Kasak schrieb:
You won't break anything by adding a timestamp field. Trust us :)
And no, there is no way around this problem other than adding a
timestamp field.
From the 'mysql' command-line client, do:
... where DATAB
Daniel Kasak schrieb:
Andreas Moroder wrote:
Hello,
when I open mysql table with access 97 using the latet mysql-odbc
driver ( 3.51.12 ) I see only deleted records.
What is happening ?
I found many posts about this problem, but I can not, as told in this
posts, add timestamp or other fields
application I don't want to break.
Is a solution without the need to change the tables ?
Thanks
Andreas
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
.
How can I enable a external host to access this DB ?
It is possible to configure this from command line ?
( winmysqladmin is not working properly on this machine )
Thanks
Andreas
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com
ps on two
locations to be even safer.
In my setup I now have 3 my.sh scripts executed at the same time through a
cronjob. Could it be problematic to do this at the same time or does it not
matter? The databases aren't large.
Cheers,
Andreas
e both, but what is
recommended?
What would the correct script/way to restore the database?
Thanks,
Andreas
n trying to connect
While I can login to mysql easily with this user/pass from the command
prompt. I have also tried the specific user for this database. Same problem.
Any ideas?
Thanks,
Andreas
, lastname, firstname)
values (nextval('s_authors'), 'Meyers', 'Scott');
insert into table2 (authorid, title, subtitle)
values (currval('s_authors'), 'Effektiv C++ Programmieren',
'50 Wege zur Verbesserung Ihrer Programme und Entwuerfe');
H
ge zur Verbesserung Ihrer Programme und Entwuerfe');
Best regards
Andreas
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
the
latest FreeBSD version.
Any good suggestions to a script that will back up my databases and make
things ready for an easy restore if I need to?
Thanks!
Andreas
e)
values ('1'), 'Effektiv C++ Programmieren',
'50 Wege zur Verbesserung Ihrer Programme und Entwuerfe');"
?
Field authorid.t_books should have the same
auto_incremented values as the field authorid.t_authors.
Best regards
Andreas
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
from t_books, but always the value '1'?
If I took '0' or others I get errors.
In phpmyamin I set the reference to t_authors.authorid in the
t_books.authorid field.
Best regards and many thanks
Andreas
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
---+
1 row in set (0.09 sec)
mysql> INSERT INTO category (name) VALUES ("School friends");
Query OK, 1 row affected (0.03 sec)
mysql> ALTER TABLE friends ADD FOREIGN KEY (category) REFERENCES
category(id);
Query OK, 1 row affected (0.18 sec)
Records: 1 Duplicates: 0 Warnings: 0
tablish here. Does someone really
understand the InnoDB error message and what's going wrong? It is not a
name clash either, for I tried giving the `category` column another name.
Andy Krueger
Martijn Tonies wrote:
Hello Andreas,
You're not telling us what version of MySQL you
This is a question onto defining foreign keys in a relational database.
Foreign keys are featured by the InnoDB engine and therefore all three
tables of the database use it:
1. `friends` main table
2. `relation` deploys a simple relation between rows of the main table,
'1-2' means '1 is friend
On Wednesday 21 December 2005 08:12, you wrote:
> Are you mean this problom only disposed in compile ?
yes and no...this way you tell mysql to use readline instead of libedit...so
the problem is (at least that was the problem for me) related to the lib
which is used for input processing...
> >
On Tuesday 20 December 2005 03:10, wangxu wrote:
> Are there two option?
> How to use them?
These are just two options which you will have to use when ./configure'ing the
source distribution
if you are using a binary distribution of mysql try downloading the source
distribution...
then rea
On Monday 19 December 2005 08:47, wangxu wrote:
> I can't operate utf8 characters within command-line in linux operating
> system. Mysql doesn't support?
--without-libedit –with-readline=/usr/include/readline
that fixed it for me
Kind Regards,
Andreas Strei
code=0
SET TIMESTAMP=1131525480;
insert into tablename set name = ...
---
So that the auto_increment value in this example after the queries 15183828,
but it should be 15183856.
Have anybody the same problems, it this a bug and is there a solution for
this problem ?
Thanks and Regards
Andreas
--
MyS
t\ ';
no...doesn't work...guess i will have to use text :|
Kind regards,
Andreas Streichardt
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
+---+
| 5 | 5 | 6 | 6 |
+---+---+---+---+
1 row in set (0.00 sec)
Is this a feature or am i missing something. text would do it for me but it is
a total waste of space.
Any ideas?
Kind regards,
----
Kind regards,
Andreas Streichardt
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
.
I can fix the problem, if I restart the server to get away these
unkillable queries and make a
ALTER TABLE tablename TYPE=innodb
or
ALTER TABLE tablename TYPE=myisam
- but this helps only till next time I run a table check or optimizer on
these tables
Cheers,
Andreas
--
MySQL
.mysql.com/doc/mysql/en/making-trace-files.html
I get a big trace file... but for me it's not readable or providing any
help...
Possible that I hit the problem with mysql/libc2.3/amd64 ...
http://hashmysql.org/index.php?title=Opteron_HOWTO#pthread_rwlock_wrlock_hang_with_nptl
Cheers,
Andrea
ess. They haven't fixed the problem. All tools
saided the tables are ok - also the indexes.
No errors in mysql.err.
Compile options for the database-server are the same on both servers
(debian sarge packages). Also both are using the
same parameters within my.cnf.
The only difference
s and your heaps might have mixed? If your
threads allocate to much memory and you have a lot of them this might
corrupt your database.
--
Per Andreas Buer
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
16552
> Estimated memory (with thread stack):1319610352
>
>
> Number of processes running now: 0
> 050704 18:38:23 mysqld restarted
> 050704 18:38:23 [ERROR] Can't start server: Bind on TCP/IP port:
> Address already in use
> 050704 18:38:23 [ERROR] Do you already have another mysqld server
> running on port: 3306 ?
> 050704 18:38:23 [ERROR] Aborting
>
> 050704 18:38:23 [Note] /usr/libexec/mysqld: Shutdown complete
>
> 050704 18:38:23 mysqld ended
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
--
Per Andreas Buer
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
guess is that you have a
software problem. Upgrade mysql to a production release and see if that
takes care of your problem.
--
Per Andreas Buer
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Am 02.06.2005 um 20:31 schrieb Jerry Swanson:
Does Mysql 4 supports "views"?
No.
Regards,
A.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
On Monday 09 May 2005 12:24, John Doe wrote:
> Am Montag, 9. Mai 2005 11.55 schrieb Andreas Steichardt:
> > Hi!
> >
> > We are storing UTF-8 data in out mysql database and we need to get the
> > length of the data. But length() doesn't return the number of chara
#x27;köter' USING 'ucs2'))/2;
This works fine but a "real" solution like CHAR_LENGTH() or something like
that would be really apprectiated.
Kind regards,
Andreas Streichardt
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
asier.
Regards,
Andreas
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Vic Cekvenich schrieb:
> I am looking for a nice OS X GUI client, can be java for osx that works
> w/ mysql 5.x.
>
> (these don't work MacSQL, CocaMySQL, YouSQL. MySQK admin does work, but
> I want a bit more, like Maestro for OS X).
AFAIK is the stuff from Navicat available for OS X.
Regards,
Heikki Tuuri schrieb:
> Creating the indexes after the import will only slow down the operation.
> MySQL recreates the whole table at CREATE INDEX.
That's new to me, but good to know (always this urban legends...).
Does that only apply to InnoDB or to MyISAM too?
Regards,
A.
--
MySQL General
Jarle Aase schrieb:
> Is there a way to boost the performance? The database is idle, and while
> importing, performance is the key priority (record-locking,
> transaction-rollbacks and file-integrety/crash-recovery are not required
> until the data are imported).
- Disable the foreign key checks
shaun thornburgh schrieb:
> Thanks for your reply, I would like the query to retun one
> instance of user 101 rather than 15!
SELECT DISTINCT ...
Regards,
A.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED
Hi,
I have to implement a bestseller list feature into a shop software
and, unfortunately, I don't see a possibility to make it as fast as
it has to be.
The relevant stuff is distributed among four tables [1]. `orders`
contains all the ordered products. I use the following query to
create a per-c
,
Andreas Streichardt
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi Again,
You have to optimize a large database (2 Million records).
since I have a huge amount of 'static' records (2 million and more)
which will not change any more, and on the other hand at about 2.ooo
(growing) records which are updated regulary, I wonder if its useful
having those static r
Hi Jigal,
Jigal van Hemert schrieb:
From: "Andreas Brandl"
ich stehe gerade vor dem Problem, dass ich eine große Datenbank (ca. 2
Mio. Datensätze) optimieren muss.
Since this list is in English I'll answer you in English, so the others can
join the fun!
Well, I didnt notice the lis
cht es Sinn, Indizes über Felder zu legen, die oft in WHERE-Klauseln
vorkommen?
Aber ein Index über ein varchar(250)-Feld ist auch nicht gerade
sinnvoll, richtig?
Wie kann ich die DB optimieren?
Besten Dank für jeden Hinweis,
Gruß,
Andreas
--
MySQL General Mailing List
For list archives: http://l
Hi,
Dylan Neild schrieb:
> 1. We just installed a very large MySQL installation on a dual opteron
> 2ghz system with 16GB of memory and it -flies-. That's pretty
> subjective, so check:
>
> http://www6.tomshardware.com/cpu/20030422/opteron-17.html
> http://www.infoworld.com/article/04/09/17/38
Hi!
It seems that I need to buy a 64bit server and have some questions
regarding the two architectures from AMD (Opteron) and Intel (Xeon
with EM64T).
Am I right if I say an Opteron based server is the better choice for
MySQL because of the more advanced and faster bus system?
Is there anywhere
moothly?
Is it a problem to have that many databases?
Thanx!
/Andreas
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.799 / Virus Database: 543 - Release Date: 2004-11-19
--
MySQL General Mailing List
For list
Schalk Neethling wrote:
Have you tried DBDesigner4 by fabForce?
I'm "working" with it at the moment. As far as I see, it doesn't
work on Mac and unfortunately DBDesigner manages to trash my
foreign keys definitions from time to time.
Regards,
A.
--
MySQL General Mailing List
For list archives: h
Hi!
I'm looking for a good graphical database designer, supporting
the latest stable release of MySQL, MyISAM and InnoDB tables and
foreign keys. So far there are a lot of products. But I need one,
which runs on Windows and MacOS X. Do you have a good suggestion?
Regards,
Andreas
--
> I think that's the problem.
> Could be a lot of editing PHP scripts for a lot of people(!?)
> Thanks
Try to compile PHP against the client library for MySQL 4.1. I'll
wonder if it won't work. ext/mysqli is required if you like to
use things like prepared statements...
Regards,
A.
--
MySQL Ge
Michael Gale <[EMAIL PROTECTED]> writes:
> Anyone running mysql 4.1 with cluster support ?
Try the Mysql cluster list.
> Is it sort of production ready ?
The 4.1 release is labeled BETA. See
http://en.wikipedia.org/wiki/Development_stage
--
Per Andreas Buer
--
MySQL General
Hello,
Michael Mason schrieb am Dienstag, 20. Juli 2004 um 22:46:
> I basically just want to clear a table I use for logon entries. Can anyone
> help with this please.?
http://dev.mysql.com/doc/mysql/en/TRUNCATE.html
http://dev.mysql.com/doc/mysql/en/DELETE.html
HTH,
A.
--
MySQL General
Hello,
Eamon Daly schrieb am Donnerstag, 17. Juni 2004 um 19:04:
> FYI, MySQL allows boolean searching as of 4.0.1. See:
> http://dev.mysql.com/doc/mysql/en/Fulltext_Boolean.html
I normally use that. But: Very bad result quality because there
are only sigle keywords. I tried it with a text colum
Hello,
I have to build a keyword search with support for the boolean
operators +, -, * and ".
Basically it's quite easy: Connect the three tables with two
joins, keyword search with LIKE. But the boolean operators give
me a headache.
mysql> SELECT c.id FROM keywords AS a LEFT JOIN keywords_trans
procedure? Do they have to be
bound with mysql_stmt_bind_param? Is anybody able to help me? Post some
example code?
Thanks in advance
Andreas Kllaitis
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
r-optimized?
>
> Because when I pull up phpMyAdmin, and it says there is 3,768 bytes of
> overhead, I just feel *dirty*! Overhead, after all, is a Very Bad
> Thing!
Yeah. And doing a full table optimization after updating one single row
does not at all add any overhead. Not at all. :P
this? Any hints would be greatly appreciated. I am using MySql 4.0.16.
Cheers,
Andreas
--
\_
Dipl.-Ing. Andreas Heckwolf Voice : +358 40 5847 445
Mobliz Ltd Fax: +358 9 2517 2977
Te
Hi there,
I am a bit confused. It is not clear to me that the version I am currently
running is the one I compiled last. How can I check the date of compiling?
In order to get more performance I did try to install mysql 4.0.18 with different
configure commands, now I am not sure if the make insta
Hi there,
I just found that mysql 4.0.18 is doing binary logging. How can I turn this off?
I outcommented the line in my.cnf and restarted the server, but it is still creating
those binary loggs inside the data dir. I do not see a nead for this, plus I fear that
it might fill up the file system, p
Hi there,
I just recompiled mysql and I am wondering if there is something like in php
(phpinfo();) where you can see the configure command after the db is installed.
It would just be nice to have that in a later time, or even to make sure that the new
version has replaced the old one.
thanx fo
ich I found somewhere else on the net?
Andy
Daniel Kasak <[EMAIL PROTECTED]> schrieb am 13.04.04 05:31:35:
>
> Walter Andreas wrote:
>
> >Hi there,
> >
> >how to compile mysql 4.0.18 on a pentium for best performance? I searched the net
> >now for 2 da
Hi there,
how to compile mysql 4.0.18 on a pentium for best performance? I searched the net now
for 2 days and found lots of hints on compiling with icc and pgcc, but it looks to me
that icc is not working with mysql 4.0.18 and pgcc is out of date (maybe gcc already
catched up with pgcc?).
Sett
Hi there,
I am trying to benchmark a mysql installation.
After running:
/usr/local/mysql/sql-bench # ./run-all-tests
it throws the error:
Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)'
Thats ok, since the socket is /tmp/mysql.sock as configured in my.cnf
I
Problem description:
> > CFLAGS="-O3 -unroll2 -ip -mp -no-gcc -restrict" CC=icc CXX=icc CXXFLAGS="-O3
> > -unroll2 -ip -mp -no-gcc -restrict" ./configure --prefix=/usr/local/mysql
> > --with-mysqld-user=mysqladm --without-debug --with-client-ldflags=-all-static
> > --with-mysqld-ldflags
Hi there,
I am trying to compile mysql 4.x with intel compiler for maximum performance. On my
research I have found that following line will squese more performance out of mysql:
CFLAGS="-O3 -unroll2 -ip -mp -no-gcc -restrict" CC=icc CXX=icc CXXFLAGS="-O3 -unroll2
-ip -mp -no-gcc -restrict" ./c
Received: from 213.39.151.4 by freemailng1402.web.de with HTTP;
Sun, 11 Apr 2004 12:47:20 +0200
Date: Sun, 11 Apr 2004 12:47:20 +0200
Message-Id: <[EMAIL PROTECTED]>
--- END HEADERS ---
Hi there,
I just installed the newest mysql 4.x server on a suse9.0 system with apache 1.x and
php4.x
53556 |
+--+
1 row in set (0.00 sec)
Regards,
Andreas Pardeike
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
either use local code to
do the query
first and insert the value manually or use a join.
Bottom line: I would really love to use subqueries but something seems
not right.
Andreas Pardeike
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
7;Cond. B' (which in
themselves can be complex) but I have no idea how to implement an 'AND'
like between 'Cond. B' and 'Cond. C'.
Is there a corresponding 'AND' version of the 'UNION' ?
Andreas Pardeike
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
1
Extra Using where
What's the point of indices if I cannot combine two indexed fields with
OR ?
Any help appreciated,
Andreas Pardeike
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
currently lacks.
Of course, my colleagues are concerned about the "alpha" state of the 4.1.x
version.
My question is: How is the general stability of the 4.1.x versions? Can it
be used for new projects, or is it so unstable that the risk is too high?
Greetings,
Andreas Buschka
Is there a way to automize the dupe check ?
I fear the day when I manually have to merge our second remote database
into the main db.
There we are talking of dupe killing in a pool of 3000 adresses that
goes into another one with 7000.
And I know there are a lot of dupes. :(
... Andreas
--
M
* Gaston Escobar
I need to sincronice two mysql databases that are in different
places. It is imposible to centralice everything in one database.
Then I would need to sincronice the changes made in both of them
one time per day. Is there any way to do this?
* Roger Baklund
This very much
like
to get one row with every category name in a field, separated by a
special character or something similar. Has anyone an idea to do that
without a extra query for each article?
Regards,
Andreas Ahlenstorf
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
Rob Wierenga wrote:
My PHP cann't connect anymore to the server.
The lib is not there i think. Because i get an error mysql_connect() doesnot exist.
PHP is linked to a certain build of the mysql client library.
If you exchanged the mysql server and all of the client stuff, you'll
need to rebui
your J2EE
application.
Check out your slow-log - the query is probably there.
--
Per Andreas Buer
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
essing time
cames from :( I have to wait and see, if the guys decide to redesign
the database, there are too much of flaws. Thanks for your help.
Regards,
Andreas
--
Eine Ferengi-Erwerbsregel besagt:
Pass auf, was du verkaufst; es könnte genau das tun, was der
Kunde erwartet.
--
MySQL General
Hum... The query takes something around 30 seconds and returns more or
less 3 mio rows with the same result. It should return only one
row. :(
- Andreas
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hello,
Roger Baklund schrieb am Freitag, 17. Oktober 2003 um 01:56:
> I think you need the LEFT JOIN:
> http://www.mysql.com/doc/en/JOIN.html >
I thought about that before, but how to catch up the problem, that I
have different tables where I have to get the ProdID and the
StationID?
les. But if that is not possible, I'll try that with
the temporary table.
Andreas
--
Eine Ferengi-Erwerbsregel besagt:
Pass auf, was du verkaufst; es könnte genau das tun, was der
Kunde erwartet.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
e
two fields StationID and ProdID at the end.
So, my big problem is: How to make that with MySQL without using any
scripting language and without big performance problems (the tables
have a lot of records)? If it isn't possible like that, is it possible
with minor changes on the database structure?
Regards,
Andreas Ahlenstorf
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Bruce Dembecki wrote:
Hi! I'm struggling to understand how to fix the mysqld_safe script for an
OSX machine. If I run "mysql.server stop" then the mysqld process is killed
and mysqld_safe promptly starts it again. I know mysqld_safe is supposed to
start mysqld if it stops but I also know there are
1 - 100 of 280 matches
Mail list logo
