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
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)
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
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
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
12 matches
Mail list logo