MYSQL

NAVIGATION

GUI Tools Book and the ID mapping machinery

>I really wish you wouldn't do that. Having separate manuals isvery>useful for those who only use one tool such as the query browser.>Combining documentation for QB with MT, Admin and WB seemsinappropriate>here. I am also concerned that by packaging all these toolstogether,>t...

1 answers | 5209 bytes |

Last Inserted ID Using LOAD DATA

I have a group of updates that need to be done using LAD DATA INFILE.Within this file there are some INSERTS. Is there anyway that afteran INSERT happens I can use the auto-increment ID that was justgenerated in the next statement. Similar to PHP's mysql_insert_id()function.Thanks,Michael...

1 answers | 322 bytes |

Change Customer on Existing Issue

Hi,We just got Eventum up and running and it's a great tool for all sorts ofissue tracking! Customer API integration went smoothly and seems to workfine for new issues.How can one change a Customer on an exiting issue, specifically and issuethat was autocreated from an email, and not report...

0 answers | 370 bytes |

how can I access to mysql fro m"outside"?

hi,I'm trying to access to mysql on dedicated web server (hosted by hostingcompany) using MySQL Administrator. Right now I'm getting error message2003 (Can't connect to the server). users table I can see in user column 'root' and 'admin' as users andboth have f...

4 answers | 1187 bytes |

AW: Lizenzfrage

IMH,ist es einzig eine Frage des Linkens. Wenn du dein Programmstatisch/dynamisch gegen eine GPL Software linkst, dann wirst du dichan die Lizenz dieser Komponente haltenIm Falle der GPL bedeutet es, dass du den Code musst.Ist die Komponente hingegen unter der LGPL , brauchst duda nicht aktiv we...

1 answers | 1802 bytes |

Difference between number of vserver and sessions

Hello list,we have last weekend and yesterday some problems with our database server,which are related to the issues described in:-- new server works very well for nearly two weeks, when the number ofvserver processes on our linux system (Suse 9.3) grows last sunday fromnormally 30 to about 100...

0 answers | 1239 bytes |

Lizenzfrage

Hallo,ich habe an mehreren Stellen versucht eine Antwort vom MySQL Team zu bekommen, leider immer ohne Erfolg. Vielleicht kann mir ja hier jemand helfen oder mir eine Kontaktadresse geben.Es geht um folgendes:Ich habe ein Programm in Java geschrieben, dass Daten in einer MySQL-Datenbank ablegt....

2 answers | 816 bytes |

SUM in WHERE

I tried it also with 5.0.24-community-nt and it still didn't work!Randall PriceMicrosoft Implementation GroupSecure Enterprise Computing InitiativesVirginia Tech Information Technology1700 Pratt DriveBlacksburg, VA 24060Email: Randall.Price (AT) vt (DOT) eduPhone: (540) 231-4396 MessageFrom...

0 answers | 1218 bytes |

query question: updating between 2 tables

Hi all,trying to figure out if there is a query I can use for this, or if Ihave to write a php script to loop tru each rowtable1:entryid int(11)itemid int(11)table2:object_id int(11)The situation is: table2.objectid is populated with the values oftable1.itemid, but they have to be replaced with...

1 answers | 578 bytes |

MySQLDump

I enabled the general query log and nothing was captured when running theMySQLDump command I'm at a loss to the issue. Below is the output fromSHW TABLE STATUS'content_resource_body_binary', 'InnoDB', 'Dynamic', 1053, 368958,388513792, , 0, 0, , '', &...

0 answers | 822 bytes |

access to mysql from outside

what I have to do to be able to access to mysql on my web server fromother computer?e.g., I want to access to web server using MySQL Administrator?I have root access to web server.As far as I know, mysql server is set up by edfault to be acessed onlythrough "localhost" and I have to add permissi...

1 answers | 1297 bytes |

phpinfo() "Client API version 3.23.49 "

Hi, I am using apache2.0+php4.3.4+mysql 4.1.1 in windows. If I typephpinfo(); , in mysql section it is coming as "Client API version3.23.49" . Is the installation correct?. Will the php connect to themysql 4.1.1 server?. If i need to see "Client API version 4.1.1" inmysql section, what should I...

0 answers | 377 bytes |