RE: MATCH AGAINST () ('XXX' IN BOOLEAN MODE) SYNTEX ERROR

the only thing i could see a problem is the decimal but maybe not -Original Message- From: Francis Van-Lare [mailto:[EMAIL PROTECTED] Sent: Saturday, July 12, 2003 4:42 PM To: [EMAIL PROTECTED] Subject: MATCH AGAINST () ('XXX' IN BOOLEAN MODE) SYNTEX ERROR I have run this command without

RE: Access control via a role based security model

Hi You could achive what you want using grant statements, but you still need a user interface to send queries to the database and display the information sent back in a way that is manageble for non techies. There are many ways of building user interfaces, php ( http://www.php.net ) is probably a

Searching Archives

Hi, I just joined this list and would like to search the archives before I ask a question. I there a way to search. Thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: LIMIT question

Andrey <[EMAIL PROTECTED]> wrote: > > I have a following question: > > I have a table with thousands of rows which i need to show in a String Grid ( I use > Borland Delphi with MyDac component which implements MySQL interface). > > If i make a query > SELECT * FROM tbl WHERE col1="something"

Re: making all tables MyISAM

Neil Zanella <[EMAIL PROTECTED]> wrote: > > Is there a way to specify MyISAM for all tables in a given file rather > than having to specify it at the end of each table declaration. I think > this would make porting databases back and forth to MySQL somewhat easier > since including MyISAM as part

Re: MATCH AGAINST () ('XXX' IN BOOLEAN MODE) SYNTEX ERROR

Hi Your first statement looks ok to me but the one you have below has no space before AGAINST. Otherwise, I cannot see the problem myself. Mike - Original Message - From: "Francis Van-Lare" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: July 12, 2003 2:42 AM Subject: MATCH AGAINS

Re: MATCH AGAINST () ('XXX' IN BOOLEAN MODE) SYNTEX ERROR

"Francis Van-Lare" <[EMAIL PROTECTED]> wrote: > I have run this command without Stating IN BOOLEAN MODE and my search goes > fine. However this query returns a Syntax error WHEN IN BOOLEAN MODE > OPTION IS ADDED , can anyone help ? > Table is MyISAM type running on Linux 8.0 > > > SELECT isbn,

Re: Searching Archives

Ernest Pianalto <[EMAIL PROTECTED]> wrote: > > I just joined this list and would like to search the archives before I ask a > question. I there a way to search. Here you can find list of searchable mailing list archives: http://www.mysql.com/documentation/lists.html -- For technical

RE: Access control via a role based security model

Thanks for the start Peter. I'm developing the interface using Tomcat and JSP. Tomcat http basis authentication provides a JDBC realm interface which allows me to use the content of my mySQL database to log users on, validate passwords and assign roles to them. I can see that it is feasible for

User Permissions

Can someone please help. I have MySQL for windows installed and I don't understand how to manage users. I have MySQL Control Center 0.8.10 Beta. The user I'm logged in as apparently doesn't have permissions to run DDL. I'm trying to take a dump of a remote db and run it here to install structure

mysql.sock

Hello all, after Installing mysql I started the mysql daemon.. The I tried to log in to my mysql database and got the message could not find mysql.sock in /tmp. In the mysql-configuration file /etc/my.cnf (in my redhat system 8.0) I changed the place for the socket file from "socket=/var/lib/mys

Mysql original database and GRANTS.

Hi All, I want to bring back my mysql original database as well as root GRANTS as was during the installation because i installed an application that modified my root GRANTS and now I am not able to see my mysql database as I login from root account. I am not even able to create or delete any

Could not start mysqld: bus error

Hi all I've been trying to build mysql 4.0.13 with linuxthreads on FreeBSD. The build process generates no error message and everything seems to be ok, but when I issue 'make test' it fails with the following message: cd mysql-test ; ./mysql-test-run Installing Test Databases Removing Stale Fi

Stopping MySQL taking down a server?

This may be a silly question but what can be done to stop load-intensive MySQL processes taking down a server? Things like adding fulltext indexes to very large tables, or selects on very large (multi-million-row) tables just completely kill the box until they complete. I don't mind how long thes

Improving insertion performance by locking tables

Hello, We've got an application which does many multiple-value inserts to different tables. Is it worth locking a table before doing a multiple-value insert with say 50 records? If so, what is the number of records that makes it worthwhile? If not, is it worth locking a table before doing 2 seper

FileMaker Pro

Does anyone know how to export a FileMaker Pro Database so that MySQL can use it? Anyone ever do something like this? Thanks, -- -Steve Marquez Marquez Design [EMAIL PROTECTED] www.marquez-design.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscrib

Re: Stopping MySQL taking down a server?

In the last episode (Jul 12), Tim Fountain said: > This may be a silly question but what can be done to stop > load-intensive MySQL processes taking down a server? Things like > adding fulltext indexes to very large tables, or selects on very > large (multi-million-row) tables just completely kill

Re: FileMaker Pro

FM is no problem. You can output from it to a tab-delimited file and then INSERT it into a mySQL DB. Or, a number of mySQL clients, including myPHPAdmin, allow you to import a text file, such as a tabbed file (or CSV, etc.). You must first set up your mySQL datatbase and be sure that the field type

Extracting data from SQL Server *.DB file

I've read through the archives and spent hours on Google but I still can't figure this out. I must extract the data from a SQL Server *.DB file. Viewing the raw text, I can see that there views, grants, etc. at the top of the file, but this is a process that could not possible be done by hand. I

Re: mysql.sock

Oliver Etzel - GoodnGo.COM (R) wrote: Hello all, after Installing mysql I started the mysql daemon.. The I tried to log in to my mysql database and got the message could not find mysql.sock in /tmp. In the mysql-configuration file /etc/my.cnf (in my redhat system 8.0) I changed the place for the

Re: Searching Archives

Hi Ernest, There are several ways to do it. Most pages like www.mysql.com or mirrors (geocrawler etc.) have a build in search function. http://lists.mysql.com/ (watch for the Archive links) http://lists.mysql.com/list.php?list=mysql#b (link for the general list - the one you are subscript to to

RE: Re: What's up with this GATOR crap?

Hi Nestor - I use "SpyBot Search and Destroy" and it did a nice job cleaning everything. Its free but anyone can contribute to the cause. You'll find it at http://security.kolla.de/. It's worth a look at. Jeff -Original Message- From: Nestor Florez [mailto:[EMAIL PROTECTED] Sent: Satur

select by weekly SUM

I have a table of daily information (tips, # of deliveries, etc.). Does anyone know of an easy way using SQL to extract all weekly sums of a field? Like: week 1: sum of tips for that week week 2: sum of tips for that week week 3: sum of tips for that week week 4: sum of tips for that week week 5

delete across multiple tables problem

I'm trying to help a friend with this. When I run this everything is fine SELECT * from clicks, urls WHERE clicks.url=urls.url AND urls.description IS NULL The clicks table has 31 instances of url that match 5 instances of url in the urls table. When I run the following I get a syntax error DEL