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
Please help me!
mysql>alter 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)
ht
Hello,
mysql>LOAD 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
---
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 '',
Hello,
Please help me.
mysql> repair table none;
+++--+-+
| Table | Op | Msg_type | Msg_text|
+++--+-+
| n_toccata.none | repair | error| 28
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.
-
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
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
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
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,
`
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,
`
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-0
12 matches
Mail list logo
