[PHP-DB] MDB2 insert Oracle BLOB field problem
Hi, I'm trying to insert into Oracle BLOB field with MDB2 package. I'm using prepared query ( prepare() execute() ). The value for BLOB field I have in string variable. And I got an error: Native message: ORA-01461: can bind a LONG value only for insert into a LONG column 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
[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/unsub.php
Re: [PHP-DB] Transfer data between tables in MySQL
Thanks very much! Before I try something like insert into tableb values (select * from tablea) and it didn't work, but now I see the word values is no needed. Thank you Bastien Koert [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] 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 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/unsub.php _ Find a local pizza place, music store, museum and more then map the best route! Check out Live Local today! http://local.live.com/?mkt=en-ca/ -- 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
Thanks very much! Before I try something like insert into tableb values (select * from tablea) and it didn't work, but now I see the word values is no needed. Thank you Bastien Koert [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] 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 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/unsub.php _ Find a local pizza place, music store, museum and more then map the best route! Check out Live Local today! http://local.live.com/?mkt=en-ca/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
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 test_proc1(p1 IN number, p3 OUT number) as begin p3 := p1 + 10; end; And when I execute it I receive an error: Warning: ociexecute(): OCIStmtExecute: OCI_SUCCESS_WITH_INFO: ORA-24344: success with compilation error in... And the procedue doesn't put in the database. When I edit the .sql file - all to be on 1 row - like this: create or replace procedure test_proc1(p1 IN number, p2 OUT number) as begin p2 := p1 + 10; end; Then I have no problems. Can someone help me with this? Thanks in advance, Rosen Normally I'd use a tool such as SQL Developer or SQL*Plus to pre-create database resident things like tables and PL/SQL procedures. Yes, but this is update system, i.e. - it will need to execute scripts from .sql files to many servers. The procesures/functions must be wrapped with wrap.exe before executing. This is very important. However, back to your problem: use UNIX style end of line characters. Or build up the statement using PHP string concatenation. How can I do this? Can you give me some example. Thanks in advance, Rosen Chris -- Christopher Jones, Oracle Email: [EMAIL PROTECTED]Tel: +1 650 506 8630 Blog: http://blogs.oracle.com/opal/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Problem with executing Oracle query for creating procedure
Hi, i have problem with PHP and Oracle database. I read with PHP script an sql files like this: create or replace procedure test_proc1(p1 IN number, p3 OUT number) as begin p3 := p1 + 10; end; And when I execute it I receive an error: Warning: ociexecute(): OCIStmtExecute: OCI_SUCCESS_WITH_INFO: ORA-24344: success with compilation error in... And the procedue doesn't put in the database. When I edit the .sql file - all to be on 1 row - like this: create or replace procedure test_proc1(p1 IN number, p2 OUT number) as begin p2 := p1 + 10; end; Then 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
[PHP-DB] Problem with Oracle
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 into pts (pid, txt) values (1,'502a'); insert into pts (pid, txt) values (2,'502b'); . I receive a message: ORA-00911: invalid 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 ; as command separator from PHP ? Thanks in advance! Rosen -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Problem with Oracle query
Hi, I have a problem with PHP and Oracle SQL query. I have 2 tables : Table Main: --- id number text varchar2(100) Table Recs --- id number pos number log varchar2(200) I need to make query to select a list from first table(Main), where somewhere in the second table (Recs), 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: http://www.php.net/unsub.php
Re: [PHP-DB] Problem with Oracle query
[EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Try this ... SELECT m.id ,m.text FROM main m ,recs r WHERE m.id = r.id AND r.log like '%sometext%' ORDER BY m.id / Thanks, but this retrieves 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 Oracle query Brad Bonkoski [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Rosen wrote: Hi, I have a problem with PHP and Oracle SQL query. I have 2 tables : Table Main: --- id number text varchar2(100) Table Recs --- id number pos number log varchar2(200) I need to make query to select a list from first table(Main), where somewhere in the second table (Recs), 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 select m.id, r.log from main m left outer join recs r on r.id = m.id This will output something like: Id log 1log item 1 1log item 2 1log item 3 2another log etc... Thanks, but I want to retrieve only one row for ID field (row from Main table) where the string contains in second table. Something like this: ID Text 1 Sometext 1 2 Sometext 2 6Sometext 3 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Problem with insert BLOB into Oracle
Hi, I have problem with inserting into BLOB field in Oracle 10: insert into some_table(DESC) values ( '$txt') The DESC field type is LONG RAW The $txt variable contains large text, whitch is extracted from another table field with same type. When I read field DESC and 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
Hi, I have a simple table: test ( id int unsigned NOT NULL auto_increment, data varchar(30) default NULL, PRIMARY KEY (id)) with two simple records: id data 1 a 2 A When I perform select * from test where data='a' - it return 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
[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
[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: 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 ? SELECT COUNT(*) AS count FROM temporary_table WHERE name='TMP21567'; Probably you'll want to make the name the primary key or at least unique. This way you save yourself from adding duplicate entries with the same name. -- Tim Van Wassenhove http://home.mysth.be/~timvw -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
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] Rosen wrote: 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 ? If you're creating a true temporary table, then you don't need to worry about the name being unique. CREATE TEMPORARY TABLE tmp21567 ... Even if two PHP scripts run at the same time and issue this query, the temporary table is created on a per-connection basis and will not conflict with each other. -- ---John Holmes... Amazon Wishlist: www.amazon.com/o/registry/3BEXC84AB3A5E/ php|architect: The Magazine for PHP Professionals www.phparch.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Temporary table name
No, I don't use it only in range of one script - it must be as normal table - several scripts to work with this table and after the last script finish - it delete the table. This may take a time about 20-30 minutes ( until user enter data ) John W. Holmes [EMAIL 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 it exist for? If it's only used during the life of the script, then use TEMPORARY when you create it and you can use anything for the name. You don't have to worry about it being unique. -- ---John Holmes... Amazon Wishlist: www.amazon.com/o/registry/3BEXC84AB3A5E/ php|architect: The Magazine for PHP Professionals www.phparch.com -- 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 table and after the last script finish - it delete the table. This may take a time about 20-30 minutes ( until user enter data ) Okay. Use uniqid() to create a string for the table name. The only way you're going to know if it's duplicate is to either catch the error when you create the table or attempt to select something from it or show columns from it... If you're using uniqid(), though, you shouldn't run into duplicates very often. -- ---John Holmes... Amazon Wishlist: www.amazon.com/o/registry/3BEXC84AB3A5E/ php|architect: The Magazine for PHP Professionals www.phparch.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Table locking
I need to be sure, thath nobody else will can write on some tables until I don't append obout 4-500 records in these tables. But until now I never used table locking in MySQL and I didn't found information about this ( like examples ). Is there a problem with locking if PHP uses same userpass 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't perform UNLOCK TABLES ? If something happens ( I mean if some my queryes fails) ? I have a feeling it would be very very good if you'd state why you feel you need to LOCK these tables. There are generally a couple ways to do things, so you may not need to worry about locking at all. -- ---John Holmes... Amazon Wishlist: www.amazon.com/o/registry/3BEXC84AB3A5E/ php|architect: The Magazine for PHP Professionals www.phparch.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Table locking
I have an orders with one main record in table1 ( client, date, e.t.c. ) and detail description in table2 ( all materials with quant, price, e.t.c. ) and I save data in table1 for positions (range of id - autoinc field of records in table2) for detailed data of order . And I don't want someone 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 [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Rosen wrote: I need to be sure, thath nobody else will can write on some tables until I don't append obout 4-500 records in these tables. But until now I never used table locking in MySQL and I didn't found information about this ( like examples ). You could try a multi insert syntax such as INSERT INTO yourtable (a,b,c) VALUES (1,2,3),(4,5,6),(7,8,9); which will insert three rows into the table. Couldn't confirm in the manual, but this INSERT should run completely before anything else does. I still have to question _why_ another INSERT in the middle of your insertion will mess things up. Sounds like the problem is there. Is there a problem with locking if PHP uses same userpass for all users in database ? No. The LOCK is on a per connection basis and is not tied to the username and/or password. -- ---John Holmes... Amazon Wishlist: www.amazon.com/o/registry/3BEXC84AB3A5E/ php|architect: The Magazine for PHP Professionals www.phparch.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[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.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Table locking
Is thath mean, thath, when one user is addind records to table, and lock it - when another user is trying to get the max field value for some field, the script will waiting the first user to unlock table and then to see the max value of some field in a table ? John W. Holmes [EMAIL 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 filling table, and to wait before begin to fill data? Most databases have a LOCK command that you can issue. The other scripts that end up running at the same time will wait until the lock is released. -- ---John Holmes... Amazon Wishlist: www.amazon.com/o/registry/3BEXC84AB3A5E/ php|architect: The Magazine for PHP Professionals www.phparch.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
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 to table, and lock it - when another user is trying to get the max field value for some field, the script will waiting the first user to unlock table and then to see the max value of some field in a table ? Depends on what type of LOCK you specify. Refer to your DB docs for details. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * -- Search the list archives before you post http://marc.theaimsgroup.com/?l=php-db -- /* I'm so broke I can't even pay attention. */ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
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] On Friday 09 July 2004 07:24, Rosen wrote: Thanks, but can you give me a sample PHP script with MySQL database, whitch do this? Don't have any examples handy. Basically instead of performing your usual single query, you sandwich it between two extra queries: LOCK tables ... your usual query here UNLOCK TABLES -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * -- Search the list archives before you post http://marc.theaimsgroup.com/?l=php-db -- /* Nothing is impossible for the man who doesn't have to do it himself. -- A.H. Weiler */ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[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
[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
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 - paradox, database, php and the first link will answer your question. ps. Rosen your email bouncesunknown user. error -- 550 5.1.1 [EMAIL PROTECTED]... User unknown hth jeff - Forwarded by Jeffrey N Dyke/CORP/Keane on 11/11/2003 07:49 AM - Rosen [EMAIL PROTECTED]To: [EMAIL PROTECTED] .comcc: Subject: [PHP-DB] Paradox tables 11/11/2003 08:39 AM 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 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 you have to choose by which you want to order. Think about making LEFT JOIN. select * from f1 LEFT JOIN f2 ON f1.some_field=f2.some_field LEFT JOIN f3 ON f2.some_field=f3.some_field roder by f1.datestamp; Regards, Andrey Hristov IcyGEN Corporation http://www.icygen.com BALANCED SOLUTIONS - Original Message - From: Rosen [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, November 27, 2001 5:34 PM Subject: [PHP-DB] Problem with SQL query on several tables Hi, I'm trying to execute SQL query: select * from f1,f2,f3 order by datestamp MySQL returns me an error: 1052 - Column: 'datestamp' in order clause is ambigious The tables f1,f2,f3 have some structure. The field datestamp is type datetime. 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 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, configuring, installing and debugging troubled scripts. All will be done in short time with quality guaranteed. Price is negotiable. We are interested in various kind projects,contracts and cooperation. Pls contact [EMAIL PROTECTED] if you are interested. Thanks, David Some of the applications of our skills: Web Shop (Shopping cart, online catalogue) Web Search Engine Auctions Banner Exchange Calendars Chat Classified Advertisement Click Tracking Communities Counters Database Tools Discussion Boards Forums Mailing List Guestbooks News Publishing Polls and Voting Postcards Security Systems User Authentication Web Traffic Analysis __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ -- 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] 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]
[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] 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 unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
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: " insert into roubr('id','pos','name') values ( select id,pos,name from requestroubr) " Try this: insert into roubr(id,pos,name) values select id,pos,name from requestroubr I hope this will work ! Best regards Constantin Brinzoi and it don't work ! Please help! 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 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 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 (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] 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 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 the list administrators, e-mail: [EMAIL PROTECTED] -- 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 ! 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]