[PHP-DB] MDB2 insert Oracle BLOB field problem

ot; Can someone help me with this? Thanks in advance, Rosen -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Transfer data between tables in MySQL

OTECTED] > insert into tableb (select * from tablea) > > bastien > > >>From: "Rosen" <[EMAIL PROTECTED]> >>To: php-db@lists.php.net >>Subject: [PHP-DB] Transfer data between tables in MySQL >>Date: Wed, 29 Nov 2006 13:44:24 +0200 >> >>

Re: [PHP-DB] Transfer data between tables in MySQL

OTECTED] > insert into tableb (select * from tablea) > > bastien > > >>From: "Rosen" <[EMAIL PROTECTED]> >>To: php-db@lists.php.net >>Subject: [PHP-DB] Transfer data between tables in MySQL >>Date: Wed, 29 Nov 2006 13:44:24 +0200 >> >>

[PHP-DB] Transfer data between tables in MySQL

Hi, I have to transfer all data between two tables ( with identical structure ) Is this possible with one query, or I must read from table1 and manually insert into table2? Thanks in advance, Rosen -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net

Re: [PHP-DB] Problem with executing Oracle query for creating procedure

"Christopher Jones" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > > Rosen wrote: >> Hi, >> i have problem with PHP and Oracle database. >> I read with PHP script an sql files like this: >> >> >> create or replace procedure

[PHP-DB] Problem with executing Oracle query for creating procedure

I have no problems. Can someone help me with this? Thanks in advance, Rosen -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Problem with Oracle

"Chris" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Rosen wrote: >> Hi, >> I have a problem with PHP and Oracle 10 Database. >> I read sql script from file and execute it. >> Files are something like this: >> >> insert in

[PHP-DB] Problem with Oracle

character" When I remove manually the ";" from the end of every row and execute separate every command everything is ok. I have and script files fo creating procedures/functions and there in not a problem with ";". Where is the problem ? Why can not be used ";"

Re: [PHP-DB] Problem with Oracle query

... > > SELECT DISTINCT > m.id > ,m.text > FROM main m > ,recs r > WHERE m.id = r.id >AND r.log like '%sometext%' > ORDER BY m.id > / > > > Roy A. Jones > Yes, Thath is ! Thank you very much! > > > > &qu

Re: [PHP-DB] Problem with Oracle query

me so much rows as many are the appearance the 'sometext' in the Recs table > > > Roy A. Jones > > > > > "Rick" <[EMAIL PROTECTED]> > 13-Oct-2006 10:53 > > To > php-db@lists.php.net > cc > > Subject > Re: [PHP-DB] Problem with O

[PHP-DB] Problem with Oracle query

), the log field contains some string. The records for one ID from Main table can be many in table Recs. ( Table Recs acts as log for every row from table Main). Can someone help me with this query? Thanks in advance, Rosen -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit

[PHP-DB] Problem with insert BLOB into Oracle

d print it, there is no problems, but when try to insert I receive an error:"Error: ORA-01465: invalid hex number" Can someone help ? Thanks, Rosen -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Case sensitive search

eturn me both rows. By default in MySQL comparing of strings is case-insensitive. How can I perform a case sensitive search in text fields ? Tnanks in advance, Rosen -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Temporary table name

Thanks, I'll try it. "John W. Holmes" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Rosen wrote: > > > No, I don't use it only in range of one script - it must be as "normal" > > table - several scripts to work with this tabl

Re: [PHP-DB] Temporary table name

PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Rosen wrote: > > Yes, I'm creating temporary table to store temporary data and after thath I > > delete this temporary table. > > What is the longest table name (in chars) fo MySQL table name ? > > How long does

Re: [PHP-DB] Temporary table name

Yes, I'm creating temporary table to store temporary data and after thath I delete this temporary table. What is the longest table name (in chars) fo MySQL table name ? Thanks in advance Rosen "John W. Holmes" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] >

[PHP-DB] Re: Temporary table name

