Re: UPDATE based on value in another table

, you need to set up a Trigger. Or else, just use multiple queries, to either delete the referenced columns, or to set values in them to NULL. -- [ Rajesh Kumar ] __ Meet the guy at http://www.meetRajesh.com/ -- MySQL General Mailing List For list archives: h

Re: PHP mysql_connect randomly failing

D] Try finding how you're connected using the MySql CURRENT_USER() function. Also: error_reporting (E_All ^ E_NOTICE); $con = mysqk_connect ("localhost","uname","") or die(mysql_error()); ?> Try supplying all three arguments to mysl_connect(). -- [ Rajesh

PHP API Question.

ecute the BENCHMARK() function using PHP, but there is not point to this, as I am not able to figure out the number of seconds it took. Thanks. -- [ Rajesh Kumar ] __ Meet the guy at http://www.meetRajesh.com/ -- MySQL General Mailing List For list arc

Re: Copying distinct data to a new table

://www.mysql.com/doc/en/INSERT_SELECT.html ex: INSERT INTO tblTemp2 (fldID) SELECT tblTemp1.fldOrder_ID FROM tblTemp1 WHERE tblTemp1.fldOrder_ID > 100; -- [ Rajesh Kumar ] __ Meet the guy at http://www.meetRajesh.com/ -- MySQL General Mailing List

Re: MySQL running out of date

27;2002-102-31') | +---+ |1037026951 | +---+ We could then probably eliminate all timestamps stored as 1969-12-31 as we know that they're illegal. -- [ Rajesh Kumar ] __

Re: MySQL running out of date

#x27;1996-67-31'); select * from test3; I ran it on MYSQL-4.10-max and was not amused. Anyone to comment?? Yeah, what's wrong with this? Absolutely expected results. -- [ Rajesh Kumar ] __ Meet the guy at http://www.meetRajesh.com/ -- MySQL Gene

Re: Seeking advice on best table structure

nk before you choose, for you don't want to be sorry later. -- [ Rajesh Kumar ] __ Meet the guy at http://www.meetRajesh.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: myisamchk question (important)

enerate the warning, as that is not its duty. It is upto YOU, the DBA, to consider this. Better safe than sorry.. -- [ Rajesh Kumar ] __ Meet the guy at http://www.meetRajesh.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql T

Re: "hard" sort table order

anders thoresson unknowingly asked us: Is it possible to resort the rows in a table like in a query where using ORDER BY, but have to new sort order stored in the table structure? If you use PhpMyAdmin (latest version), follow these steps: 1. Select your table by clicking on the left. 2. Choose '

Re: Server to Server Connection

Thomas Deliduka unknowingly asked us: and then it ran the mysql_select_db which selected the wrong table. Please re-read, re-phrase. I have an uncomfortable feeling when people use the wrong function for the wrong purpose. I'm an idiot, I should have looked for this before. Think to think more.

Re: Oracle DBA here looking for advice on MySQL ....

Johnson, Michael unknowingly asked us: What is the best book on MySQL with regard to its Architecture and how it starts up, shutdowns, processes queries, rolls back data, etc etc. ? Doesn't the documentation help? -- Think to think more, work to work more. _

Re: Server to Server Connection

Thomas Deliduka unknowingly asked us: Thank you for the code, when I did that (which I should have done, you're right) it worked fine. So, now I gotta find out where this is going wrong and why the same code is working in one place but not the other. While my connection function is only run once

Re: Server to Server Connection

Thomas Deliduka unknowingly asked us: Right, however, I am following the progression of 1,2,3. My code I pasted here showed that the connection function did the connect and select in the same function and in my debugging I did confirm that $db does equal my_database. I have also manually typed it

Re: Problem to use mysql

Dathan Vance Pattishall unknowingly asked us: There is actually a C++ mysql list that might be able to help you better then this one. -->-Original Message- -->From: Z. S.Ghand [mailto:[EMAIL PROTECTED] -->Sent: Monday, August 18, 2003 9:49 AM -->To: [EMAIL PROTECTED] -->Subject: Problem to

Re: set up question

David Fair wrote: i have working install of 3.23.46. on one server. by working, i mean that i can get this far c:\mysql\bin>mysql mysql>use mysql and then run queries. on my other server, i have reloaded 3.23.57 back from 4.04b when i was having trouble with a php page not working, (failing

Re: "table is read only" after copying table files to new server

Bennett Haselton wrote: At 11:22 AM 8/17/2003 -0400, Rajesh Kumar wrote: Bennett Haselton wrote: I had already run the command: grant all on tracerlock.test to bhaselto identified by "" and that didn't work when I did it, but I didn't restart mysql after running the comma

Re: [MYSQL] Confused about DATETIME compare/subtraction

PAUL MENARD wrote: Hello All, I'm having trouble understanding the MySQL docs on how to subtract two DATETIME values. I have two tables that have a DATETIME column. In my SELECT I am doing a JOIN to bring in both sets of rows. What I want is to subtract the DATETIME values to determine the number

Re: "table is read only" after copying table files to new server

Bennett Haselton wrote: I'm trying to port my MySQL tables for a database called "tracerlock" from one server to another. On the old server, in the /var/lib/mysql/tracerlock directory, there was a ".MYD", ".MYI" and ".frm" file for every table in the database. So after creating a database cal

problem

hello sir, I am Rajesh. I am an administrator in DeUS Infotech.Hyderabad,India. I had installed mysql on windows and connected with the database with Jrun for JSP pages. I am getting the error and some times the data accesiible.I am using the mmmysql.jar file for connecting the mysql with jsp.