MySQL Database Forum

hey there, i thought you'd like to check this out it's very special.only the banks know about it.. you're placed up for auction and financers outbid each other on getting you the best deal on your mortgage! http://srd.yahoo.com/drst/876786/*http://cheapermortgage.cn/4/index.asp?RefID=198478

What is the symbol to do for in "ALTER TABLE ... ADD CONSTRAINT symbol FOREIGN KEY ..."? In the manual, they say that "SHOW CREATE TABLE" gives the internal id of the foreign key. Trying to do so, i see that it's not true... How can I do to drop some foreign keys excepted the "DROP TABLE/CREATE TABLE" solution because my tables have a lot...

hello =09I have a OpenBSD3.3 box with mysql-server 4.0.13. the= mysql-server runs normally at the beginnig . Trouble come up= these days that the mysqld server will down . There's error= messages appers that lost connection during query when the= client connect to it. =09There's errors in .err log files like this:

Hi List Can anyone help me to do the following without the need of subselects: I have a table that contains rows where mostly, the only common field is the "name". The rest of the data fields, even though they are related to the "name", differs from row to row ( they are things like the address etc, which could have changed on the next...

hello =09I have a OpenBSD3.3 box with mysql-server 4.0.13. the= mysql-server runs normally at the beginnig . Trouble come up= these days that the mysqld server will down . There's error= messages appers that lost connection during query when the= client connect to it. =09There's errors in .err log files like this:

Hi List Can anyone help me to do the following without the need of subselects: I have a table that contains rows where mostly, the only common field is the "name". The rest of the data fields, even though they are related to the "name", differs from row to row ( they are things like the address etc, which could have changed on the next...

Can I put a new charset or modify an existing one without recompiling MySQL? If yes, please tell me how. Thanks Anticipated, Iulian -- MySQL General Mailing List

Can I put a new charset or modify an existing one without recompiling MySQL? If yes, please tell me how. Thanks Anticipated, Iulian -- MySQL General Mailing List

$B$*@$OC$K$J$C$F$*$j$^$9!#(B $B%D%?%M%9(B@TSTI$B$G$9!#(B Hello, I am trying to install MySQL 3.23.55 on HP-UX 11.11 When I ran ./configure, I got the following messages : Configure: WARNING: sys/socket.h: present but cannot be compiled

Hi , I am this error while running mysqld_safe # ./bin/mysqld_safe --user=mysql & 19413 # Starting mysqld daemon with databases from /export/home/siptech/vidhya/ifmonitor/mysql/data 030728 12:17:49 mysqld ended The daemon is not starting . what could be the problem thanks

Hello List, How can I see the value of master-connect-retry? show variables doesn't work on it. Thanks Anticipated, Iulian

$B$*@$OC$K$J$C$F$*$j$^$9!#(B $B%D%?%M%9(B@TSTI$B$G$9!#(B Hello, I am trying to install MySQL 3.23.55 on HP-UX 11.11 When I ran ./configure, I got the following messages : Configure: WARNING: sys/socket.h: present but cannot be compiled

Hello List, How can I see the value of master-connect-retry? show variables doesn't work on it. Thanks Anticipated, Iulian

hi guys... i am doing the eclipse-tomcat-jboss-mysql integration but i just cant get to see why jboss wont start properly; hes a snippet of the error i am getting: Starting deployment of package: file:/C:/jboss/server/default/deploy/mysql-service.xml 15:14:32,078 WARN Duplicate throwable nesting of same base type: class...

hi guys... i am doing the eclipse-tomcat-jboss-mysql integration but i just cant get to see why jboss wont start properly; hes a snippet of the error i am getting: Starting deployment of package: file:/C:/jboss/server/default/deploy/mysql-service.xml 15:14:32,078 WARN Duplicate throwable nesting of same base type: class...

I know this is the mysql mailing list but I have tried the Fuse mailing list and no one will help well what im wanting to know is how could I get more avatars show in a room like I already have it where all users that are logged in control this 1 avatar im trying to make it where every user has his/her own avatar ...

I know this is the mysql mailing list but I have tried the Fuse mailing list and no one will help well what im wanting to know is how could I get more avatars show in a room like I already have it where all users that are logged in control this 1 avatar im trying to make it where every user has his/her own avatar ...

Hi. With MySQL 4.1.0 alpha when I try to set default character set to tis620 MySQL start OK but have crash every time when perform to tun query (with default_character_set=latin1 it never got error) and with MySQL 4.0.14 it can do with out any error. With MySQL 4.1.0 alpha what GUI to use for connect to MySQL server with out error (due...

Hi. With MySQL 4.1.0 alpha when I try to set default character set to tis620 MySQL start OK but have crash every time when perform to tun query (with default_character_set=latin1 it never got error) and with MySQL 4.0.14 it can do with out any error. With MySQL 4.1.0 alpha what GUI to use for connect to MySQL server with out error (due...

HI all, I want to ask whether I can do replication in the following case. innodb (master) --replication --> myisam (slave) Rgds, Ringo --

HI all, I want to ask whether I can do replication in the following case. innodb (master) --replication --> myisam (slave) Rgds, Ringo --

I have a database, about 12 fields per record and roughly 100,000 records per month. I would do the following query: select count(*), type from TABLENAME where field0='23-23-23' group by type; the query would run an average of about 2secs. Not bad until I am running the same query about 1400 times all with slightly different field0...

I have a database, about 12 fields per record and roughly 100,000 records per month. I would do the following query: select count(*), type from TABLENAME where field0='23-23-23' group by type; the query would run an average of about 2secs. Not bad until I am running the same query about 1400 times all with slightly different field0...

Hi, I have a database with 5 teams and each team has 'n' categories and each category has 5 sub-categories. i.e TeamOne = Ottawa, Category 1 = Player Name, Sub-Categories = Goals, assists, ppg, gwg, points. Team0ne Category 1

Hi, I have a database with 5 teams and each team has 'n' categories and each category has 5 sub-categories. i.e TeamOne = Ottawa, Category 1 = Player Name, Sub-Categories = Goals, assists, ppg, gwg, points. Team0ne Category 1