Thanks, But is there a way to do this without additional table in which to store the names of created temporary tables ? Thanks, Rosen "Tim Van Wassenhove" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > In article <[EMAIL PROTECTED]>, Rosen wrote: >

[PHP-DB] Temporary table name

Hi, I need to create temporary table in mysql. And I generate random name - i.e. "TMP21567". How can I check is this name already exist in database ? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Table locking

some fictive table with one record and before start appending data in table 1 and table 2 to lock this fictive table. If I perform "LOCK " should be MySQL waiting until another process unlocks this table ( if another user is appending data ) and then to lock table ? Thanks in advance

Re: [PHP-DB] Table locking

meone else to insert data in table2, because will be a problem with orders. Now I insert data first in table2 and then insert main record in table1 with the range of id's of detail order data. Could be some solution for this ? Thanks in advance. Rosen "John W. Holmes" <[EMA

Re: [PHP-DB] Table locking

user&pass for all users in database ? Thanks in advance ! Rosen "John W. Holmes" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Rosen wrote: > > > And if I perform "LOCK tables ..." nobody can;t write on these tables, > > until I don

Re: [PHP-DB] Table locking

And if I perform "LOCK tables ..." nobody can;t write on these tables, until I don't perform "UNLOCK TABLES" ? If something happens ( I mean if some my queryes fails) ? "Jason Wong" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] &g

Re: [PHP-DB] Table locking

Thanks, but can you give me a sample PHP script with MySQL database, whitch do this? Thanks "Jason Wong" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > On Friday 09 July 2004 07:09, Rosen wrote: > > Is thath mean, thath, when one user is addind records

Re: [PHP-DB] Table locking

AIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Rosen wrote: > > > I have the following situation: I have to prevent users to write at the same > > time in one table in PHP script. > > Is there a way the PHP to "understand", thath another user is fillin

[PHP-DB] Table locking

Hi, I have the following situation: I have to prevent users to write at the same time in one table in PHP script. Is there a way the PHP to "understand", thath another user is filling table, and to wait before begin to fill data? Thanks in advance! -- PHP Database Mailing List (http://www.php.n

[PHP-DB] PHP DB class

Hi, Can someone help me - I'm looking for PHP class for transaction managment and record lock/unlock in InnoDb MySQL tables ? Tnaks in advance, Rosen -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] PostgreSQL on Windows

Hi, Can I start PostgreSQL server and client on Windows machine ? Thanks in advance! Rosen -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Paradox tables

Thanks, I need someone, who created this to know is this reliable ( I mean Paradox & PHP ) Thanks, Rosen "Jeffrey N Dyke" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > if you can connect via odbc, you can use php with it. > > i just googled ->

[PHP-DB] Paradox tables

Hi, Is there a way with PHP to process data from Paradox tables ? Thanks, Rosen -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Exporting database

Hi, Can someone tell me where can I find a function or class for export MySQL database (structure & data ) into text file ? Thanks, Rosen -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Problem with MySQL 4.0.4 beta

Hi, I just installed MySQL server on WIndows 98 and when server starts the window with "mysqld-opt" opens and stop responding. And server didn't start. Any ideas for this? Thanks, ROsen -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Append into another table

Hi, how can I append from one table to another with same structure some selected records Thanks, Rosen -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Import/Export data

Hi, How can I import/Export data to MySQL database using PHP following formats: EDI, Access, Excel ? Where can I find information about this ? Thanks, Rosen Marinov -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Problem with SQL query on several tables

Thanks, but I want wo JOIN data from three tables and then to order all data by "datestamp". Can I Do It ? Thanks, Rosen Andrey Hristov wrote in message <071401c17759$f5873c80$0b01a8c0@ANDreY>... >Mysql says that in the join there are some columns with namer datestamp so

[PHP-DB] Problem with SQL query on several tables

etime. Why I can't order query on 'datestamp' ? Thanks, Rosen -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]

[PHP-DB] Help you with our programming skills and experience

Hello, We are a team of experienced programmers with skills of PHP/Perl/JAVA/C++/VB/Servlet/JSP/ASP/PowerBuilder/XML/ DHTML/WAP & WML with database of MySQL/MS Access/ MS SQL/ORACLE/DB2/Sybase/Informix. We are experienced in programming for various E-Commerce web site and standalone application

[PHP-DB] Date field

Hi, Can someone tell me how do stote date field in MySQL DB ? Thanks, Rosen M. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]

