Erik Olsen wrote:
Is it possible for slave to connect to 2 different masters and have
synchronized database from both?
So you would have updates on 2 masters M1 and M2 which would be
replicated to the read-only slave S1 ?
The point of MySQL's replication is that after an replication-event
there
Hi folks,
how would you design a 1:1 relation ?
I'd like to split an entities's attributes because they won't get
equally frequently requested. So I can save memory and disk access time.
The integrity of the splitted record should be retained.
The key points would be:
1) devide the data collumn
Hi list,
I got me a copy of mysqlcc 0.9.2-beta and installed it on my win 2000 box.
No complaints so far.
There is an icon on the desktop.
I click it and for a really short moment there is a sandclock and then
nothing happens. Mysqlcc just dosn't bother to appear.
I went to the c:\programme\mysq
Hello :)
I have an development/test server on a windows 2000 box running.
AFAIK mysql needs 127.0.0.1 to connect to the localhost, if I use it on
the db-server's machine.
Usually I'd connect via LAN so I need mysqld listen on 2 IPs.
1) 127.0.0.1
2) 192.168.1.42<-- LAN-IP
This box has a secon
Hello Nils,
thanks for your answer. :)
First for the localhost entry. You will define a grant command like [...]
Then for the remote connection you use [...]
Right, that is somewhere in the online docu in the area of "adding a user"
I prefer just to have the needed ports open rather than to fi
Boris Villazon wrote:
Step 1
The secondary pc copies only the new incoming data from primary pc database.
Step 2
When the secondary pc copies the data, the primary pc has to delete all these copied records (in the local database).
Could I use replication technique to achieve this process? If yes,
Hans-Peter Grimm wrote:
Looking at the my.ini file for suspicious options, I found that changing
the line
socket= /tmp/mysql.sock
to
#socket= /tmp/mysql.sock
(commmenting it out) makes mysqlcc work again.
Does this help?
YES ! Perfectly ! :)
Thanks
--
MySQL General Mai
Robert Morgan wrote:
Hi, I'm doing a project for a local hospital, they want to migrate
their access databases to mysql on a Linux box.
Depends how big the whole thing is as well as how good the current
design is. Since it is running in a hospital I hope the Access approach
was propperly done a
Hello list,
is there a common naming system for db objects ?
Like:
1) Tables: mytable, tblmytable, tbl_mytable
2) Indices: idx_anindex
3) Columns: int_somenumber, date_lastupdate
4) id for the numerical primary key e.g. table customers.id
and then for referencing foreign keys
table
had to be updated on every ip-up event.
And '%' is no good either since it would weaken mysql's security.
1) Why gets such a remote request transcribed to a request of the
server's external address ?
2) How can I have mysql check for client.dyndns.org ?
Thanks
Andreas
--
M
Jim Smith wrote:
Wasn't my question.
well ... it was mine but I'll share it with you ;)
Why do you need to label a table as a table?
That was my thought, too.
There is some merit in using
type prefixes in VB because of its loose typing, but it makes no sense in a
database context where the t
Bill Hernandez wrote:
I followed the install instructions at http://entropy.ch , and was able to
get mySql & php installed on my G4 -> (OSX 10.2.6) last night. I downloaded
Navicat and setup a password for the mysql user. I created a connection
called myDatabase_connection to a database called myD
Jim McAtee wrote:
Does MySQL automatically listen on all IP addresses bound to the machine on
which it runs? (MySQL 3.23.xx on Windows 2000).
AFAIK it's one or all.
The default is all.
If you put a bind-address 192.168.0.1 line in your c:\winnt\my.ini
mysql would only listen on that specific
Chris Moy wrote:
$mysqld_safe --user mysql &
[EMAIL PROTECTED] mysql]# Starting mysqld daemon with databases from
/var/lib/mysql
030812 13:24:04 mysqld ended
but you can see that the deamon has "ended" right away. This should not
happen, correct?
look in the err-file.
It's named laptop.err and l
the permissions not the lack of the file.
I think I need to take three steps back, and figure out where the beginning
is? Thanks for the help...
no problem ...
Andreas
Germany
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
--- Begin Message ---
On 8/9/03 11:20 PM, "Andreas" <[EMAIL PROTECTED]> wrote:
Andreas,
Thanks for the help...
The error log shows:
030810 14:52:48 mysqld started
030810 14:52:49 InnoDB: Started
030810 14:52:49 Fatal error: Can't open privilege tables: Table
'
Glen Boyer wrote:
Can anyone tell me if your product can or will do Bi-Directional
Replication.
I did this some time ago.
Host A and B
You just configure host A as master and host B as slave of host A.
Then you do the same vice versa.
There is a description in the manual.
>
A BIs a
ion should limit the
vulnerable timeframe down but what about our traveling dude who dials up
every evening with his notebook.
Not to mention that a second site with a fast line would have to wait
for our road warrior to get it's updates from the main site since the
... Andreas
--
MySQL Gene
I'll forward this conversation to the list since I'm no mysql guru and
others with more knowledge might step in.
Glen Boyer wrote:
Let me ask you this, If I may ?
You have Server A in San Diego and Server B in New York
You have replication between A ---> B
You have replication between B ---> A
Robert Mark Bram wrote:
and Clients 3.23.55" and then in stall 4.1, how will my "MySQL ODBC 3.51
Driver" driver know to connect to 4.1 now? Is there anything else I
need to do?
If you also dumped and removed the database files then you probaply have
to reinstall the 3.23.xx or an 4.0.xx to creat
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
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
* 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
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
to to slave, I suppose.
How can I sync them without losing the updates that happened on box B ?
OK, I know that's probaply a hard one but perhaps someone ran into this
before.
... Andreas
-
Before posting, please c
Hsiao Ketung Contr 61 CS/SCBN wrote:
Does each version of MySql has binary AND src version for installation ?
yes
I found binary version only.
look again
it's on the bottom of the page
Does the majority of MySql user us the binary version ?
dunno ... but it works, so why bother ?
W
Benjamin Pflugmann wrote:
Look up mysqldump and mysql in the manual. You want to do something
like this:
targethost$ mysqladmin create new_database
targethost$ mysqldump -h oldhost some_database | mysql new_database
at least if he hasn't used innodb with foreign keys
AFAIK mysqldump is not cl
Alex Garcia wrote:
I have installed mysql form the rpm files that are on rpm finder, acording
to the installation it is working, and if I check with
redhat-config-services it is running, how do I get mysql on the path so I
can call mysql from any where?
There are a few ways to do that.
I've got
Ryan McDougall wrote:
when I do this this is what I get:
starting mysql with databases from /var/lib/mysql
This may be your culprit right here... not sure where the mysql_install_db
defaults its installs to, but I'm guessing its not /var/lib/mysql. And you
installed everything into /usr/local/mysq
RESTRICT is, of course, the default 'action'. ON DELETE and ON UPDATE are
later additions.
Paul DuBois wrote:
I see in the change notes that ON UPDATE was implemented in 4.0.8.
But how can ON DELETE be a later addition than RESTRICT? I was under the
impression that RESTRICT wasn't even implement
I'm trying to get going with InnoDB.
As for now I created several tables which relate to each other with some
foreign key restrictions.
mysqldump --all --opt writes 6++ MB stuff in a textfile that mysqld
won't accept without SET FOREIGN_KEY_CHECKS=0;
After SET FOREIGN_KEY_CHECKS=1; is my
I could not start ./safte_mysql.
Error message:
touch: /usr/local/mysql/var/gemini.err cannot create
chown: /usr/local/mysql/var/gemini.err: No such file or directory
Starting mysqld daemon with databases from /usr/local/mysql/var
./safe_mysqld: /usr/local/mysql/var/gemini.err: cannot create
the "
Slawomir Orlowski schrieb:
I could connect with new /usr/local/mysql/bin/mysql client (old one was not
working) and select data from moved databases.
problem is that web pages are not working any more,
The old one doesn't find the socket.
I did and it worked, but I do not know what to do in
Miso Simovic schrieb:
when i try to run the MySQL server, this happens:
[EMAIL PROTECTED] root]# /usr/bin/safe_mysqld
Starting mysqld daemon with databases from /var/lib/mysql
030324 21:09:10 mysqld ended
1) You have to "be" in the /usr directory and type ./bin/save_mysqld
2) This will block
lable right now.
Thanks ... Andreas
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]&
n.
InnoDB is part of standard as I understand.
So what's left ?
... andreas
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To r
when
accessed.
FYI
Andreas
P.S. please CC me ... I'm not subscribed to the list. Thanks.
--
GMX - Die Kommunikationsplattform im Internet.
http://www.gmx.net
-
Before posting, please check:
http://www.mysql.com/manual.
on additions or corrections.
Any pointer to documentation in that matter would be appreciated.
regards ... Andreas
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
How could I handle concurrent updates on the same record if I dont
maintain an update-timestamp on every datafield ?
For now I suspect that such update conflics will appear very rare
because they only relate to the limited set of shared
Hi,
I'm trying to figure out a viable two site configuration.
Currently I got as far as to a ultra-early stage 2 box test system in a
LAN which does 2-way replication.
One runs LINUX and the other one Win2K. I have MySQL 4.0.4 on both.
Now the bin-logs are piling up on both machines. Well, sort
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]
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]
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]
, 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
.
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
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]
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
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
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]
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
.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
.
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
----
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,
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]
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
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 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...
> >
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
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
---+
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
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
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
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
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
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
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
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
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
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
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
[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
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
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
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
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.
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
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
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
,
Andreas Streichardt
--
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
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
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
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
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,
asier.
Regards,
Andreas
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
#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]
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
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]
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]
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]
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]
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]
27; for help. Type '\c' to clear the buffer.
mysql> use myFineDb;
ERROR 1044: Access denied for user: '[EMAIL PROTECTED]' to database 'myfinedb'
mysql>
I have tried variations of the upper grant command with no succes either:
...to 'abc'@&#x
No success either, thank you anyway.
[mac:~] reuleaux% mysql -u root -p***
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 25 to server version: 3.23.56
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> grant all on myFineDb.* to
ck to the stable debian/fink pkgs,
but they will go on to 4.x one day, too.
Andreas
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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
--
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
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
1 - 100 of 280 matches
Mail list logo
