Where can I find, if only mysqlbinlog on.
Jeremy Zawodny wrote:
> On Mon, Oct 29, 2001 at 04:59:45PM +0700, mahfud wrote:
> > Hi,
> >
> > I have mysql - bin -log, but when i read this I can't find IP number
> > from client who made connection to my server. How i find IP number
> > in mysql - bin
Do you have a "root" user? I had similar problem and set new password:
$shell> /usr/local/mysql/bin/mysqladmin -u root -h localhost -p password
'newpassword'
Then I could get access to all databases using:
$shell> /usr/local/mysql/bin/mysql -u root -h localhost -p'newpassword'
Of course,
I'm up to over 1 databases in one data directory and that is becoming a
performance problem as users make their connections. I would like to begin
running multiple servers on the same box.I made my first attempt tonight
and was confused. Before I screw up a production box perhaps someon
On Mon, Oct 29, 2001 at 04:59:45PM +0700, mahfud wrote:
> Hi,
>
> I have mysql - bin -log, but when i read this I can't find IP number
> from client who made connection to my server. How i find IP number
> in mysql - bin -log ?
You cannot. It isn't stored in the binary log.
Jeremy
--
Jeremy D
On Sun, Oct 28, 2001 at 03:49:12PM -0800, [EMAIL PROTECTED] wrote:
>
> Frankly, I don't understand how doing this fixes the problem,
> because now instead of the company name repeating (a string), the
> company name id (an int)repeats. Could someone explain (maybe
> convince is a better word) how
On Wed, Oct 31, 2001 at 12:44:23PM -0500, Harpreet wrote:
>
> I had a view on sqlserver which i am trying to convert to work with
> mysql. It uses a union which i believe does not work with
> mysql. What is another alternative for union.
MySQL 4.0 has unions.
But if you're not using 4.0 yet (mo
Hello,
How can i port database from SQLSERVER to MySQL. I tried using DTS of
SQLSERVER but it is failing to port data.
thanks in advance for any advice.
regards,
sreedhar
-
Before posting, please check:
http://www.mysql.c
>Help me ...
>
>this query ( query crosstab) in microsoft access .. ( success)
>
>TRANSFORM Sum(neraca.bsu) AS SumOfbsu
>SELECT neraca.ket_rek AS Keterangan
>FROM neraca
>GROUP BY neraca.no_rek, neraca.ket_rek
>ORDER BY neraca.no_rek
>PIVOT neraca.bln_thn;
>
>when me running in MYSQL ... ERROR ...
Help me ...
this query ( query crosstab) in microsoft access .. ( success)
TRANSFORM Sum(neraca.bsu) AS SumOfbsu
SELECT neraca.ket_rek AS Keterangan
FROM neraca
GROUP BY neraca.no_rek, neraca.ket_rek
ORDER BY neraca.no_rek
PIVOT neraca.bln_thn;
when me running in MYSQL ... ERROR ... why ??
tha
My thanks to Paul DuBois, who responded within about a minute of my first posting. :>
(Original question below.)
The solution is that "SQL_CALC_FOUND_ROWS" needs to be included in the original SELECT
query in order for FOUND_ROWS() to have the proper value.
SELECT SQL_CALC_FOUND_ROWS col1, col
I am using Linux7.1 PCQ version for my PC.I am
getting problem with installation stating that
mysqld.log file is not found in the particular
directory.Could you help me at the earliest.i am
installing from the rpm file.
Amal
__
Do You Yahoo!?
At 11:21 PM -0500 10/31/01, Robert Alexander wrote:
>Hi all,
>
>In the 4.0 manual, section F.1.1 "Changes in release 4.0" it says:
>
>"Added SQL_CALC_FOUND_ROWS and FOUND_ROWS(). This makes it possible
>to know how many rows a query would have returned without a LIMIT
>clause."
>
>Unfortunately,
On Wed, Oct 31, 2001 at 04:08:31PM +, Luis Ferro wrote:
> Hi there,
>
> After reading some debate under way in kernel lists, i'm curious
> regarding performance of MySQL under the two diferent VM currently
> in the kernels (Linus and Alan Cox kernels).
>
> Has anyone any info regarding this?
On Mon, Oct 29, 2001 at 09:49:08AM -0600, Carter, Robert L (MN65) wrote:
>
> Alternatively, is it possible to set up MySQL to be runnable from a
> CD-ROM, but using a hard-wired hard drive location in which to find
> the database tables?
Yes. This was discussed here about a week ago, so it shou
Ok here is the short version of the problem. Installed mySQL database on
Cobalt server RAQ4 using Linux. Everything worked great. Now the mysql
database that is created by default with user table etc...is empty!!! (Due
to a user going in using PHPmyAdmin and changing the user and password
with
Hi all,
In the 4.0 manual, section F.1.1 "Changes in release 4.0" it says:
"Added SQL_CALC_FOUND_ROWS and FOUND_ROWS(). This makes it possible to know how many
rows a query would have returned without a LIMIT clause."
Unfortunately, I can't find any other references to FOUND_ROWS() in the man
Hi all,
In the 4.0 manual, section F.1.1 "Changes in release 4.0" it says:
"Added SQL_CALC_FOUND_ROWS and FOUND_ROWS(). This makes it possible to know how many
rows a query would have returned without a LIMIT clause."
Unfortunately, I can't find any other references to FOUND_ROWS() in the man
So how do you use the HANDLER command in a C program?
I perused the code for 3.2x for this, and ended up installing mysql-4.0.0.
I found what I believe to be the code for HANDLER in
libmysqld/sql_handler.cc
in the functions,
mysql_ha_open, mysql_ha_close, mysql_ha_read
Am I correct (or, as I surm
On Wed, Oct 31, 2001 at 07:30:12AM -0800, Kyle Hayes wrote:
>
> Has anyone used LVM to create snapshots on a master in order to set
> up replication? We have specialized scripts that are getting harder
> and harder to maintain as we find weird edge cases and other
> annoying bits. Jeremy Zawodn
Hi,
You need to self-join payhistory along the lines of
select p1.* from payhistory p1, payhistory.p2 where
p1.payid = p2.payid and p1.paydate = max(p2.paydate)
Something like that, anyway - I know I had to fiddle around a bit to get a
similar think going.
Hope this help
Quentin
-Origina
Hello all,
I have 3 tables I need to join to extract certain data base on the acct_days in
the active table '6' days.
QUERY:
SELECT CONCAT(m.fname,' ',m.lname) AS name,
m.email,m.zip,p.paytype,p.event,p.paydate
FROM members m
LEFT JOIN payhistory p ON p.memid = m.memid
LEFT JOIN active a ON a.m
Well, the binary update log is a log file that records all the updates to a
database. They don't exist unless the mysqld process is started with the
option to log updates. They can be used to rebuild a database. I guess
that if you did not start the server with logging enabled, then you are SOL
hi,
>Something is really wrong. Can you rebuild your indexes with command
>"REPAIR TABLE tlcounter200109" ? What is your MySQL version? It should
>use index.
i used mysql server version: 3.23.43
And i want to speed up the test . i choose a part of data from
tlcounter200109 ( 56463703 records )
At 2:23 AM + 11/1/01, Alex Kirk wrote:
>Today, I started a temporary position at the US Export/Import Bank.
>They're a government agency that provides loans and other financing
>servies to small exporters and importers who can't get funds from
>their local banks.
>They put me to work cleani
On Wed, Oct 31, 2001 at 09:33:16PM -0500, Gary Huntress wrote:
> I'm sure you can get excellent support from MySQL AB, but I'm not
> sure you can get 1 hour response 24/365 support.
You should ask them. Their answer might surprise you. :-)
Jeremy
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Tech
Hi,
In my "real life" job, I'm a web/database/whatever developer for a DoD
lab. We made the jump from Access to client/server architecture quite a few
years ago. We evaluated many choices and settled at the time on Sybase. Of
course, MySQL did not exist then (or may have, just not in a use
Hi,
I'm not a PHPer, but in 'C', there is an API that can give you the MySQL
error message, which I am sure would explain the problem some more.
Quentin
-Original Message-
From: Ryan Booker [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 1 November 2001 3:30 p.m.
To: Quentin Bennett
Subject:
Today, I started a temporary position at the US Export/Import Bank. They're
a government agency that provides loans and other financing servies to small
exporters and importers who can't get funds from their local banks.
They put me to work cleaning up the database of their marketing division,
Hi,
I would like to ask if MySQL can work with ASP, providing I have installed
ChiliASP on a Unix server. Thanks.
Regards,
Raymond Tsang
Building Access Database Developer
PowerTel Limited
55 Clarence Street, Sydney 2000
Tel: 8264 3839
Fax: 8264 4555
Email: [EMAIL PROTECTED]
***
Hi,
What error message do you get.
Quentin
-Original Message-
From: Ryan Booker [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 1 November 2001 1:22 p.m.
To: [EMAIL PROTECTED]
Subject: Can't connect to new databases
I have recently installed mySQL 3.23.43. I will be using it to run a
webs
ddd
>Description:
>How-To-Repeat:
>Fix:
>Submitter-Id:
>Originator:root
>Organization:
>MySQL support: [none | licence | email support | extended email support ]
>Synopsis:
>Severity:
>Priority:
>Category: mysql
>Class:
>Release:
>Description:
>How-To-Repeat:
>Fix:
kkllklk
>Submitter-Id:
>Originator:root
>Organization:
>MySQL support: [none | licence | email support | extended email support ]
>Synopsis:
>Severity: <[ non-critical | serious | critical ] (one line)>
>Priority:
>Description:
>How-To-Repeat:
>Fix:
>Submitter-Id:
>Originator:root
>Organization:
>MySQL support: [none | licence | email support | extended email support ]
>Synopsis:
>Severity:
>Priority:
>Category: mysql
>Class:
>Release:
At 4:51 PM -0700 10/31/01, Nathan wrote:
>I have a table(2) with a different structure than the table(1) I'm
>selecting from. I want to be able
>to grab some info from table1, put it in table2, along with some
>variables from my php page. Is it
>possible to do like:
>
>INSERT INTO table2 VALUES
At 4:10 PM -0800 10/31/01, Bill Adams wrote:
>Paul DuBois wrote:
>
>> [snip]
>>
>> >Of all the methods suggested I like the look of the one above and will
>> >try that one first.
>> >
>> >$count = $sth->fetchrow_array();
>> >
>> >$rows = $sth->rows()
>>
>> Note that use of rows() to get th
At 3:16 PM -0800 10/31/01, Mike wrote:
>Okay, say I have a database with 10,000 entries in it. All entries
>have a unique id, but that ID is not exactly sequential (in fact,
>it's a 128-bit checksum).
>
>Now, given that ID, I need to find out what row # in the grand
>scheme that it is.
There's
Heikki,
The output I get from the Monitor does not have the section
--
LOCKS HELD BY TRANSACTIONS
--
that I see in the manual (www.mysql.com/doc), section 7.5.9.1, The InnoDB
Monitor.
I see two transactions issuing table locks to the same tables,
I have recently installed mySQL 3.23.43. I will be using it to run a
website (php/mysql). Using my php scripts I can connect to the server and
the default test database and select information from the table I created in
the test database. However, if I create a new database, not matter what
it'
I'm having a wierd problem with MySQL, that seems to be begging that I
wait for the next release, but I wonder if anyone else is getting this.
I'm running MySQL 3.23.42, and using the Berkeley DB table type to get
transactional ability. Occasionally, MySQL will simply stop accepting
INSERTs an
Paul DuBois wrote:
> [snip]
>
> >Of all the methods suggested I like the look of the one above and will
> >try that one first.
> >
> >$count = $sth->fetchrow_array();
> >
> >$rows = $sth->rows()
>
> Note that use of rows() to get the row count for a SELECT is deprecated
> in the DBI docs, which s
On Wed, Oct 31, 2001 at 10:49:12PM +, Federico Schwindt wrote:
>
> thanks for the reply. it seems to be clear now.
>
> > MySQL Doesn't allow you to specifiy which index to use - it chooses
> > (sometimes badly) whether or not to use one.
>
> From documentation:
>
> As of MySQL Versi
I've done that, too... but that's because MySQL's doc search engine is
interpreting the . as something special. If you search for other things
relating to that, you'll actually find an index saying "my.cnf
configuration options" or syntax.. something along those lines.
Weird stuff.
Mike
Les
I guess part of my question is:
. When did the change in the mysql code happen so that the -s switch is
added to hostname for the mysql_install_db?
. For what particular reason? :)
Thanks,
Atle
On Wed, 31 Oct 2001, Atle Veka wrote:
>
> On Wed, 31 Oct 2001, Dan Nelson wrote:
>
> > What p
The reason I don't use version 4.0 is that it is
a development alpha version. I do not know when
it will be beta or considered stable like 3.23.xx.
I have foreign key references in the schema
(same model as for other dbs we support) and though
up to version 3.23.43, these foreign key references d
I have a table(2) with a different structure than the table(1) I'm selecting from. I
want to be able
to grab some info from table1, put it in table2, along with some variables from my php
page. Is it
possible to do like:
INSERT INTO table2 VALUES 1,2,3 SELECT 4,5,6 FROM table1
Or do I need to
[snip]
>Of all the methods suggested I like the look of the one above and will
>try that one first.
>
>$count = $sth->fetchrow_array();
>
>$rows = $sth->rows()
Note that use of rows() to get the row count for a SELECT is deprecated
in the DBI docs, which say that if you want to know the number o
In the last episode (Oct 31), Atle Veka said:
> Is there any good reason for ``mysql_install_db'' to use the -s
> option to hostname instead of using FQDN? Every time I install mysql
> 3.23 out of ports, it fails running that script and I have to edit it
> manually and remove the -s option.
>
> #
On Wed, 31 Oct 2001, Dan Nelson wrote:
> In the last episode (Oct 31), Atle Veka said:
> > Is there any good reason for ``mysql_install_db'' to use the -s
> > option to hostname instead of using FQDN? Every time I install mysql
> > 3.23 out of ports, it fails running that script and I have to ed
Also note that a search for 'my.cnf' in the online documentation section of
mysql.com returns exactly zero (0) results. Hint, hint ...
Les Neste 678-778-0382 http://www.lesneste.com
--
I just looked into this myself since today was the first time I had to do
anything with the configuration.
The answer is, in the default installation, no conf file is created. (In
my case, I mean from instllating from source rather than from binary.) So
what you do is look for the unused-but-av
At 6:59 PM -0600 10/30/01, Ryan Winterbourne wrote:
>I was wondering if there is a way to download the MySql database
>hosted on a UNix machine running Solaris, to my Windows computer and
>be able to view and modify it from there? The Solaris version has
>.ISD and .ISM files wheras Windows has
I'm trying to configure MySQL to run on my Mandrake 8.1 box. The Linux
install automatically installed MySQL, albeit in some pretty strange
places, but it's there and running upon startup. I would like to modify
it so that it is not running as 'root' though on startup. I've read a
lot of the docu
Okay, say I have a database with 10,000 entries in it. All entries have
a unique id, but that ID is not exactly sequential (in fact, it's a
128-bit checksum).
Now, given that ID, I need to find out what row # in the grand scheme
that it is.
Let's take this test statement:
SELECT * FROM aucti
Gisella,
sorry, the printout in InnoDB Monitor is
ambiguous in its words: non-debug version
there means a version not compiled with
#define UNIV_SYNC_DEBUG
in univ.i
The monitor in .44 does not use the ambiguous
term any more.
But you do not need semaphore info, only user
lock info. When I sp
Rick Emery wrote:
>
> First: I believe this is not legal (looking at myySQL manual p 6.5.3):
> PRIMARY KEY (key1), KEY (key2)
> You may use one or the other.
yup, it does work here, ver 3.23.42.
> Second: You may search by either owner_id or customer_id without creating an
> index.
> Such as
thanks for the reply. it seems to be clear now.
> MySQL Doesn't allow you to specifiy which index to use - it chooses
> (sometimes badly) whether or not to use one.
From documentation:
As of MySQL Version 3.23.12, you can give hints about which index
MySQL should use when retrieving i
At 13:50 31/10/2001 -0800, Gisella Saavedra wrote:
Gisella,
The 3.23.xx tree wasn't compiled with flag for to
shows the semaphores section. The sample I sent
was using the 4.0.0-alpha release. Why you don't
try this release ?
Regards,
Miguel
>Miguel & Heikki,
>
>I tried
> mysqld-max-nt
Federico Schwindt wrote:
> hi,
>
> i'm not sure if this belongs here, but i cannot seem to find the
> answer anywhere else.
> first, what's the difference between:
>
> PRIMARY KEY (key1, key2)
> PRIMARY KEY (key1), KEY (key2)
The first line creates a single, unique key on the columns key
Hi,
In the first key, the combination of key1 and key2 must be unique, in the
second, key1 must be unique on its own, but key2 does not need to be.
Also, using the first primary key a
select col1, col2, ... where key2=value
cannot use the index but
select col1, col2, ... where key1=value
can
At 9:57 PM + 10/31/01, Federico Schwindt wrote:
>hi,
>
> i'm not sure if this belongs here, but i cannot seem to find the
>answer anywhere else.
> first, what's the difference between:
>
> PRIMARY KEY (key1, key2)
This creates an index within which pairs of key1/key2 values are unique.
First: I believe this is not legal (looking at myySQL manual p 6.5.3):
PRIMARY KEY (key1), KEY (key2)
You may use one or the other.
Second: You may search by either owner_id or customer_id without creating an
index.
Such as: SELECT * FROM mytable WHERE owner_id=123;
-Original Message-
F
has anyone ever seen this MySQL error? The database has a high-traffic table
with about a million rows, is this the problem?
Warning: MySQL: Unable to save result set
TIA,
Sincerely,
Daren Cotter
CEO, InboxDollars.com
[EMAIL PROTECTED]
http://www.inboxdollars.com
(507) 382-0435
--
hi,
i'm not sure if this belongs here, but i cannot seem to find the
answer anywhere else.
first, what's the difference between:
PRIMARY KEY (key1, key2)
PRIMARY KEY (key1), KEY (key2)
second, let's suppose the following table:
owner_id int(11),
customer_id int(11),
customer_in
Miguel & Heikki,
I tried
mysqld-max-nt --standalone --console
and now get the output on stdout, and mysql.err is not created.
BUT I still get the message non-debug version
under the SEMAPHORES section.
Gisella
-Original Message-
From: Miguel Angel Solórzano [mailto:[EMAIL PROTE
Miguel,
I can look at the file /mysql/data/mysql.err by using emacs. I do not need
to stop the server. If I try a Windows tool like WordPad?, yes,
it does not let me see the file.
Heikki,
I checked the task manager. I only have one mysqld running
which is the mysqld-max-nt. I had mysqlgui
At 22:52 31/10/2001 +0200, Heikki Tuuri wrote:
Heikki,
For you to have at the shell prompt the output is necessary
the command: mysqld-max-net --standalone --console
Like I show below:
Microsoft Windows 2000 [Versão 5.00.2195]
(C) Copyright 1985-1999 Microsoft Corp.
C:\>cd\mysql\bin
C:\mysql
ss
>Description:
>How-To-Repeat:
>Fix:
>Submitter-Id:
>Originator:root
>Organization:
>MySQL support: [none | licence | email support | extended email support ]
>Synopsis:
>Severity:
>Priority:
>Category: mysql
>Class:
>Release:
Hi all,
Is there any good reason for ``mysql_install_db'' to use the -s option to
hostname instead of using FQDN? Every time I install mysql 3.23 out of
ports, it fails running that script and I have to edit it manually and
remove the -s option.
# grep "/bin/hostname" work/mysql-3.23.36/script
sdsd
>Description:
>How-To-Repeat:
>Fix:
>Submitter-Id:
>Originator:root
>Organization:
>MySQL support: [none | licence | email support | extended email support ]
>Synopsis:
>Severity:
>Priority:
>Category: mysql
>Class:
>Release:
sdsd
>Description:
>How-To-Repeat:
>Fix:
>Submitter-Id:
>Originator:root
>Organization:
>MySQL support: [none | licence | email support | extended email support ]
>Synopsis:
>Severity:
>Priority:
>Category: mysql
>Class:
>Release:
At 10:32 AM -0500 10/31/01, <[EMAIL PROTECTED]> wrote:
>Hi
>
>I'm working on importing csv datafile returns Warnings, after carefully
>checking data I noticed that there are double quotes (") inside the
>records.
>
>mysql> LOAD DATA INFILE '/home/sql/data.csv' INTO TABLE csvdata
>FIELDS TERMINATED
At 2:47 PM -0500 10/31/01, <[EMAIL PROTECTED]> wrote:
>Hi
>
>I didn't see any difference between using optionally or not.
>
>Any solutions to make the two that fails work? (see test case below)
>
>Using 3.23.41.
>
>Thanks
The problem is that your CSV file isn't legal CSV. You'll need to
tell you
Since I sent this, I've noticed two things:
1. Somewhere in the process of reporting and working around problems in
the build process, I lost a few recommended CXXFLAGS. I started over from
scratch, so mysqlbug now reports
> Compilation info: CC='gcc' CFLAGS='-DHPUX -I/opt/dce/include'
> CXX=
Gisella,
>Heikki,
>I looked at the mysql error log and all the stuff was there.
>I was expecting it on the standard output as the documentation said.
it should come to the standard output. I am sending a copy
of this email to Miguel of MySQL AB. He should check why
mysqld started as --standalone
At 10:48 31/10/2001 -0800, Gisella Saavedra wrote:
Hi!
Take a look at /mysql/data/mysql.err for to see the output
for innodb_monitor.
I guess that you need to stop the server, for open this file.
Regards,
Miguel
>Heikki,
>
>thanks for the reply. Regarding the trace output, My test has been
>
> >>I didn't see any difference between using optionally or not. Any
> solutions to make the two that fails work? (see test case below) Using
> 3.23.41.
>
> That's a problem with your input data. You can't have the character that
> you're using to surround the fields within the f
Hi, your test.csv file has some flaws in records 5 and 7 because the
OPTIONALLY ENCLOSED BY char=" isn't matched for each column. Changing those
offending CSV lines to be instead something like:
> "Record 5","\"some\"data\"","Fails"
> "Record 7","some data\"","Fails"
and then modifying your LO
Heikki,
I looked at the mysql error log and all the stuff was there.
I was expecting it on the standard output as the documentation said.
Thanks again. I'll have to restart the server again since the
innodb monitor output on the error log says that I'm not running a debugable
version, so there
> When I create a table, one colum contains a space, how can I caeate it
> correctly?
>
> like:
>
> CREATE TABLE mytable(
> name CHAR(60) NOT NULL,
> Email VARCHAR(50) NOT NULL,
> Thrid colum CHAR(60), ///Here there is a
> space?
> PRIMARY KEY (Email)
>Description:
Configuring MySQL 4.0.0 with --with-ssl causes the server to
act as though interactive_timeout and/or wait_timeout were
set to approximately 6 seconds, although the variables seem
to have normal values.
>How-To-Repeat:
Hi
I didn't see any difference between using optionally or not.
Any solutions to make the two that fails work? (see test case below)
Using 3.23.41.
Thanks
test.csv:
"Record 1","some data","Works"
"Record 2",""some" data","Works"
"Record 3","some 'data'","Works"
"Record 4",""some" "data","Wor
>>Can i somehow create a temporary table and add all the rows i need and do
a select query from that temp table.
Yeah, that's the easiest way to do it.
Create temporary table A.
insert into A select
insert into A select
select * from A
If you want to mimic 'insersect' features
Rick Emery wrote:
> Try going with simply:
> SELECT T1.*, T2.* FROM tbl1 T1, tbl2 T2
> WHERET1.a=1AND T1.b=2 AND T2.a=2 AND T2.b=T1.b;
Well, if I resort to that then the documentation is wrong.
Here is what I am really trying to do. Say you have a table and data:
DROP TABLE IF EXISTS tbl
Hi!
> "Sinisa" == Sinisa Milivojevic <[EMAIL PROTECTED]> writes:
Sinisa> TAKAHASHI, Tomohiro writes:
>> Hi, All
>> I Fixed two bugs.
>>
>> 1. If LoginUser has empty password, Driver can not connect to MySQL.
>> 2. Connection Pool does not work correctly. ;-)
>>
>>
>> Check this URL out f
Hi,
We have just launched a non-profit open source jobsite. Check it out at
http://www.freeusall.com/ It's built on MySQL 4.0 (Alpha), Perl and
Apache. We'd appreciate any feedback you might have.
kind regards,
Mark Maunder.
Gisella,
>Heikki,
>
>thanks for the reply. Regarding the trace output, My test has been
>"bombarding" the db server with 15 simultaneous clients, each
>generating up to 1000 transaction sets.
this is strange. When you start the server from
the command promp, does it then print something
to the
Try going with simply:
SELECT T1.*, T2.* FROM tbl1 T1, tbl2 T2
WHERET1.a=1AND T1.b=2 AND T2.a=2 AND T2.b=T1.b;
-Original Message-
From: Bill Adams [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 31, 2001 12:21 PM
To: Mysql List
Subject: Left join w/o on or using join_condition
What do you mean "there's a space"? You mean after the comma in "CHAR(60),
"?
And you you provided is not what you entered into mysql, because "Thrid
colum CHAR(60)," won't work; "colum" is not a legal data type
-Original Message-
From: I. TS [mailto:[EMAIL PROTECTED]]
Sent: Wednesday,
Change:
LEFT JOIN (BillOfMat LEFT JOIN ItemMaster ON BillOfMat.CompNum
=ItemMaster.ParentNum)
ON BillOfMat_1.CompNum = BillOfMat.ParentNum
to:
LEFT JOIN BillOfMat ON BillOfMat_1.CompNum = BillOfMat.ParentNum LEFT JOIN
ItemMaster ON BillOfMat.CompNum =ItemMaster.ParentNum
You cannot do embedde
Heikki,
thanks for the reply. Regarding the trace output, My test has been
"bombarding" the db server with 15 simultaneous clients, each
generating up to 1000 transaction sets.
I still do not get any output from Innodb Monitor.
I created table innodb_monitor in the database that I'm accessing
I am using version 3.23 and dont think will be moving up to 4.0. Can i
somehow create a temporary table and add all the rows i need and do a select
query from that temp table. Neone done this before.
Thanks for ur responses and time,
Regards,
Harpreet Kaur
Software Developer
Crispin Corporations
> Subject: MySQL Authors Needed
>
>
> Hi,
>
> I am looking for experienced writers who would like to write a
> complete and
> authoritative reference on MySQL.
>
> Thanks,
>
>
> Chris Johnson
Paul DuBois has already done a bang-up job. His book, MySQL (New Riders),
is the bible as far as I'm con
for windows environment: http://sourceforge.net/projects/phptriad/
for linux: I've had complete success with Red Hat 7.1
-Original Message-
From: Demirchyan Oganes-AOD098 [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 31, 2001 11:43 AM
To: '[EMAIL PROTECTED]'
Subject: Off the shelf
Some other useful information on this problem:
I have tried the operation in two other ways, both based on a version of
the program with only one connection using the API and emiting the UPDATE
statments on standard output:
1. output piped onto mysql --> failure :-(
2. output saved on a fil
> Name: MySQL
> Display Name: MySQL
> Driver: org.gjt.mm.mysql.Driver
> URL:
> jdbc:mysql://192.168.0.2:80/studiosusa?user=root&password=axnolnms
I would assume that here is your problem, most likely mysql is not running
on port 80 on your machine and you should change it to 3306,
You use the ` char as a quote. (the backwards quote, right below the ESC
key on your keyboard with ~)
Chris
When I create a table, one colum contains a space, how can I caeate it
correctly?
-
Before posting, please check:
Harpreet wrote:
> I had a view on sqlserver which i am trying to convert to work with mysql.
> It uses a union which i believe does not work with mysql. What is another
> alternative for union.
>
> Sql with union:
>
> select a.asset_id,a.material_id,b.material_id as parent_material_id from
> lib_
You can't use brackets on left joins like that. If you want to do two left
joins, you use:
LEFT JOIN table1 ON conds LEFT JOIN table2 ON conds
That's why you're getting the error that mysql displayed, it doesn't expect
a bracket.
Chris
>>>SELECT DISTINCT ItemMaster.ParentNum, ItemMaster
My mind is not working with me this morning...
According to the manual about join syntax:
http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#JOIN
One should be able to do a LEFT JOIN without a
join_condition, eg. an "ON" or a "USING":
> table_reference LEFT [OUTER] JOIN
tab
I am a newbie.
When I create a table, one colum contains a space, how can I caeate it
correctly?
like:
CREATE TABLE mytable(
name CHAR(60) NOT NULL,
Email VARCHAR(50) NOT NULL,
Thrid colum CHAR(60), ///Here there is a
space?
PRIMARY KEY (Email)
);
W
1 - 100 of 181 matches
Mail list logo
