entering Chr(13) & Chr(10) in insert & update

mysql, query, sql (B (BHello folks (B (B Is there any way I can insert Chr(13) & Chr(10) along with string (Bcharacters in a blob field using *insert* or *update* statements. (B (B (B (BThanks for any suggestions (B (BKayambooSuresh (B (B (B-

entering Chr(13) & Chr(10) in insert & update

mysql, query, sql (B (BHello folks (B (B Is there any way I can insert Chr(13) & Chr(10) along with string (Bcharacters in a blob field using *insert* or *update* statements. (B (B (B (BThanks for any suggestions (B (BKayambooSuresh (B (B (B-

syntax

I portaded my Application from the MS SQL Server 7.0 to MySQL 3.23.54 and i'm having problems with the both syntax. How can i do this query in MySQL Server Syntax: "select sld_vlprov,hist_lanc from sld_lanc,lanc where sld_lanc.sld_user *= lanc.user_usuario and dt_movlanc > '02/12/03'"

4.0.6 + FLUSH QUERY CACHE -> mysqld got signal 11

Hello mysql, Hello mysql, shell#>resolve_stack_dump -s mysqld.sym -n mysqld.stack mysqld got signal 11; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be ca

large table and new index?

help! i have a table which is 1GB and 5 mio records. i must add new index to "live" table but every time i try to do it, it takes 15 minutes, mysql is working, then it dies saying it ran out of available connections. if i increment them, same result. i am doing this through phpMyAdmin but i think

Re: Increase MySQL Cache Size

Thanks very much, Stefan. Merry Christmas! :-) Geetika On Tue, 24 Dec 2002, Stefan Hinz, iConnect (Berlin) wrote: > Geetika, > > > If there are multiple caches in MySQL, I would welcome suggestions > > pertaining to all or any of them. Thanks! > > SHOW VARIABLES will show you what caches are s

Re: Increase MySQL Cache Size

Geetika, > If there are multiple caches in MySQL, I would welcome suggestions > pertaining to all or any of them. Thanks! SHOW VARIABLES will show you what caches are set for your MySQL installation. E.g., I do: mysql> select version(); show variables like '%cache%'; +---+ |

Compile/Install problems, NetBSD 1.6

Fellow MySQL'ers, I've been trying to install MySQL ver. 3.23.54a on NetBSD 1.6 on an i386 platform. The difficulty I've been running into is that the thing complains that it can't change directory to pthreads during compile. I've tried installing the NetBSD pthreads package (w

Re: 4.1 questions: subqueries which use dual

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Richard Clarke wrote: Dan, According to http://www.mysql.com/doc/en/News-4.1.0.html "SELECT ... FROM DUAL is an alias for SELECT (To be compatible with some other databases)." Your example does work however. mysql> select * from ( sele

Re: wildcard '%' for host in mysql.user table broken

At 12:37 +0300 12/24/02, [EMAIL PROTECTED] wrote: >Description: The command GRANT ALL ON dbname.* TO larry@"%" IDENTIFIED BY 'larry123'; FLUSH PRIVILEGES; properly changes the mysql.user table. However, if I subsequently attempt to use the mysql client like this mysql

Re: 4.1 questions: subqueries which use dual

Dan, According to http://www.mysql.com/doc/en/News-4.1.0.html "SELECT ... FROM DUAL is an alias for SELECT (To be compatible with some other databases)." Your example does work however. mysql> select * from ( select 1 ) d; +---+ | 1 | +---+ | 1 | +---+ 1 row in set (0.00 sec) Richa

RE: Starting of MySQL with redhat 8

To start the server run the following... service mysqld start once it is started you can check to see if it running by using... ps aux which will show the processes running and look for mysql Larry S. Brown Dimension Networks, Inc. (727) 723-8388 -Original Message- From: Scott Pippin

Re: 4.1 questions: subqueries which use dual

In the last episode (Dec 24), Richard Clarke said: > Victoria, > I pulled that latest updates to the 4.1 tree to make sure I had the most > recent version and I still have the same problem. Here is a log of my > actions. > > # cd /usr/local/mysql-4.1 > mysql-4.1 # bin/mysql --defaults-file=etc

Increase MySQL Cache Size

Hi: How do you increase the cache size in MySQL? Which parameter should I tweak, and also how do I find out the current default cache size? If there are multiple caches in MySQL, I would welcome suggestions pertaining to all or any of them. Thanks! Geetika ---

Re: Starting of MySQL with redhat 8

> I'm a beginner with mysql and i installed it with linux. > I'm getting this message when i tried to be connected : > Error 2002 : can't connect to local MySQL server through socket > '/var/lib/mysql/mysql.sock' (111). > > Can you help me by finding how to be connected to the database ? Make su

Re: 4.1 questions: subqueries which use dual

Victoria, I pulled that latest updates to the 4.1 tree to make sure I had the most recent version and I still have the same problem. Here is a log of my actions. # cd /usr/local/mysql-4.1 mysql-4.1 # bin/mysql --defaults-file=etc/my-small.cnf -u root Welcome to the MySQL monitor. Commands end

Re: time of query

Hi, ladies and gentleman! Well, I have solved my problem, though it was not actually a problem, I just wanted things to look cool :) 1. Download "Time::HiRes" perl module http://search.cpan.org/CPAN/authors/id/J/JH/JHI/Time-HiRes-1.39.tar.gz 2. Install it: "perl Makefile.PL; make; make test; ma

Re: Counting results using 2 tables.

On Tue, 2002-12-24 at 12:11, [EMAIL PROTECTED] wrote: > I wish to get a count of records contained in 1 table as compared to the > contents of a different table. What I have is a list of realtors in 1 > table (agents.name) The listings are contained in a different table > (listings) and each can be

multiple database connection

multiple database connection on windows 98 , mysqld running with pws here is some confusion with the multiple database connection variables i am executing the same code in three different ways it gives me diffrent output all the database and table are exsists method 1 -- "; $loca

Starting MySQL with Redhat 8.0

I had the same problem. I fixed it by realizing that when the program was installed it put the mysql.sock file in the /var/libs/mysql dir however when it starts it looks for the file in /tmp You can either change the folder it looks in, or do what I did and just copy the mysql.sock from /var/

BUG REPORT MYSQL WITH NSS_LDAP

Hello. I'd like to report a bug I've found with MySQL. MySQL, as shipped with Mandrake 9, gets hanged when starting it with safe_mysqld or service mysql start or /etc/rc.d/init.d/mysql ALWAYS WHEN NSS_LDAP IS ENABLED! I'd like to report this so that you can try if it's a bug from mysql or mandr

Counting results using 2 tables.

I wish to get a count of records contained in 1 table as compared to the contents of a different table. What I have is a list of realtors in 1 table (agents.name) The listings are contained in a different table (listings) and each can be identified by their agent by listings.agent. Here's the que

re: Starting of MySQL with redhat 8

On Tuesday 24 December 2002 15:07, AmitiИ Plus wrote: > I'm a beginner with mysql and i installed it with linux. > I'm getting this message when i tried to be connected : > Error 2002 : can't connect to local MySQL server through socket > '/var/lib/mysql/mysql.sock' (111). > > Can you help me by

re: DELETE with no WHERE clause

On Monday 23 December 2002 22:21, Gordon wrote: > DID DELETE FROM XXX with no where clause stop acting like truncate in > 4.0.5? > > In 3.23.51 and earlier versions of 4.0.x > > mysql> delete from product_order_main; > GIVES THIS > Query OK, 0 rows affected (0.10 sec) > > AND RESETS THE AUTO

re: 4.1 questions: subqueries which use dual

On Sunday 22 December 2002 08:06, wrote: > Mysql, > Selecting from `dual` with a simple query works fine, > > mysql> select 1 x from dual; > +---+ > > | x | > > +---+ > > | 1 | > > +---+ > > but within a derived table, > > mysql> select * from (select 1 x from dual) s; > ERROR 1146: Table 'tes

Do I have to modify mysql-bin.index when purging old binary logs?

Hi Subject says all, is everything fine when I just flush-logs every morning and remove every logfile that is older than 30 days? Or do I have to delete the corresponding line from the index file as well? Whatfor is it needed, btw? bye, -christian- # for the bot: mysql php query -

Problem with 4.0.4

Hi people, I have a problem running mysql 4.0.4 using mostly innodb tables: mysql starts without any problems, then after about a half-hour it returns queries with errors that databases are not found. And indeed, "show databases" command shows the single database with a name "vi.recover". The syst

"connect by" clause...

Hi. It's Christmas and I'm sending my wish list to Santa Claus... ;o) 1. hierarchical queries I've seen an interesting patch to PostgreSQL to implement hierarchical queries similar to those available with Oracle (http://gppl.terminal.ru/readme.html). This kind of query makes handling trees a

Bug MyODBC 3.51?

I have the following problem: I use Delphi 7 in combination with TADOquery and MyODBC 3.51. I got "unspecified error" when i run the next query: - qry.SQL.Add('select * from lokalen'); - qry.open; if i define the query on design time (in the property SQL of TADOQuery), it works fine. - qry.op

Re: MySQL Security Flaw - Dropped Databases

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, On Thu, 19 Dec 2002, Michael Widenius wrote: > With 'DROP DATABASE database_name'. > Through the depricated client function 'mysql_drop_db()'. > > The first case works correct but in the second case the grant check > is not done. I tracked this

recover databases.

Hello all, I'm quite newbie with MySql, so i apologize if this is a trivial question. I did a small database, but fortunately not yet in production. This Week-End happened a power cut and I didn't made any backup of my databases :( When i restarted Mysql, i could not log in as any user i allowed

Re: wildcard '%' for host in mysql.user table broken

Larry, > GRANT ALL ON dbname.* TO larry@"%" IDENTIFIED BY 'larry123'; > FLUSH PRIVILEGES; > > properly changes the mysql.user table. However, if I subsequently > attempt to use the mysql client like this > > mysql -h -u larry -p dbname > > and enter 'larry123' at the pass

我的第一桶金

mysql:ÄúºÃ! http://www.zgda.net/index.asp?id=265 50ÔªÈËÃñ±Ò£¬¶ÔÄúÀ´ËµÒâζ×Åʲô£¿ Ò»²ÍÂôµ±ÀÍ£¿¶þÕŵçӰƱ£¿»¹ÊǼ¸°üÏãÑÌ£¿ µ±È»£¬ÄúÓÐÄúµÄÑ¡Ôñ£¡ ¿ÒÇëÄú¸øÎÒÒ»·ÖÖÓ£¬ÈÃÎÒ˵˵50ÔªÔÚÕâ¸öÐÂÐ˶øÕýÔÚѸËÙ·¢Õ¹µÄMLMÍøÕ¾ http://www.zgda.net/index.asp?id=265 Òâζ×Åʲô£º 1.Ò»¸ö²»¶Ï¸üкÍÌí¼ÓµÄµçÓ°ÍøÕ¾ÖÕÉí¸ß

Re: Starting of MySQL with redhat 8

service mysql start Search the list for more information Adolfo On Tue, 2002-12-24 at 09:07, Amitié Plus wrote: > Hello, > > I'm a beginner with mysql and i installed it with linux. > I'm getting this message when i tried to be connected : > Error 2002 : can't connect to local MySQL server thro

Starting of MySQL with redhat 8

Hello, I'm a beginner with mysql and i installed it with linux. I'm getting this message when i tried to be connected : Error 2002 : can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111). Can you help me by finding how to be connected to the database ? -

Re: reports

What type of reports you want ? Probably you will have to develop your customized app to get the reports you want. Insane - Original Message - From: "geeta varu" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, December 24, 2002 12:25 PM Subject: reports > sir, > i would like

RE: SOLVED! (was: Re: What is wrong with this query?)

It's not a true daemon...Mike's comment on using a wait or waitpid is valid. If you're interested, read up on daemon processes in APUE (chap. 13) from Stevens. Your process is still associated with a terminal and is not the process group leader and is not the session leader. I highly recommend i

mysqlcc 0.8.7-alfa (win32) not supporting russian charset?

Hello when using mysqlcc and adding for russian symbols into database fields, it represents as "??" When using other client - all is o'k. the repeatable steps are: 1. open mysqlcc 2. open some table 3. enter in the field of type "string" some russian letters 4. uddate this record 5. see the "

re: now() function not working with load data infile

Well, I don't really agree with that. I've tried to load data in file with a datetime field and it worked very well. Obviously, I could advice you to create a field with datetime type and don't forget to format your input datetime in your file like that: "-mm-jj hh:min:ss" (without the quo

It is a bug?

Hi, I have installed mysql max 4.0.4 beta on a Suse (ver. 8.0) linux server and I have created a database with this schema: CREATE TABLE ecoras ( rsnum tinyint(4) NOT NULL, rsori tinyint(1) NOT NULL, rscod int(11) NOT NULL, rsid int(11) NOT NULL auto_increment, rsdat date NOT NULL defa

non replicated tables

Hi I am using MySQL version 3.23.49 with one master and one slave that can change of course. Lately I've been using the option to not replicate certain tables (replicate-ignore-table) and it is not working for inserts. My my.cnf file in the slave looks like: [mysqld] log-bin server-id=2 binlog-

re: now() function not working with load data infile

On Tuesday 24 December 2002 10:30, [EMAIL PROTECTED] wrote: > I've created a test table with two columns. The first > one is a varchar type for inputting first names. The > second column is datetime. The table will eventually > expand to include a timestamp column, so I am not > interested in g

wildcard '%' for host in mysql.user table broken

>Description: The command GRANT ALL ON dbname.* TO larry@"%" IDENTIFIED BY 'larry123'; FLUSH PRIVILEGES; properly changes the mysql.user table. However, if I subsequently attempt to use the mysql client like this mysql -h -u larry -p dbname and enter 'larry123' at the

now() function not working with load data infile

I've created a test table with two columns. The first one is a varchar type for inputting first names. The second column is datetime. The table will eventually expand to include a timestamp column, so I am not interested in getting that to work at this time. If I use MySQL monitor, I can use th