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

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)

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

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

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

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.

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

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

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

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,

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,

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