Здравствуйте!
Загляние сюда:
http://dev.mysql.com/doc/refman/4.1/en/charset.html
Обратите внимание на 'SET NAMES', оно должно помочь, если проблема при
"выходе" из таблицы.
Have a look here:
http://dev.mysql.com/doc/refman/4.1/en/charset.html
Pay attention to 'SET NAMES' statement.
Г
sita.NET http://www.ensita.net/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Gleb Paharenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET
<___/ www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.
these jobs will hit the above
> code. The problem is that every so often I see the following error
> message.
>
> Error inserting records into database [Caused by: Duplicate entry '131'
> for key 1]
>
> What am I doing wrong?
>
> How am I suppose to be doin
x27;Event too big', data_len:
> 1635131433, event_type: 109
> Could not read entry at offset 1384:Error in log format or read error
>
> Is there anything else I can try?
>
>
> Martijn
>
>
>
>>Datum: 08/02/06 01:52 PM
>>Van: "Martijn van den Burg&
ef=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Gleb Paharenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET
<___/ www.mysql.com
--
MySQL General Mailing List
For list archives: http:
NULL |2 | 3 |
> 2 | 4 | x| x | x |
&g
result mysqldump don't throw the warning.
>
>
> What't the warning mean?How to avoid this warning?
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
__ ___ ___ ___
ndler_update 2019640
> Handler_write 2020645
> Key_blocks_used 40
> Key_read_requests 2019841
> Key_reads 6
> Key_write_requests 106
> Key_writes 0
> Max_used_connections 7
> Not_flushed_delayed_rows 0
> Not_flushed_key_blocks 0
> Open_files 22
> Open_streams 0
&
h of my other points
> are closer and what the distance is.
>
> Any clues?
>
> Thank you in advance,
> Jose.
>
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
__
Hello.
You can post a bug:
http://dev.mysql.com/doc/refman/5.0/en/bug-reports.html
Lola J. Lee Beno wrote:
> Gleb Paharenko wrote:
>
>> Hello.
>>
>> The query which is works is:
>
>
>
> Thanks - just what I needed. Looks like I'll need to be extra
.
> See http://dev.mysql.com/doc/mysql/en/InnoDB_foreign_key_constraints.html
> for correct foreign key definition.
>
>
> Which leads me back to the same URL that you gave me. so, it looks like
> I should create an index for FilmsRatings first, and then
ts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Gleb Paharenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET
<___/ ww
/www.ensita.net/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Gleb Paharenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET
<___/ www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
ed by Ensita.NET http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ /Gleb Paharenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET
<___/ www.mysql.com
--
MySQL General Mailing List
For list archives: http://list
odify the table?
>
> Thanks,
>
> Scott Johnson
> [EMAIL PROTECTED]
> Tel.: (514) 917-4922
> Fax: (514) 673-0011
>
>
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
__ _
hese results in the last REGEXP query example
> above, something like this:
>
> SELECT * FROM table WHERE value REGEXP '^\\[(SELECT id FROM items
> WHERE parent=5)'
>
> Anyone got any clues?
>
> --
> Kim Christensen
> [EMAIL PROTECTED]
--
For t
days.How you
> comment this?
>
> In my system FreeBSD work RADIUS and write account in database on MySQL
> server . Calls friquency is 1-8 in one second.
>
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http
with Yahoo!. Enter now.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Gleb Paharenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_
e every 1 with a yes and 0 with a no.
>
> I would be most grateful for your comments on this.
>
>
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
__ ___ ___
r technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Gleb Paharenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET
<___/ www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Add(' index (OutgoingRef2)');
> Add(') TYPE=MyISAM;');
>end;
>SQLBatch.ExecSql;
>
> This seems to work fine. Any ideas on why it works with one and not the
> other?
>
> Kerry
>
--
For technical support contracts, goto https://order.m
__
> Eamon Daly
>
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Gleb Paharenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTE
ar what's new at MSN - sign up to our free
> newsletters! http://www.msn.co.uk/newsletters
>
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
__ ___ ___ __
/ |/ /
respectively.
>
> This is driving me crazy. I am obviously doing something stupid but I have
> got so close to the problem I can't see the wood for the trees.
>
> Kerry
>
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored b
g MyISAM tables for MySQL 5.0.
>
> Cor
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Gleb Paharenko
/ /|_/ / //
y the sender immediately and delete it.
> __
>
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Gleb
many orphaned sockets. Do
> the above indicate orphaned sockets? I logged into mysql root and did a 'show
> full processlist' and there were only one or two mysql processes. Can
> someone explain why there might be so many tcp sockets taken up to c
t; I'm sorry if these are very basic, MySQL 101, questions ... I am a very
> basic recreational coder :-)
>
> Cheers
> Dougal
>
>
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
__ ___
to regain the free space?
>
> Comments/suggestions/flamings solicited.
>
> Regards,
> Rithish.
>
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
__ ___ ___ __
/ |/ /_ _
;character_sets';
statement.
OKAN ARI wrote:
> yes it is mysql 4.0 how can I set i to latin 5 or how can I set the
> server to latin 5?
>
> os: centos 4.2
>
> Thank you
> - Original Message - From: "Gleb Paharenko"
> <[EMAIL PROTECTED]>
> To:
&
> I haven't try with INSERT INTO Y (t_y_time,and so on) SELECT
> (t_x_time, ... and so on) FROM X
> excluding t_y_id
>
> The table should not be locked, right :D
>
> Thx
>
>
> Gleb Paharenko wrote:
>
>> Hello.
>>
>> It seems that the p
_time`,`t_y_type`(3)),
> KEY `t_idx13` (`t_y_city`(7))
> ) ENGINE=InnoDB DEFAULT CHARSET=latin1
>
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
__ ___ ___ __
/ |/ /_ __/ __/ __ \
sita.NET http://www.ensita.net/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Gleb Paharenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET
<___/ www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
ort contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Gleb Paharenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET
<_
to latin5 for mysq4 in linux?
>
> OKAN
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Gleb Paharenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL
support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Gleb Paharenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET
> What can I do?
>
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Gleb Paharenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_,
other
> operation to be finished
>
> Why concurrent insert is not working?
>
> FYI, i use standar configuration from MySQL
>
> Any explanation?
>
> Thx
>
>
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email
https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Gleb Paharenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET
<___/ www.mysql.com
--
robs http://www.pro.or.jp/~fuji/sudoku/problems/
> ----
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Gleb Paharenko
/ /
a.NET http://www.ensita.net/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Gleb Paharenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET
<___/ www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
echnical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Gleb Paharenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET
ent variable.
[EMAIL PROTECTED] wrote:
> Hi Gleb Paharenko ,
> Thanks for replying to the email.
> Actually i have done locate my.cnf and cannot find he file.
> I am sure this file do not exist on mine VPS.
> I wanted to know that is it OK to add an entry into /etc/rc.d/rc.local
ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Gleb Paharenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET
<___/ www.mysql.com
--
MySQL General Mai
I shall be very grateful.
> --
> Regards
> Abhishek jain
>
>
> mail2web - Check your email from the web at
> http://mail2web.com/ .
>
>
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.en
sponsored by Ensita.NET http://www.ensita.net/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Gleb Paharenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET
<___/ www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
sponsored by Ensita.NET http://www.ensita.net/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Gleb Paharenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET
<___/ www.mysql.com
--
MySQL General Mailing List
For list archives: htt
ards,
> David P. Donahue
> [EMAIL PROTECTED]
> http://www.cyber0ne.com
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /
This email is sponsored by Ensita.NET http://www.ensita.net/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Gleb Paharenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET
<___/ www.mysql.com
--
MySQL General Mailin
! Mail.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Gleb Paharenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\
com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Gleb Paharenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET
<___/ www.mysql.com
--
MySQL General Mailing List
For list ar
> shell>replace @@session.sql_mode=0 @@session.sql_mode=1 -- 1.01
> -
> But string "@@session.sql_mode=0" doesn't replace to "@@session.sql_mode=1".
>
>
>
> - Original Message -
> From: &q
uot; .mysql_error());
> while ($row = mysql_fetch_row($result)) foreach($row as $key=>$value) echo
> "$key=>$value";
>
> hope this provides the appropriate info.
> Thanks
>
> "Gleb Paharenko" <[EMAIL PROTECTED]> wrote in message
> news:[E
t; I'm not sure of the syntax. (Looks to me like all required
> info is present ;) id is primary key and the only unique
> index.
>
> Thanks,
> Jon
>
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsor
erwinkel
> StraXe')"
>
> How would I configure mysql so characters like � can be inserted without
> problems.
>
> Thanks
> chris
>
>
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http:
s;
> -nat
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Gleb Paharenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___
DigitsPtr.
> The SQLRETURN always 0.
>
> Any Instruction is welcome.
> Thanks.
>
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
__ ___ ___ __
/ |/ /_ __/ _
or the right syntax to use near ''
> at line 1
> 060125 13:23:58 [ERROR] Aborting
>
> 060125 13:23:58 [Note] ./bin/mysqld: Shutdown complete
>
>
> WARNING: HELP FILES ARE NOT COMPLETELY INSTALLED!
> The "HELP" command might not work properly
>
mysqld: Shutdown complete
>
> 060124 14:15:44 mysqld ended
>
> Your help is appreciated.
> -nat
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
__ ___ ___ __
#x27;x' in conv_param)+1) INTO
> end_of;
> SET @string_query=CONCAT("SELECT ",beginning,fdata,end_of,"INTO
> @fdata_converted");
> PREPARE st1 FROM @string_query;
> EXEC
Hello.
> collation. PHP 4.4 doesn't provide API to work with
> Connection Character Sets and Collations. PHP 5 adds
You can change the character_set_xxx variables using SQL
queries. I usually put 'SET NAMES' at the beginning of my
scripts.
立 周 wrote:
> --- Gleb Pah
in dbB.B?
>
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Gleb Paharenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\
any damage caused by any virus transmitted by this
> email.
>
> www.wipro.com
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Gleb Pa
and column level) and it still
> doesn't work.
>
> Lionel
> .
>
>
>
>
>
>
>
> ___
> 雅虎1G免费邮箱百分百防垃圾信
> http://cn.mail.yahoo.com/
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by E
" the
> integer part, if any) but the CAST and CONVERT are not the same
> functions and I have looked for 30 minutes for something that could work
> with no success.
>
> Thanks a lot for your help!
>
--
For technical support contracts, goto h
ched the MySQL installation stuff and have not found
> anything that's useful. I have also searched archives on Darwin
> Ports and found some similar problems, but nothing that
> completely helps!
>
> Sorry for my *newbness*! Please help me! =D
>
> ~Philip
&g
up server
> where I will tar/gzip the data and push
> it out to a back up directory so it will get dumped to tape.
>
> --
> Geo
>
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.en
t example) by converting special characters in a format understood by
> mysql as UTF8 and preserving the others characters!
> Is there a way?
>
> Thanks,
> Devy
>
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NE
sita
This email is sponsored by Ensita.NET http://www.ensita.net/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Gleb Paharenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET
<___/ www.mysql.com
--
MySQL General Ma
>
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ /Gleb Paharenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/
involves a call to a Stored Procedure, which in turn ends up
> calling other stored procedures to faciliate all the transactions,
> validations and inserts...I assume that's not too much more innefficient
> than using sql insert statements directly.
>
> Any help is ap
l: [EMAIL PROTECTED]
>
>
>
>
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Gleb Paharenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL P
Hello.
There a lot of different ways to perform this operation. See:
http://dev.mysql.com/doc/refman/5.0/en/replace-utility.html
man sed
man awk
wangxu wrote:
> How to replace it?
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://l
MIT 100)
> ORDER BY counter LIMIT 100;
> ERROR 1267 (HY000): Illegal mix of collations
> (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for
> operation 'UNION'
>
>
> is accepted:
> (SELECT
> name,firm,status,businesscategory,addon,actiony,date_last_action,counter,task_counter
> FROM tasks2 LEFT OUTER JOIN contacts2 ON tasks2.contact_link =
> contacts2.counter WHERE name LIKE '%meier%' ORDER BY counter LIMIT 100)
> UNION (SELECT name,firm,status,businesscategory,addon, _latin1'','',
> counter,'' FROM contacts2 WHERE name LIKE '%meier%' ORDER BY counter
> LIMIT 100) ORDER BY counter LIMIT 100;
>
>
>
>
>
> suomi
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Gleb Paharenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET
<___/ www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hello.
> ERROR 1314 (0A000): PREPARE is not allowed in stored procedures
PREPARE in the stored procedures should work in the latest release (5.0.18).
David Godsey wrote:
> Thank you. I tried this outside of the procedure and it works. However In
> MYSQL 5 I get:
> ERROR 1314 (0A000): PREPARE
RAINT end_time_cannot_be_before_start_time CHECK (end_time >=
> start_time),
>
> PRIMARY KEY (class_id, start_date, end_date, start_time, end_time)
> );
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://
ble means only that the boss will add it to your
> regular duties.
>
> David Godsey
>
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /
email is sponsored by Ensita.NET http://www.ensita.net/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Gleb Paharenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET
<___/ www.mysql.com
--
MySQL General Mailing List
For list archi
gt; [mysqlhotcopy]
> interactive-timeout
>
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Gleb Paharenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET
<___/ www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
d mysqlimport & mysqldump...
>
> Thanks in advance
>
> Marco Schierhorn
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ /Gleb Pahare
Hello.
What data type are you using to store the result of AES_DECRYPT? Please,
send the CREATE statement for your table.
sharif islam wrote:
> On 1/19/06, Gleb Paharenko <[EMAIL PROTECTED]> wrote:
>
>>Hello.
>>
>>What doesn't work? In case you want more hel
c_time=0 error_code=0
> SET TIMESTAMP=1137661847;
> INSERT INTO `ht_detail` VALUES
> ('79NK0001/0003','79NK0001',1),('79NK0001/0003','79NK0002',1),('79NK0001/0003','79NK0003',1);
> # at 2260
> #060119 17:10:47 server id 1
ntracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Gleb Paharenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.N
gt;
> Kind Regards,
>
> Gerald Glickman
>
>
>
> G2 Innovations.com, Inc.
>
> http://www.g2innovations.com <http://www.g2innovations.com/>
>
>
>
>
--
For technical support contracts, goto https://order.mysql.com/?ref=en
r.
>
> I just do not understand what it is that I am supposed to do.
> Can someone provide some light?
>
> Wade
>
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
__ ___
password hashes ?
>
> Thanks,
>
> Gary
>
>
>
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Gleb Paharenko
/ /|_/ / //
Check your email from the web at
> http://mail2web.com/ .
>
>
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Gleb Paharenko
ttp://uk.messenger.yahoo.com
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Gleb Paharenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/
l.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Gleb Paharenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET
<___/ www.mysql.com
--
MySQL Gener
;
> Can someone advise me what has changed in the upgrade and how I can get back
> to using "integers"?
>
> kERRY
>
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://ww
and I try to restore
> it with "mysql -u root -pPwd DB < file.sql".
>
> Any ideas???
>
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
__ ___ ___ __
/ |/ /_ _
ication maybe a solution but i don't know what's
> happening when i trying to modifiy the slave database? The modification
> not get on the master, am i right?
>
> Thank you in advance!
>
> Best Regards
> Zsolt
--
For technical support contracts, goto https:/
:/mysql/data
>
> set-variable=max_connections=300
>
> log-bin
> server-id=20
>
> log-error
> log-slow-queries
> log-slave-updates
> log-warnings
>
> replicate-do-db=livedb_backup
> replicate-rewrite-db=livedb->livedb_backup
>
ne them.
> Thanks ahead,
> Yair.
>
>
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Gleb Paharenko
/ /|_/ / //
ing select statements out of the db?
>
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Gleb Paharenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL
f=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Gleb Paharenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET
<___/ www.mysql.com
--
MySQL General M
> Thanks,
>
> cybm
>
> On 1/17/06, Gleb Paharenko <[EMAIL PROTECTED]> wrote:
>
>>Hello.
>>
>>Sorry for such a late reply. The problem is in the duplicate line
>>`dealer_type_name`. Remove one of these lines. Please, always send
>>a copy of the mess
> What about next release in 4.1.x? May be it will fix this bug?
I hope it will.
Trux wrote:
> On Tuesday 17 January 2006 14:37, Gleb Paharenko wrote:
>
>
>>This is a bug:
>> http://bugs.mysql.com/bug.php?id=15965
>>
>>Have a look here as well:
>&g
solve this problem,
you should just recreate all triggers after an upgrade. If you use
mysqldump during the upgrade, it should recreate triggers automatically.
Ian Sales (DBA) wrote:
> Gleb Paharenko wrote:
>
>> Hello.
>>
>> Please, could you explain what does it
Hello.
Sorry for such a late reply. The problem is in the duplicate line
`dealer_type_name`. Remove one of these lines. Please, always send
a copy of the message to the list. Most probably somebody whould have
suggest you the same, if you had posted you mail to the list as well.
Kuai
cybermala
1 - 100 of 1664 matches
Mail list logo