Re: text retrieval functions

2004-12-15 Thread Alaios
consider? Sorry to ask so many questions but your question was so vague that it is unanswerable. Shawn Green Database Administrator Unimin Corporation - Spruce Pine Alaios [EMAIL PROTECTED] wrote on 12/15/2004 03:56:40 AM: Hi... I need some function and the appropriate type field s

text retrieval functions

2004-12-15 Thread Alaios
Hi... I need some function and the appropriate type field s of a table that are able to search and store big texts (such as books,magazines,articles) Thx a lot __ Do you Yahoo!? Yahoo! Mail - Find what you need with new enhanced search.

order by in different languages..

2004-11-07 Thread Alaios
Hi.. Listen to a peculiar problem. We need to order by a column which includes Greek language. The order by doesnot work correctly. The reason may be the administration's installation. So we need a nice trick for doing our job as fast as we can without interacting with the admin. Nice..eh? You can

select query does not work :(

2004-10-06 Thread Alaios
Hi we need to order a field in a select query... The criteria is based on greek language... The problem seems to be no support for greek language I can change everything in the my.cnf so tell what to do ___ Do you Yahoo!?

concurrent users sessions? !!!!!!

2004-05-28 Thread Alaios
Do u know how many users the MySQL server v4 can't support? I am talking about the users that are currently online. I want to know the maximum number for the MyISAM tables and InnoDB Do u know any links for continue reading? Thx - Do you

mysqlcc syntax file?

2004-02-16 Thread Alaios
Hi there. I am trying to create a table using the mysql control center but i am taking the error. Unable to locate syntax.txt Please locate the file. Any sugestion? __ Do you Yahoo!? Yahoo! Finance: Get your refund fast by filing online.

backup my database

2004-01-12 Thread Alaios
Hi there. Do u know how can i backup my database? (create insert) __ Do you Yahoo!? Yahoo! Hotjobs: Enter the Signing Bonus Sweepstakes http://hotjobs.sweepstakes.yahoo.com/signingbonus -- MySQL General Mailing List For list archives:

Re: foreign keys plz?

2003-12-27 Thread Alaios
with myIsam? Does not check about integrity? Mysql 3.2? What u will use for your application Innodb or MyISAM? --- Martijn Tonies [EMAIL PROTECTED] wrote: Hi, Hi there. I heave heared that mysql doesnot support foreign keys? It does, but only with the InnoDB table type. With

foreign keys plz?

2003-12-26 Thread Alaios
Hi there. I heave heared that mysql doesnot support foreign keys? What funcionallity provides and what not? Inner Join what provides? Thx __ Do you Yahoo!? New Yahoo! Photos - easier uploading and sharing. http://photos.yahoo.com/ -- MySQL General Mailing List

plz help a newbie

2003-12-12 Thread Alaios
Hi there just a lot lot lot of questions. Plz answer as many as you can. What do u prefer varchar(2) or tiny_text? What is the biggest size for the varchar? If I want to store a very big article. What is the biggest size for text that is being support? What is the difference between

test

2003-12-09 Thread Alaios
test - Do you Yahoo!? New Yahoo! Photos - easier uploading and sharing

what about foreign keys?

2003-12-06 Thread Alaios
Hi there I have some trouble with MyISAM tables. I have found that supports 3 different types of the 1:1 relation. a)1:1 b)1:1 (Non-Identyfying) c)1:1 (Descedent Obj.) What all these about? What type of tables do u use normally? I want to deploy a small application with a few tables (up

on delete|update

2003-12-03 Thread Alaios
Hi there. I am trying to find what these ON DELETE NO ACTION ON UPDATE NO ACTION would provide ib my db. What are the options and what each of them do? - Do you Yahoo!? Free Pop-Up Blocker - Get it now

Re: on delete|update--Disagreement

2003-12-03 Thread Alaios
- Original Message - From: Alaios To: Martijn Tonies Sent: Wednesday, December 03, 2003 4:57 PM Subject: Re: on delete|update axa!!! this works with myIsam tables? Martijn Tonies [EMAIL PROTECTED] wrote: Hi, Hi there. I am trying to find what these ON DELETE NO ACTION ON UPDATE NO ACTION

designer

2003-11-30 Thread Alaios
Do u know any programme that can degin databases in order to design before i implement them? It ll be very useful if the design was transformed to the correspondings create syntax? Thx - Do you Yahoo!? Free Pop-Up Blocker - Get it now

RE: designer

2003-11-30 Thread Alaios
Do u know this one? It seems to be gpl http://www.fabforce.net/dbdesigner4/ Peter Lovatt [EMAIL PROTECTED] wrote:Hi try DEZIGN FOR DATABASES http://www.datanamic.com/ hth Peter -Original Message- From: Alaios [mailto:[EMAIL PROTECTED] Sent: 30 November 2003 20:27 To: [EMAIL

Userpasswords

2003-11-13 Thread Alaios
Hi there . How can i passwords so i can login into myqsl. With current configuration anyone is allowded to login. __ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- MySQL General Mailing List For list

mysql_client

2003-11-13 Thread Alaios
Hi i have just installed the mysql_client and i am trying to remotely connect to the database of the other pc so i gave the following command mysqlshow -h 192.168.64.12 -u [EMAIL PROTECTED] mysqlshow: Host 'akroneiro' is not allowed to connect to this M What i msut do in order to gain access to

Re: Problem with query comparing to a DATE on Linux OpenOffice

2003-11-10 Thread Alaios
what a front-end is? And what OO1.1.0 provides? Marc [EMAIL PROTECTED] wrote:I'm using OpenOffice 1.1.0 as a front-end to MySQL 4.0.14 on Gentoo Linux and can't compare a field to CURDATE(). The error is, The field cannot be compared with a date. The column is formatted as a DATE, and I can