help-a-new with query ...

select distinct threads.id, threads.name, threads.readonly, threads.active, threads.forumidfk, threads.useridfk, threads.author, threads.datecreated, forums.name as forum, threads.author as username, threads.sticky, threads.views, conferences.name as conference, conferences.id as conferenc

Re: not allowing empty strings

On Mon, Mar 24, 2008 at 5:07 PM, Ferindo Middleton < [EMAIL PROTECTED]> wrote: > Well, maybe my problem isn't necessarily on user input. My app does check > for this and not allow empty strings. I guess the problem more so exists > because I get files from the client to LOAD into the database. I

Re: not allowing empty strings

Well, maybe my problem isn't necessarily on user input. My app does check for this and not allow empty strings. I guess the problem more so exists because I get files from the client to LOAD into the database. I have several SQL scripts in a library that I choose from to load the data, different s

mysql script

Hi I have created a script http://pastebin.com/m2c9cc100. is this syntactically correct, just want to make sure before running it Thanks and Regards Kaushal

Re: MySQL for Datamining

Sorry I can't recommend anything offhand, but this type of message does not need to go to the internals mailing list. Thanks, Keith Haitham Kaddoura wrote: Hi, does anyone use the or know a data mining package in MySQL? -- Keith Murphy editor: MySQL Magazine http://www.mysqlzine.ne

version mimatch

Hi, I had binlogs from the mysql 4 which I was trying to get into mysql3 using the mysqlbinlog utility. Obviously I got the version mismatch error i.e ERROR 1064 at line 8: You have an error in your SQL syntax near 'DEFAULT ROW_FORMAT=DEFAULT' at line 1 My question, is there anywaay to make the

Re: MySQL for Datamining

Hi, does anyone use the or know a data mining package in MySQL?

Building 5.0 under Windows - new set of detailed instructions published

Hi - I've written a page on how to build MySQL 5.0 under Windows. http://www.45mercystreet.com/computing/mysql/index.html It covers every step in detail - you should be able to build fully by following the instructions. I was originally using the MySQL 5.0 manual page of instructions; http:/

UTF-8 sorting

Hi, I am getting a problem while making a sort on any column having character set as UTF-8. The soring from a view or a query through ODBC is very slow. I have data in us-english and marathi languages at a time. Sorting is proper but very time consuming! What to do to solve this problem? Your Help