RE: mysql query

try the left join: select MYTABLE.* from MYTABLE left join ANOTHERTABLE on MYTABLE.entry = ANOTHERTABLE.entry where ANOTHERTABLE.entry is NULL; -Original Message- From: Ian Harisay [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 10, 2002 8:10 AM To: [EMAIL PROTECTED] Subject: Re

dbi:Oracle connections always go through Net8?

SQL> connect username/password are not through the listener at port 1521 I wonder if it is possible to make connections within dbi on the local host which runs the instance like $dbh = DBI->connect("dbi:Oracle:", "internal", "/anything"); to bypa

RE: mysql traffic...

there is the mysql> show processlist; command to list the current connections to the db and you can use it in your program... > Dong Wang > Grand Central Networks > [EMAIL PROTECTED] -Original Message- From: Sandip Debnath [mailto:[EMAIL PROTECTED]] Sent: Monday

RE: Select X number of rows

IF the first row is considered as row 1 rather than row 0, then it should be: SELECT o.Column1, o.Column2, o.Column3 FROM Sometable o WHERE (SELECT Count(*) FROM Sometable i WHERE i.Column1 <= o.Column1) BETWEEN 31 AND 40 > Dong Wang > Gran

RE: DBI/DBD Oracle - chopping trailing spaces

p_results; ### produced the following result: 'b', 'b', 'b' 'c ', 'c ', 'c ' 'a ', 'a ', 'a ' 3 rows > Dong Wang > Grand Central Networks > [EMAIL PROTECTED] -Original Me

performance comparison of two update statements

c3 = 'd' where c1 = 'a'; They both result in the same final result, but does statement2 involves some extra work on the index created on c2 so statement1 is more efficient? From the programmers point of view, it is easier to write some generic update statements without know exactly

RE: Oracle prepare failed?

privilege granted to the dbi user on one of the tables > Dong Wang > Grand Central Networks > [EMAIL PROTECTED] -Original Message- From: Michael Ragsdale [mailto:[EMAIL PROTECTED]] Sent: Monday, September 17, 2001 12:01 PM To: [EMAIL PROTECTED] Subject: Oracle prepare failed?

read clob data from Oracle using DBI/DBD

# When I run the above codes, it returned DBD::Oracle::st fetchrow_array failed: (DBD NEED_DATA: OCILobRead) at test_clob.pl line 11. Anyone knows what is causing this error? Thanks. > Dong Wang > Grand Central Networks > [EMAIL PROTECTED] >

RE: Access permissions problem.

I think that is related to the set up in the user table in MySQL db. Maybe the user is allowed to connect from "localhost" but not any other hosts. Add a record for that user with same privileges and a '%' for the Host column may help. > Dong Wang > Grand Central N

RE: ORA-00604 and 0RA-04031 errors on connect

SYS.DBMS_STANDARD, SYS.DBMS_APPLICATION_INFO, etc. Hope this helps. > Dong Wang > Grand Central Networks > [EMAIL PROTECTED] -Original Message- From: Ann Bruyneel [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 16, 2001 2:44 AM To: [EMAIL PROTECTED] Subject: ORA-00604 and

How to preserve end spaces in MySQL

1, "***") from temp; +---+ | concat(c1, "***") | +---+ | a*** | +---+ 1 rows in set (0.00 sec) How can I preserve the ending space? > Dong Wang > Grand Central Networks > [EMAIL PROTECTED]