Re: [PHP-DB] MySQL manager

Yes Thanks, Rosen Marinov ""Michael Rudel"" <[EMAIL PROTECTED]> wrote in message 005e01c0b6e1$f70dd6b0$[EMAIL PROTECTED]">news:005e01c0b6e1$f70dd6b0$[EMAIL PROTECTED]... > what about kmysql and kmysqladmin ?? > > Greetinx, > Mike > > >

[PHP-DB] MySQL manager

Hi, can anybody tell me for some cool MySQL database manager ? Thanks, Rosen Marinov -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]

[PHP-DB] About MySQL connections

Hi, I use "mysql_pconnect" function to connect to MySQL server. When I call function second time I receive error: "Warning: MySQL Connection Failed: Too many connections in /website/transfer.php on line 17" Please HELP! Rosen MArinov -- PHP Database Mailing List

Re: [PHP-DB] Help ! MySQL Problem

Thanks, but the idea is to transfer data between two tables with same structure. Rosen Marinov ""karakedi"" <[EMAIL PROTECTED]> wrote in message 987ggc$mca$[EMAIL PROTECTED]">news:987ggc$mca$[EMAIL PROTECTED]... > ok you must get your variables like row

Re: [PHP-DB] Help ! MySQL Problem

Thanks, but it doesn't work ! "Brinzoi Constantin Aurelian" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > On Thu, 8 Mar 2001, Rosen wrote: > > > Hi, > > I'm using MySQL database and I try: > > &qu

[PHP-DB] Help ! MySQL Problem

Hi, I'm using MySQL database and I try: " insert into roubr('id','pos','name') values ( select id,pos,name from requestroubr) " and it don't work ! Please help! Rosen Marinov -- PHP Database Mailing List (http://www.php.net/) To uns

Re: [PHP-DB] Transfering data between MySQL servers

Thanks, but i have mean to transfer with SQL script. Can I do it ? Thanks, Rosen Marinov ""Rosen"" <[EMAIL PROTECTED]> wrote in message 95u3f9$4p0$[EMAIL PROTECTED]">news:95u3f9$4p0$[EMAIL PROTECTED]... > Hi, > I have MySQL server on my local machine with

[PHP-DB] Transfering data between MySQL servers

Hi, I have MySQL server on my local machine with some database. How can I transfer the database to remote server ? Thanks, Rosen Marinov -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact

[PHP-DB] Error connect to MySQL

Hi, While I try to connect to remote MySQL server i recieve "Can't connect to 'host' (10060). Where I can get description of retrieved error ? Thanks, Rosen Marinov -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additio

Re: [PHP-DB] Connection to MySQL

What is mysqld ?? Rosen Marinov ""miso"" <[EMAIL PROTECTED]> wrote in message 946qqn$sbr$[EMAIL PROTECTED]">news:946qqn$sbr$[EMAIL PROTECTED]... > you should probably start mysqld :)) > > miso > > ""Rosen"" <[EMAIL PROT

[PHP-DB] Connection to MySQL

Hi, When I try to connect to server I get message "Can't connect to MySQL server on "host" (10060 )! Please Help! Thanks Rosen Marinov -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL P

Re: [PHP-DB] HELP! Manage MySQL

Thanks! But when I try to connect to server I get message "Can't connect to MySQL server on (10060 )! Please Help! "David Tod Sigafoos" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Hello Rosen, > > Wednesd

[PHP-DB] HELP ! Connect to MySQL

Hi, When I try to connect to MySQL server i get error code "10060" ! Please HELP! -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]

[PHP-DB] HELP! Manage MySQL

Hi, Can someone tell me how can I manage MySQL database on remote server ( With what software ) ? Thanks, Rosen Marinov -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list