MYSQL

NAVIGATION

Spatial Extensions to make a Dealer Locator?

I'm in the midst of the age-old problem of finding the right SQL tomake a Dealer Locator by ZIP code. Like Steffan's posts from a coupleweeks ago, I have the ZIP code data in one table with latitudes andlongitudes, and the table of Dealers with ZIP codes in a separate table.While resea...

1 answers | 836 bytes |

database won't load after machine reboot

Hi Luke,Have you tried doing another GRANT statement to ensure the name andpassword are indeed correct? That would be my next step. That way atleast you are sure that the name/password combination are correct.RegardsDavid LoganDatabase AdministratorHP Managed Services148 Frome Street,Adelaide 50...

2 answers | 9081 bytes |

database won't load after machine reboot

Hi Luke,According to the log051019 19:46:20 mysqld started051019 19:46:20 InnoDB: Started/myProgs/mysql/libexec/mysqld: ready for connections.Version: '4.0.20-log' socket: '/tmp/mysql.sock' port: 3306mysqld is sitting there fat, dumb and happy waiting for somebody to talkto i...

1 answers | 6765 bytes |

how big can handle?

I want to know how big (maximum) mysql can handle onedatabase?What's MaxDB?RegardsEdwinStart your day with Yahoo! - Make it your home page!http://www.yahoo.com/r/hs...

2 answers | 201 bytes |

database won't load after machine reboot

Do you have any sample of error output? This would be useful.ThanksDavid LoganDatabase AdministratorHP Managed Services148 Frome Street,Adelaide 5000Australia+61 8 8408 4273 - Work+61 417 268 665 - Mobile+61 8 8408 4259 - Fax MessageFrom: Luke Vanderfluit [mailto:lvanderf (AT) internode (DOT) co...

1 answers | 905 bytes |

database won't load after machine reboot

Hi.I have a database that is used with wordpress blogging software.Yesterday the server that it's running on reset itself.Since then I can't access the database.What could be going on here?Any ideas?Thanks.Kind regards....

2 answers | 265 bytes |

Visual Studio crashing

Hi Thomas, UHI found same case in Visual studio.all database objects listed normally in server explore, but trying toretrive contentsof any table with double-click, visual studio crashes.Here is infomation of my dev-env.S- Windows XP Pro Ver2002 SP2IDE- Visual Studio .NET2003driver- MaxDB(Unicod...

0 answers | 1597 bytes |

MySQL + Innodb vs. MaxDB

Hi,Could anyone provide me the comparision information between MaxDB andMySQL + Innodb from the features, performance,scalability, easy to use(Iheard that MaxDB was not easy to use?) etc. perspective?Thanks in advance for your information. BTW, I havn't joined this aliasyet, please reply me...

0 answers | 358 bytes |

SQL insert will not work

You're not getting any error messages? Hmmm. I was going to suggestmaking sure that:NULL's are accepted on those columnsThe data can fit in those columnsCheck PK's and FK'sTry doing one insert at a time. See if that works.Robert NurseSTGContractor - Applications DevelopmentEn...

0 answers | 2315 bytes |

one product in more categories

I don't think you have a clear enough mental picture of what yourdifferent pricing structures are. You describe:a) fundamental unit priceb) price breaks due to volume discountsc) price breaks due to couponsd) price increases based on options. include: embroidered logo,screened logo, total c...

4 answers | 15096 bytes |

bk commit into 5.0 tree (paul:1.2020)

Below is the list of changes that have just been committed into a local5.0 repository of paul. When paul does a push these changes willbe propagated to the main repository and, within 24 hours after thepush, to the public repository.For information on how to access the public repositoryseeChange...

0 answers | 1564 bytes |

bk commit - 5.0 tree (sergefp:1.2045) BUG#13126

ChangeSet 1.2045 05/10/20 03:28:29 sergefp (AT) mysql (DOT) com +9 -0 BUG#13126: When choosing join order for join with nested joins, don't produce join orders that the executioner cannot handle. The work is done by nj_add_tab() and nj_remove_tab() functions that are used from the join opti...

0 answers | 22431 bytes |