update support sub-queries?
Hi all, I am new in mysql and want to analyse between some popular databases. I have a SQL: update ta set f1 = ( select af1 from tb where ta.id = tb.id ); It can be done in postgreSQL and Oracle. How can I do the same tasks in MySQL without using Perl? Is it possible to do this tasks just enter the SQL statement? Kenenth. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Party!!!
I can't login to your website. Kenneth. - Original Message - From: "Deryck Henson" <[EMAIL PROTECTED]> To: "Maximiliano Lucius" <[EMAIL PROTECTED]> Cc: "MySQL" <[EMAIL PROTECTED]> Sent: Friday, October 05, 2001 4:27 PM Subject: Re: Party!!! > Well, I run a website ( Source Code Cafe ) and I guess on the night of > the release, we could all meet there! I have a chat set up as well as > message boards and I might even decorate a bit. If anyone would like to > help by offering a backup server, please email. We might have too many > people to hold just on one server. I may have to host it at brinkster.com. > They have dedicated servers there. Yeah, I'll just do that. This will be > great. I'll have download links to all binaries (Linux, Win32, etc) and > everyone can chat, and have fun. I'll add some games for enjoyment (Try to > do shockwave but Java should be fine). Again, if you have any suggestions, > questions or just want to help out, please email me in private. Thanx! > > ** > - Deryck Henson > - http://www.comp-u-exchange.com > ** > - Original Message - > From: "Maximiliano Lucius" <[EMAIL PROTECTED]> > To: "MySQL" <[EMAIL PROTECTED]>; "Riccardi Moreno" > <[EMAIL PROTECTED]> > Sent: Friday, October 05, 2001 10:18 AM > Subject: RE: Party!!! > > > > Tell us more about it. > > > > M. > > - Original Message - > > From: Riccardi Moreno <[EMAIL PROTECTED]> > > To: Andrew Murphy <[EMAIL PROTECTED]>; MySQL > > <[EMAIL PROTECTED]> > > Sent: Friday, October 05, 2001 3:47 AM > > Subject: R: Party!!! > > > > > > > It's a great idea > > > Free your Mind > > > > > > -Messaggio originale- > > > Da: Andrew Murphy [mailto:[EMAIL PROTECTED]] > > > Inviato: venerdì 5 ottobre 2001 10.37 > > > A: 'Deryck Henson'; MySQL > > > Oggetto: RE: Party!!! > > > > > > > > > Sounds good, as the (altered) saying goes: > > > > > > Life begins at 4.0! > > > > > > > > > -Original Message- > > > From: Deryck Henson [mailto:[EMAIL PROTECTED]] > > > Sent: 04 October 2001 4:00 pm > > > To: MySQL > > > Subject: Party!!! > > > > > > > > > Hey everyone! As most of you know the official (as in, not using a BASH > > > shell) release of MySQL 4.0 will be out very soon. So, let's throw a > > party! > > > Not like something at someone's house (although I wish we could). Just > a > > > get - together online in a chat room with games, music (mp3s), and more! > > Me > > > and whoever else wants to will plan it, we just need you people to come. > > It > > > is a pretty long-shot but we could probaly do it. My Web Server. > > > > > > ** > > > - Deryck Henson > > > - http://www.comp-u-exchange.com > > > ** > > > > > > > > > - > > > Before posting, please check: > > >http://www.mysql.com/manual.php (the manual) > > >http://lists.mysql.com/ (the list archive) > > > > > > To request this thread, e-mail <[EMAIL PROTECTED]> > > > To unsubscribe, e-mail > > > <[EMAIL PROTECTED]> > > > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > > > > - > > > Before posting, please check: > > >http://www.mysql.com/manual.php (the manual) > > >http://lists.mysql.com/ (the list archive) > > > > > > To request this thread, e-mail <[EMAIL PROTECTED]> > > > To unsubscribe, e-mail > > > <[EMAIL PROTECTED]> > > > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > > > > > > > > > > - > > > Before posting, please check: > > >http://www.mysql.com/manual.php (the manual) > > >http://lists.mysql.com/ (the list archive) > > > > > > To request this thread, e-mail <[EMAIL PROTECTED]> > > > To unsubscribe, e-mail > > <[EMAIL PROTECTED]> > > > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > > > >
XML support
When will mysql support XML with function same as Oracle XSU? Kenneth. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Automatic Mathmatical Computation
I think u cannot do automatically, since MySQL does not support table trigger or view. U can only get value C by select statement, otherwise u need to update the column C by another processing. Best regards, Kenneth. - Original Message - From: "Kodrik" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, October 25, 2001 4:33 AM Subject: Re: Automatic Mathmatical Computation > Yes, you can do: > > update whatever set C=A*B+3 where whatever > > On Wednesday 24 October 2001 07:11 pm, [EMAIL PROTECTED] wrote: > > Hello, > > > > I am wondering if there is a way to make automatic computations into a > > particular column, for instance: > > > > Table ONE has column's A, B and C. > > > > When I post data to A and B, can I have C automatically calculate A / B and > > post that answer onto column C? > > > > Again, I want this to happen automatically, I don't want to have to issue a > > SELECT statement for this procedure. > > > > Thanks for your help. > > > > David > > > > > > > > - > > Before posting, please check: > >http://www.mysql.com/manual.php (the manual) > >http://lists.mysql.com/ (the list archive) > > > > To request this thread, e-mail <[EMAIL PROTECTED]> > > To unsubscribe, e-mail <[EMAIL PROTECTED]> > > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: query only returns one row
Hi Chris,
You need to use a while loop to fetch all of the records returned in the
SELECT statement in PHP, as follows:
\n", $row["DBID"];
printf("First Name: %s\n",$row["FIRST_NAME"];
printf("Last Name: %s\n", $row["LAST_NAME"];
}
?>
- Original Message -
From: "Admin" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, January 06, 2003 16:47
Subject: query only returns one row
>
>
> Hi,
>
> I finally established a connection to my db after I realized that it was
> located in a different directory than that which I kept placing my php
> files. As some would say, "D'OH!"
>
> The code below is intended to select and display all 1300 names from the
> NAMES_TBL but is only returning the first row. I'm still a bit new to php
> so this is probably something simple - a shove in the right direction
would
> be quite helpful.
>
> thanks!
>
> chris
>
>$db = mysql_connect("host", "user", "pwd");
> mysql_select_db("dbname",$db);
> $result = mysql_query("SELECT * FROM NAMES_TBL",$db);
> printf("DBID: %s\n", mysql_result($result,0,"DBID"));
> printf("First Name: %s\n", mysql_result
> ($result,0,"FIRST_NAME"));
> printf("Last Name: %s\n", mysql_result($result,0,"LAST_NAME"));
> ?>
>
> --
-
>
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php (the manual)
>http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: phpmyadmin and mysql
Hello Martin, Your problem is related to PHP not MySQL. You should check the max_post_size directive in yor php.ini file. AFAIK, this limit is set to 8M. If you decreased the size, increasing it may solve your problem. max_post_size controls the maximim POST size you can do, and if you exceed this limit, your post will be discarded. - Original Message - From: "Martin Hudec" <[EMAIL PROTECTED]> To: "MySQL List" <[EMAIL PROTECTED]> Sent: Tuesday, January 08, 2002 13:53 Subject: phpmyadmin and mysql > Hello MySQL, > > we have this problem: > > when using phpmyadmin if we select database to view and we put SQL > command to ENTER SQL QUERY/QUERIES TO DATABASE field and submit it, > it will display NO SQL QUERYwhat is wrong? > > please help me...thank you > > -- > Best regards, > Martin mail [EMAIL PROTECTED] > mobile +421.907.303.393 > icq34358414 > wwwhttp://www.corwin.sk > > PGP key fingerprint 21365ca05ecfd8aeb1cf19c838fff033 > > "In those days spirits were brave, the stakes were high, > men were real men, women were real women and small furry > creatures from Alpha Centauri were real small furry creatures > from Alpha Centauri." > > by Douglas Adams > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Cant change anything via web?
Hi Tyler, Most probably there is a problem in PHP configuration if you are sure MySQL is working properly. You didn't get any errors, did you? If not and you have acces to php.ini change the error reporting level to E_ALL. If you don't have acces to php.ini, call the error_reporting (E_ALL); so that you could get some verbose output from PHP about what the problem. Fero - Original Message - From: "Tyler" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, January 17, 2003 15:43 Subject: Cant change anything via web? > Hey.. I've got a promblem. I use PHP, and I cant seem to be able to change > anything in the MySQL db via the webpage. I know the scripts are correct, > but nothing happens when I change somethign via web. I've even installed > PhpMyAdmin to moniter the DB via the web, and that doesn't work either. I > dont knwo whats wrong.. but the only way I can edit my DB is to do it via > mysqladmin ON the linux box > > -Thanks oin advance > Tyler > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: localhost problem
It seems at least one of your username and/or password is not as you might think. You should find the my.ini file, which is either should be in C:\Windows for M$ Windows'98, and change your username-password info. After relaoding mysql, it should function. Regards - Original Message - From: "Pafo" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Wednesday, November 21, 2001 4:55 PM Subject: Re: localhost problem am still getting the same message http://www.pafo.net/mysql5.gif regards pafo - Original Message - From: <[EMAIL PROTECTED]> To: "Pafo" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Wednesday, November 21, 2001 2:34 PM Subject: Re: localhost problem > On Wed, 21 Nov 2001, Pafo wrote: > > i still cant get pass this problem, i have now uninstalled PWS and still i cant access > > why why why why? http://www.pafo.net/mysql4.gif > > i am running, win98, p-III 1000, 512ram, the latest mysql, using tiny personal firewall and > > i am connected thru a network card in my computer to the internet, all the time. > > Try logging in with "mysql -u root", then read up in the manual on the > grant system for adding other users. > > Sincerely, > Jan > > -- > Mr. Jan-Aage Bruvoll IT Project Manager > 20 Min Holding, Thurgauerstrasse 40, CH-8050 Zurich > Zurich office: +41 1 307 4293, fax: +41 1 307 4281 > Office/fax: +44 2072408283 Mobile: +44 7740291600 > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql web-based admin tool?
Hi, The most widely used tool to reach MySQL over PHP is phpMyAdmin. You can obtain it from http://www.phpwizard.net/projects/phpMyAdmin/ - Original Message - From: "Ed Lazor" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, January 29, 2002 5:53 PM Subject: mysql web-based admin tool? > I used to use some php scripts that allowed me to work on my database. I'm > trying to find them again... anyone know what they might have been called > or where to find them? > -Ed > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
how to stay connected to remote mysql server?
I am using syslog-ng to pipe syslog entries to a remote mysql server. I would like to stay connected to remote mysql server, always trying to reconnect if disconnected due to network problem. Is there some mysql-internal mechanism to do this? Or must I write a script to do so? If a script is necessary, then could any one give me some clue to utilize mysql-internal mechanism? Thank you in advance. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
