ORDER BY lithuanian

2004-08-02 Thread tl 
Hello,

I have a problem.

  
Lithuanian letters:


aceeisuuz


What I must use to sort by this ORDER?


When I use

mysql CREATE TABLE w
   (
   s  VARCHAR(5) CHARACTER SET cp1257 COLLATE cp1257_lithuanian_ci
   );
Query OK, 0 rows affected (0.04 sec)


mysql insert into w values(''),('a');
Query OK, 2 rows affected (0.00 sec)
Records: 2  Duplicates: 0  Warnings: 0

mysql select * from w;
+---+
| s |
+---+
|  |
| ???a |
+---+
2 rows in set (0.00 sec)

I got question mark '?'?

:(

Please help me.




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

ENABLE KEYS

2002-10-21 Thread tl 
Please help me!

mysqlalter table a_log ENABLE KEYS;
ERROR 1064: You have an error in your SQL syntax near 'ENABLE KEYS' at line 1


Thank's


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

REGEXP

2002-10-13 Thread tl 

Hello,

mysqlLOAD DATA LOCAL INFILE 'access.log' INTO TABLE tmp FIELDS TERMINATED BY 'REGEXP 
\^[ ]{1,}$\' OPTIONALLY ENCLOSED BY '' ESCAPED BY ' '  LINES TERMINATED BY '\n' ;

How can I make that it would work as I expected?
How terminate fields by space(s)?

Thanks Very much.

Alvydas




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Problem Importing Data from Text File, HOW IGNORE SOME TEXT COLUMNS???

2002-10-12 Thread tl 

Hello,

#If I have a file t.txt

111 222 333 ddd 444 ddd
111 222 333 ddd 444 ddd
111 222 333 ddd 444 ddd


# A table

CREATE TABLE userdata (
a1 varchar(128) NOT NULL default '',
a2 varchar(128) NOT NULL default '',
a3 varchar(128) NOT NULL default '',
a4 varchar(128) NOT NULL default '',
KEY a1 (a1),
KEY a2 (a2),
KEY a3 (a3),
KEY a4 (a4)
) TYPE=MyISAM;


# How insert into table - text columns  with indexes: (1, 2, 3, 5) ??
# How ignore text columns with indexes (4, 6) ???
mysql LOAD DATA LOCAL INFILE 't.txt' INTO TABLE userdata FIELDS
mysql TERMINATED BY ',' ENCLOSED BY '' (a1, a2, a3, a4);


# If need to have this rezult:
mysql select * from userdata;
+-+-+-+-+
| a1  | a2  | a3  | a4  |
+-+-+-+-+
| 111 | 222 | 333 | 444 |
| 111 | 222 | 333 | 444 |
| 111 | 222 | 333 | 444 |
+-+-+-+-+


Thanks Very much.

Alvydas




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Repair TABLE - OPERATION FAILED

2002-10-11 Thread tl 

Hello,
Please help me.

mysql repair table none;
+++--+-+
| Table  | Op | Msg_type | Msg_text|
+++--+-+
| n_toccata.none | repair | error| 28 when writing to datafile |
| n_toccata.none | repair | error| 28 when writing to datafile |
| n_toccata.none | repair | status   | Operation failed|
+++--+-+
3 rows in set (0.14 sec)


mysql select * from none limit 12;
ERROR 1016: Can't open file: 'none.MYD'. (errno: 144)
mysql check table none;
++---+--+-+
| Table  | Op| Msg_type | Msg_text 
|   |
++---+--+-+
| n_toccata.none | check | warning  | Table is marked as crashed and last repair 
|failed   |
| n_toccata.none | check | warning  | Size of indexfile is: 309248  Should be: 
|35840  |
| n_toccata.none | check | error| Size of datafile is: 2809856 Should be: 
|2809916 |
| n_toccata.none | check | error| Corrupt  
|   |
++---+--+-+
4 rows in set (0.00 sec)



Thank's very much.

Alvydas




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

mysqldump ERROR

2002-09-26 Thread tl 

Please help me mysqldump:
ON:
mysqldump --opt --user=user_name -pPassword _stat_ | gzip -1  database.gz

I have an error :
mysqldump: Got error: 1017: Can't find file: './_stat_/_stat_193_219_2_250.frm' 
(errno: 24) when using LOCK TABLES


Thanks very much.




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

REPAIR TABLE

2002-09-25 Thread tl 

Please help me alter table:
___
|  |
 CREATE TABLE `f_ivairus_bodies` (
  `id` int(11) NOT NULL default '0',
  `body` text NOT NULL,
  `thread` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `thread` (`thread`)
) TYPE=ISAM PACK_KEYS=1
|___|

On:
mysqlalter table  f_ivairus_bodies TYPE = MYISAM;
I have an error :
mysqlERROR 1062: Duplicate entry '1867' for key 1

Thanks very much.




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

ALTER TABLE

2002-09-25 Thread tl 

Please help me alter table:
___
|  |
 CREATE TABLE `f_ivairus_bodies` (
  `id` int(11) NOT NULL default '0',
  `body` text NOT NULL,
  `thread` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `thread` (`thread`)
) TYPE=ISAM PACK_KEYS=1
|___|

On:
mysqlalter table  f_ivairus_bodies TYPE = MYISAM;
I have an error :
mysqlERROR 1062: Duplicate entry '1867' for key 1

Thanks very much.




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

ALTER TABLE

2002-09-25 Thread tl 

Please help me alter table:
___
|  |
 CREATE TABLE `f_ivairus_bodies` (
  `id` int(11) NOT NULL default '0',
  `body` text NOT NULL,
  `thread` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `thread` (`thread`)
) TYPE=ISAM PACK_KEYS=1
|___|

On:
mysqlalter table  f_ivairus_bodies TYPE = MYISAM;
I have an error :
mysqlERROR 1062: Duplicate entry '1867' for key 1

Thanks very much.




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re[2]: FULLTEXT questions

2002-09-20 Thread tl 

Please help me repair table:
___
|  |
 CREATE TABLE `zinutes` (
  `hid` int(10) unsigned NOT NULL default '0',
  `tipas` int(10) unsigned NOT NULL default '0',
  `msg` text NOT NULL,
  `autorius` varchar(60) NOT NULL default '',
  `email` varchar(60) NOT NULL default '',
  `data` datetime NOT NULL default '-00-00 00:00:00',
  `host` varchar(60) NOT NULL default '',
  `id` int(10) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (`id`),
  KEY `hid` (`hid`)
) TYPE=ISAM PACK_KEYS=1 
|___|

mysql repair table zinutes;
+--++--++
| Table| Op | Msg_type | Msg_text  
| |
+--++--++
| alio.zinutes | repair | error| The handler for the table doesn't support 
|check/repair |
+--++--++
1 row in set (0.00 sec)

mysql check table zinutes;
+--+---+--++
| Table| Op| Msg_type | Msg_text   
||
+--+---+--++
| alio.zinutes | check | error| The handler for the table doesn't support 
|check/repair |
+--+---+--++
1 row in set (0.01 sec)




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

REPAIR TABLE

2002-09-20 Thread tl 

Please help me REPAIR TABLE:
___
|  |
 CREATE TABLE `zinutes` (
  `hid` int(10) unsigned NOT NULL default '0',
  `tipas` int(10) unsigned NOT NULL default '0',
  `msg` text NOT NULL,
  `autorius` varchar(60) NOT NULL default '',
  `email` varchar(60) NOT NULL default '',
  `data` datetime NOT NULL default '-00-00 00:00:00',
  `host` varchar(60) NOT NULL default '',
  `id` int(10) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (`id`),
  KEY `hid` (`hid`)
) TYPE=ISAM PACK_KEYS=1 
|___|

mysql repair table zinutes;
+--++--++
| Table| Op | Msg_type | Msg_text  
| |
+--++--++
| alio.zinutes | repair | error| The handler for the table doesn't support 
|check/repair |
+--++--++
1 row in set (0.00 sec)

mysql check table zinutes;
+--+---+--++
| Table| Op| Msg_type | Msg_text   
||
+--+---+--++
| alio.zinutes | check | error| The handler for the table doesn't support 
|check/repair |
+--+---+--++
1 row in set (0.01 sec)

Thanks very much.




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

ERROR 1030: Got error 127 from table handler

2002-06-18 Thread tl 

Hello MySQL,

I do select:
select SUM(IF((@a:=(( ( ((@data:= DATE_FORMAT(data,'%Y-%m-%d')) IN 
('2001-11-10','2001-12-22','2001-12-29')) OR (WEEKDAY(data) IN ('0','1','2','3','4')) 
) AND (HOUR(data) '19' AND HOUR(data) ='8') ) AND !(@data IN 
('2001-07-06','2001-08-15','2001-11-01','2001-11-02','2001-12-24','2001-12-25','2001-12-26','2001-12-31','2002-01-01','2002-03-11','2002-04-01','2002-05-01','2002-08-15','2002-11-01','2002-12-25','2002-12-26'))
 )),in_s,'0')) as ipm, SUM(IF(@a, ot_s,'0')) as opm, SUM(IF(!@a, in_s,'0')) as inm, 
SUM(IF(!@a, ot_s,'0')) as onm FROM _stat_._stat_10_4_1_10 where 
DATE_FORMAT(data,'%Y-%m') = '2002-05' AND DATE_FORMAT(data,'%Y-%m-%d') BETWEEN 
'-00-00' AND '-00-00' ;
 got error:
ERROR 1030: Got error 127 from table handler
  
Please, HELP ME!
Thank very much.




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php