 | | | MySQL General | | I want to do something like this
delete from records where records.id in (select audit_log_records.id
from audit_log_records audit_log where
audit_log.tracker_id audit_log_records.tracker_id Rhino wrote
> >Ultimately simple but I don 't find the answer how to stop a list from
> >scrolling to the bottom when the command SHOW TABLES is entered.
> >
>I was wondering that myself so I toOropeza Querejeta Alejandro wrote
>Hi two questions
> Is it possible to select data from different Databases on the same
>server?
>Is it possible to select data from different Databases on DHi
I am trying to compile MySQL cluster source code on linux RedHat 9. The software required are all installed with the right versions. And I use the file BUILD/compile-pentium-max as suggested It depends on which version of MySQL you are using. Since you are using a
subquery I assume you are using a fairly new version.
Delete audit_log_records from audit_log_records audit_log where
> -----Original Message-----
> From Hassan Schroeder [mailto hassan@(protected)]
> kc68@(protected) wrote
>
> > When I do
> > mysql >SHOW TABLES \p less
> > I get the error message "Hi Marco
You can create one database for each user and grant access to this database
only for this user.
Laercio.
-----Original Message-----
From marco@(protected) [mailto marco@(protected)Hello List
I want to setup two servers (later more servers added) sharing mysql data as
a NFS Server & Client relationship
Server-A
----------
RH9 mysql-4.0.20 NFS Master
This server i "Carlos J Souza " <carlosjdesouza@(protected) > wrote
> Hello ALL
>
> I need a examples of stored procedures and triggers in mysql 5.0.
>
> Please send me all sintaxes of this
>
Triggers aresaiph <excapersgarden@(protected) > wrote
>
> mysql > update table1
> set c (select c2 from table2 where c2 'value ')
> where id 123
>
> give me an ERROR 1064.
>
>
> i.e.
>
> creatHey I have RedHat 9 with the default MySQL RPM pre-installed.
I 'd like to set up multiple instances of MySQL.
That is have multiple data directories(all with separate mysql database and
tablOn Mon May 31 2004 at 02 03 09PM +0200 Michael Arndt wrote
>
> Problem for this variant merge table has to be dropped and recreated
> periodically.
> Bernard Chambon wrote
> I try to understand index usage for 'order by '
> but that 's seemn hard to me.
> Here is what I have tried
>
> 1_ About documentation
>
> I have read carefully relatHello
got this error when upgrading our MySQL
rpm -Uvh MySQL-shared-4.0.20-0.i386.rpm
Preparing... ########################################### [100%]
file /usr/lib/libmysqlcliJaime <jcantais@(protected) > wrote
>
> I 'm using subqueries in MySQL 4.1.1 alpha. I use three subqueries and then want to get those combinations matching a given constraints. It is a veHi there
Can someone tell me what process MySQL follows to process SQL
statements/queries? Is it top down or bottom up?
Kind Regards
Schalk Neethling
Web Developer.Designer.ProgHello
In my application I am connecting to various RBDMS
but primarily SQL Server and MySQL using ODBC 3.0
driver. In SQL Server if I execute SQLCollAtrribute
with SQL_DESC_OCTET_LENGTH it iI 'm trying to come up with an efficient way to query my table of names for all first initials.
I.e. There are 50 000 names and I want a result of
A B C F H I J K...........
That is a liHello all
I am currently running mysql on a SuSE 9.0 machine. here is the mysql version
Server version 4.0.15
Protocol version 10
Connection Localhost via UNIX so
> Anyone know when we can expect 4.0.20 for Windows?
>
> Also is there a timescale for a beta version of 4.1?
>
> Cheers
>
> Andrew P.
>
> Andrew Pattison
> mail at apattison.plus.com
Hi!
Long-awaited MySQL-4.1.2 was released today. Windows binaries of 4.1.2 will
be released as soon as they are available. The binaries and source are
available for download at
http //dev.mysqlHi
I am new to MySQL and have one question.
I would like to run mysql job as a batch job (scheduled through cron) and have to provide password to the batch job
mysql -udba -ppassword
Randy Burgess <rburgess@(protected) > wrote
> Apologies for what is a pitifully simple question from someone who has
> just started using MySQL 4.0. I 've looked in the documentation and
> Hi
searching for latest MySQL-Downloads I see there 's no
mysql-4.1.2a-alpha-win.zip available by now on - for example -
ftp //ftp.fh-wolfenbuettel.de/pub/database/mysql/Downloads/MySQL-4.1/.
Hello
got this error when updating our MySQL
rpm -Uvh MySQL-shared-4.0.20-0.i386.rpm
Preparing... ########################################### [100%]
file /usr/lib/libmysqlclieAt 01 39 PM 5/29/2004 you wrote
>Hello
>
>Does the cluster support fulltext indexes?
>After a quick reading of preliminary documentation it seems NO.
>
>Can someone confirm it?
>
>Thank youAt 02 13 PM 5/29/2004 you wrote
>Hi
>
>I have database about national historical events and another one about world
>events..
>
>Here 's the structure
>
>National events (d day m moLAST_INSERT_ID is connection-specific not table-specific. When you say
SELECT LAST_INSERT_ID() FROM foo
you are asking for the LAST_INSERT_ID to be repeated once for each row of
table fOn Sat 29 May 2004 Yannick Warnier wrote
> > > - how wrong is creating 20 databases (total 400 tables) when you know
> > > you could create just one (total around 200 tables)?
> >
> > For linFor reference multiple-table updates are documented in the manual
<http //dev.mysql.com/doc/mysql/en/UPDATE.html >. They work starting with
mysql 4.0.4.
Michael
Peter Brawley wrote
> UP |
|
|
