MySQL Database Forum

I want to know on Solaris how I could lower the the minimum fulltext search string from 4 to 3. Right now using the FullText search any string less than 4 chars is ignored. I'm sure there's a link explaining how. Maybe UNIX help in general on his would be good as well. Thanks, Lee G.

Hello, After a power failure i receive the following error message in my root mailbox: /usr/bin/mysqlcheck: Symbol `sql_protocol_typelib' has different size in shared object, consider re-linking I searched on google on altavista on groups.google i can't find anything about this error.

Hi, I have an Excel file (which is converted to csv by a tool and then uploaded to a MySQL database) and then php is used to display the data on the website. In the Excel file i have text fields which has data containing double quotes. They end up appearing at ? question mark on the website. Any idea how to dispaly the quotes

Hi, as a newbie, I am somewhat concerned that i have the right versions of AMP on my Win XP system so it will all work together... Is there some link that (in simple terms!) tells which versions are safe together? I currently have MySQL version 4.0.20d, with Apache 2.0.52 and php 4.3.10. Is this the best combination? Thanks for any pointers!...

Hi, I have an application as follows: MySQL database Back-Eend linked to MS Access Front-End and ASP Web Application. I require users to enter Serial Numbers such as: 0105123567 (10 digits), the first 4 being the month and year (mmyy)

Hi, My users are sometimes pasting "funny" quotation marks into their FCKEditor, also some kind of elongated hypen. How can I filter these out before writing the user input to mySQL? Obviously I could filer each one out, but I rather like something more generic. -- zzapper (vim, cygwin, wiki & zsh)

Hi, I would like to have MySQL use a mapped network drive. I'd like to do this in case there is a failure of the mysql machine, I can just replace it with a new machine pointing to the same network drive. Is this possible at all? Thanks, Andre M. Descombes

I have just upgraded MySQL from version 3.23 to version 4.1.8 and now I am getting the following error when I try to run a script that worked: install_driver(mysql) failed: Can't load '/usr/lib/perl5/vendor_perl/5.8.0/i386-linux-thread-multi/auto/DBD/mysql/mysql.so' for module DBD::mysql: libmysqlclient.so.10: cannot open shared object...

TIA

Im at my wit's end! Im using mysql 4.0.23 (win32) Show create: CREATE TABLE `dbcurrent` ( `Filespec` varchar(254) NOT NULL default '', `ID` int(11) unsigned NOT NULL auto_increment, `InUse` int(11) default NULL, PRIMARY KEY (`Filespec`),

I am trying to figure out the best way to handle a system with lots of roaming laptops wanting to take the data with them. I have the following requirement: Web server (possibly several) which holds main database and everyone connects to (PHP web site with updates) Lots of laptops (up to 50) take copies of the master data with them to...

I am trying to make a union query to join 4 tables. I have reduced the tables to just 5 fields and made sure that the field types and names are the same. I keep getting an error message ODBC call failed. I have tried various combinations of the tables and find that I can use any 2 of them but as soon as a third is included in the statement the...

Does anyone know how I can use vba in access to run a script that is stored as a file. I can make a connection to mysql database and run sql statements but this sql statement is very long (creates many tables with hundreds of fields). I can run the script in the mysql interface but I want to do this from my access front end to make it easy for...

Hello All, I'm running mysql 4.0.21 on an HP-UNIX machine and I am getting the following error: Got error 12 from Table Handler After looking up this error in the MySQL manual, http://dev.mysql.com/doc/mysql/en/Operating_System_error_codes.html, I've found that it is an "Out of Memory" error.

Hi-ya, I want to be able to only allow root access while I dump the databases, thus locking out all non-root users ( even remote logins) then allow all normal users back in after the dump has been done. How would I go about this please. thanz.. Pauline...

Trying to put mysql on a Mepis(Debian) box. I use apt-get install mysql-server. What happens next is weird: the Sun license agreement appears, and informs me I need to click on "Accept" to continue. I page through this (in Konsole, also tried in Xterm) but no "Accept" menu/button/whatever appears. Just (END), and my terminal becomes...

OK, anyone have some advice on implementing the likes of SELECT ... FOR UPDATE / SELECT ... LOCK IN SHARE MODE? I'm trying to get it working in conjunction with the transaction facilities built into Pear DB. Obvious answer to obvious question: yes, I'm using InnoDB-formatted tables within MySQL. So far, all of the stuff I've put in...

Hi, I am trying to run an update stats command but keep getting a syntax error: Looking at the doco it looks like I can use: update stats <table_name>; but when I use: mysql> update stats x_balance; ERROR 1064: You have an error in your SQL syntax near 'x_balance' at line 1

I have a table that is a project. Each record is a task in the project. One field in each record is a date/time stamp for when that task was completed. I need to be able to: 1) compute how much time has passed between each date/time stamp and 2) compute how much time has passed between the first and last date/time stamp (total project...

Hi, I'm having trouble doing joins correctly on two tables. I've read up a lot about the different types of joins and tried lots of variations on inner, outer, and left joins with no avail. Something isn't correct with my logic so could anyone give me some pointers on it? I have 2 tables: CourseRoster: ID CourseID StudentID StudentType

Hello mysql experts, i would like insert only the first "value" from every member into the table members - but different counts exist in table members_action. UPDATE members set value1= (Select value from members_action where value1= (Select min(id) from members_action where members.member_no=members_action.member_no));

This should be a <duh> but I can't find the answer. For example: SELECT Company_Defaults.CompanyID, Company.CompanyID FROM Company_Defaults Left Join Company on Company_Defaults.CompanyID = Company.CompanyID Where Company.CompanyID = 1 And Company_Defaults.CompanyID = 1 This is over-simplified but it will give you the symptom.

I really don't want to use this irritating feature at all. Is there a way to remove completely. Using Mysql 4.1.7, phpmyadmin 2.6.1. I think there should be a way around this, but can't remember where it resides.

Hi there I'm in the planning stages of creating a database, and I have two options here. Which makes more sense, and/or provides better performance for queries - a single table with hundreds of thousands of rows, or many tables with less rows? GOAL: Recording information about buildings, storey by storey. Basically I will be recording...

When I try to run a Perl script that uses DBI I get the following error message. $ ./dbtest.pl install_driver(mysql) failed: Can't load '/usr/lib/perl5/vendor_perl/5.8.0/i386-linux-thread-multi/auto/DBD/mysql/mysql.so' for module DBD::mysql: /usr/lib/libmysqlclient.so.10: symbol errno, version GLIBC_2.0 not defined in file libc.so.6 with...