I find a solution that works:
SELECT writer_id, writer FROM writer WHERE writer REGEXP '^[A-Z]+' ORDER
BY writer
Thank you all
Nikos
misiaQ wrote:
> Hi,
>
> If the efficiency is the key factor I would suggest to create a trigger on
> insert and update and mark the row
Hello list
I have a list of names with english and greek characters.
How can select them separately?
I mean, only greeks or only english.
thank you,
Nikos
That is a grate solution.
The problem is that I must have deferent links for each response.
That's the tricky thing!
Thank you
Sebastian Mendel wrote:
nikos schrieb:
Hello list
I have to make a full text search and I want to do it in many tables.
I have deferent tables for books author
Hello list
I have to make a full text search and I want to do it in many tables.
I have deferent tables for books authors and news.
Any ideas how to do it?
Thank you
Nikos
ation Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
*From:* nikos [mailto:[EMAIL PROTECTED]
*Sent:* Wednesday, April 25, 2007 11:41 AM
*To:* Jerry Schwartz;
depend upon the collating sequence for the field.
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
-Original Message-----
From: nikos [mailto:[EMAIL PROTECTED]
Sent: Wednesday, April 25, 2007 10:07 AM
To:
Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
-Original Message-----
From: nikos [mailto:[EMAIL PROTECTED]
Sent: Wednesday, April 25, 2007 9:28 AM
To: mysql@lists.mysql.com
Subject: select first letters
Hello list.
I want to select discinct the first letters of t
Seems that work in v. 4.1.21
but not in 5.0.27
Thank you Dusan
Dus(an Pavlica wrote:
I'm not sure, but I think that greek characters are sorted after
English chars so try this:
SELECT DISTINCT LEFT(title,1) FROM odigos_details WHERE LEFT(title,1)
> 'z' ORDER BY title
KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8
and I run:
SELECT DISTINCT LEFT(title,1) FROM odigos_details ORDER BY title
witch is working fine.
Thank you.
Nikos
Hmm!
Clever!
Thanx
Rolando Edwards wrote:
SELECT ... FROM ... LIMIT 20,1;
100 million is a little exaggeration
but you can other reasonably high numbers.
Remember, LIMITs are zero-based not 1-based.
- Original Message -
From: "nikos" <[EMAIL PROTECTE
Hello list.
Does any body knows how to select not the LIMIT 20 records but the rest
of them?
MySQL version is 4.1.21-standard and I cant make a VIEW.
Thank you
Nikos
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com
06 6:02 PM
To: mysql@lists.mysql.com
Subject: Re: Function problem
On Thursday 07 December 2006 04:57, nikos wrote:
> WHEN x<50 THEN ceiling(x+x*0.25)
>
> when x>=50 AND x<100 then ceiling(x+x*0.20)
>
> when x>=100 AND x<150 then ceiling(x+x*0.15)
>
> when
0 then ceiling(x+x*0.20)
when x>=100 AND x<150 then ceiling(x+x*0.15)
when (x>=150 AND x<200) then (ceiling(x+x*0.10))
when (x>=200) then (ceiling(x+x*0.09))
end case;
END$$
DELIMITER ;
Thanx
Nikos
Hello list
I've just install v4.1.
Every thing works fine exept SQLyong shows all non-latin characters as
question marks and the old Mysql-Front can't connect with tables after
mysql_fix_privilege_tables.
How can I change character_set_client=greek or UTF8 than to latin?
I thing this will solve my
Hello list
I've just install v4.1.
Every thing works fine exept SQLyong shows all non-latin characters as
question marks and the old Mysql-Front can't connect with tables after
mysql_fix_privilege_tables.
How can I change character_set_client=greek than to latin?
I thing this will solve my problem
2002 hangs with MyODBC 3.51.11
The attachment was stripped by the list manager: forwarded to list for
general information
Shawn
- Forwarded by Shawn Green/Unimin on 10/18/2005 12:07 PM -
Shawn Green/Unimin
10/18/2005 11:48 AM
To
"nikos" <[EMAIL PROTECTED]>
cc
mysql
driver but I get the same problem: access still
hangs up.
In the event viewer there is the following problem:
"Faulting application msaccess.exe, version 10.0.6501.0, faulting module
msjet40.dll, version 4.0.9025.0, fault address 0x000e9f60. "
Does any body know what's the problem?
Ok, I get it...
Thanx everybody..
_
Qbit
Γατσής Νίκος - Gatsis Nikos
Web developer
tel.: 2108256721 - 2108256722
fax: 2108256712
email: [EMAIL PROTECTED]
http://www.qbit.gr
-Original Message-
From: Jay Blanchard [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 30, 2005 2:44
Hello list
Can somebody infor me what is the "Got error 127 when reading table
cat"?
Thank you
Nikos
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hello list and happy new year.
Recently I've install mysql 4.1 on win 2000 with IIS 5 and works
perfect. My problem is that when i'm trying to make a connection with
myodbc (latest release) as localhost I got the following message:
"Client does not support authentication protocol requestet by ser
Hi again,
i have one DB called MY_DATABASE and one table called CUSTOMERS.
What I want is to backup the table customers in another machine in a new
database called MY_DATABASE but the issue is that I want the table to renamed
to CUSTOMERS1
Which means
LOCAL MACHINE -> MY_DATABASE -> CUSTOMERS
Hello,
i have 2 questions about Replication.
1) I managed to make one slave and one master. The replication works fine and
it updates only one table from one database (cause of the
replicate-do-table=db.table1). The first question is can I tell mysql that
table1 from master to be named table2
is that a problem?
I want to avoid ftp db.txt files and then mysqlimport them
- Original Message -
From: "Egor Egorov" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, June 02, 2004 4:38 PM
Subject: Re: [mysql-php] mysqlimport error
> "ni
Hello list
I'm trying
mysqlimport --local -d --fields-enclosed-by="|" --fields-terminated-by=";" -
-lines-terminted-by="\n" -unikos -p mydb c://temp//programs.txt
but i get an
Error: File 'c:/temp/programs.txt' not found (Errcode: 2), when using
table: programs
What I'm doing wrong?
RH-9 - AP
Hello list
I have download the MySQL Administrator twice and when trying to gzip It
collapse.
Does anybody know how and why?
Thanks
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hello list
I'm trying to install MySQL-server-4.1.1-1.i386.rpm on a RH-8 Linux.
System after systme check says than need LIBMYSQLCLIENT.SO.10 file to
continue.
Can somebody help me with this situation please?
Thanx in advance
Nikos
--
MySQL General Mailing List
For list archives:
ok thanx
- Original Message -
From: "Paul DuBois" <[EMAIL PROTECTED]>
To: "Nikos Gatsis" <[EMAIL PROTECTED]>; "Victor Pendleton"
<[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, November 19, 2003 2:58 AM
Subject: Re: [PHP-D
And the columns:
Grantor, Timestamp Table_priv, Column_priv
what is up to?
Thanx again
- Original Message -
From: "Victor Pendleton" <[EMAIL PROTECTED]>
To: "'Nikos Gatsis'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Monday, November 1
Hello List.
Does anybody knows how to configure table_priv table of Mysql?
I didn't find something in manual
I have v. 3.23.41 in Linux
Thanx
Nikos
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
o the local database.
Any ideas how to do that;
I use mysql 3,23,33 and php 4,06
Thanx
Nikos
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
rsion) but i'm not sure how quickly it can
be upgraded.
cheers
nikos
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request th
31 matches
Mail list logo
