Re: Multiple Master/Slave Set Up for Failover and HA {Was Re: forwarded message from Van}

Van wrote: Simple question: Where do I put the my.cnf file? It's nowhere on any of the servers except the user directories who use it. Disregard above. I've been using mysqld to start the server since 1998. Hadn't looked into safe_mysqld since I've only noted that mechanism on RedHat and

query max(length(column)) HANGS or there is a BUG in Mysql 3.23.33

Hi, I'm a bit desperate and have some questions to ask. I'm working with my own compiled server 3.23.33 on SuSe 7.0 I have table: mysql desc test.http_refer; +---+--+--+-+-++ | Field | Type | Null | Key | Default | Extra

Re: Need some help on how to use mysql with web site

Kyzen Computers wrote: I was wondering if someone can help me, I am new to the list and was looking for some help on how I can use mysql with my website to keep track of who comes in and giving them logins I have just read mysql and don't know anything PHP or CGI but if some one tells me

Re: Help for mysql error

"J.C. Ting" wrote: I use Mysql for half year. At this moment, I encounter a big problem that I can not query any data from my server. The following is my configuration. Platform: Solaris 2.7 on Sun Ultra2 Mysql version: 3.22.29 Table Name: mailhead; mysql select * from mailhead where

Fire Your Magician

This one's great: /usr/local/libexec/mysqld: ready for connections 010319 1:51:41 Slave: connected to master 'pima@scottsdale:3306', replication started in log 'FIRST' at position 4 010319 1:51:41 Error reading packet from server: Binlog has bad magic number, fire your magician (read_errno

Re: [imp] version conflict : resolved

The conflict was due to the version reason only. I installed the correct version of those rpms and evrything is working fine. This is something new and exciting for me. The conflict was due to the incorrect and mismathced version of mysql.sock file which was being used to connect with the

Re: Fire Your Magician

Van wrote: This one's great: /usr/local/libexec/mysqld: ready for connections 010319 1:51:41 Slave: connected to master 'pima@scottsdale:3306', replication started in log 'FIRST' at position 4 010319 1:51:41 Error reading packet from server: Binlog has bad magic number, fire your

Re: Where are warnings located?

According to mysql manual: ... The warnings are not stored anywhere; the number of warnings can only be used as an indication if everything went well. If you get warnings and want to know exactly why you got them, one way to do this is to use SELECT ... INTO OUTFILE into another file and

Re: query max(length(column)) HANGS or there is a BUG in Mysql 3.23.33

More interesting rezults, after runnig some check/repair/analyze commands in sequence on the same table: mysql repair table http_refer extended; +-++--+--+ | Table | Op | Msg_type | Msg_text |

How to load a database in memory

Hi all, I use Mysql to store session's information. My problematic is to be very performant... So, I'm thinking about solutions to make the accesses faster. I would like to try to cache my database ("load it in memory"). I found some interesting information in the documentation : - HEAP

ASP == MySQL

Hello, I wondered if MySQL is capable of being accesed by an ASP script? tnx!

Re: Tuple length Question

Hello Jason: Thanks for your input. I did think of this possibility; those hash tables MySQL has available are certainly going to speed things up (if you have the memory). My mutlilanguage system could encorporate your idea; I will give you a run down of how it works. First you keep separate

Privilege system of Mysql...

Hi there.. I am not understanding something how the mysql priviege system works: I want to do the following: Give a user access to all tables in an database (also tables which will be added in the future) except a few private tables like the mysql table itself This is the way I thought it

Re: Technical Clarification

Hi, On Mon, Mar 19, 2001 at 01:23:56AM -0600, Jason Landry wrote: I know that this response was directly related to a question about subqueries, but I think it's important to point this out, because I almost didn't pursue this avenue as a result. As Fred pointed out, MySQL does not support

sql command - copy of one row

Hi! I have a problem. I would like copy one row from table1 to another table2. How could I do? I tried something like this: insert into table2 values (select * from table1 where username = '$uname') both (table1 and table2) have the same structure. Every time when I try do this sql command i

Re: sql command - copy of one row

On Mon, Mar 19, 2001 at 12:22:09PM +0100, - = k o l i s k o = - wrote: Hi! I have a problem. I would like copy one row from table1 to another table2. How could I do? I tried something like this: insert into table2 values (select * from table1 where username = '$uname') both (table1

Re: sql command - copy of one row

Hi! On Mon, Mar 19, 2001 at 12:22:09PM +0100, - = k o l i s k o = - wrote: Hi! I have a problem. I would like copy one row from table1 to another table2. How could I do? I tried something like this: insert into table2 values (select * from table1 where username = '$uname')

MySQLGUI

Hello, I'm testing MYSQL client with MSWIN2K adv. server and I wonder how the edit table function works.

Re: sql command - copy of one row

Hi! i try one little question. when the table2 have one more row then table1.. is possible try something like this: insert into table2 ($date, select * from table1 where username = '$uname') where $date - system time and date generated from php. If you understand.. table2 is backup of table1

RE: [RE: What is CONSTRAINTS for?]

In mySQL, it does nothing. Constraints are not implemented. The syntax is there for compatibility with other dialects of SQL. You are almost correct, if constraints were implemented then it would be: CONSTRAINT fk_authorsofdoc FOREIGN KEY(authorid) (I think, I don't often write them by

RE: INNOBASE

Heikki, When you write your documentation, please include more info on my.cnf settings. What I would like to see are some settings documented for different machines (i.e. machines with 64M, 128M, etc. of memory and also disk space numbers and how they relate.) Thanks, Rick -Original

RE: I wanted to clear my doubt.

If you mean, can you use MySQL when programming Microsoft ASP pages then, yes. You need to download and install the MySQL ODBC drivers first then you can setup your DSN. Cal http://www.calevans.com -Original Message- From: Gaurav Rishiraj Ahuja [mailto:[EMAIL PROTECTED]] Sent: Sunday,

Re: very strange but reproducable error in 3.23.35

Hi! I tested your test case and you are right ! Thank you for a reproducible test case. We will fix it shortly. Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*|

Maybe its an Odbc error

However, its just strange, Using the Myslq-front , front end I can sucessfully execute a load data from infile this is actual command LOAD DATA LOCAL INFILE 'D:/cmremote/mysqldata/PROJ.csv' INTO TABLE cmremote.CURRENT FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY

Oracel = Mysql dump

Hi I have a task to import a oracel database into our mySql database. Is there an easy way to do this? please i need help !! /*Niklas Adlerberth*/ // +46 8 736 5848 (o)- -(o) !--BAF-tek.grp-- (/ )_ _( \) -

Re: strange ws_concat,concat result

"Nystrm, Rasmus" writes: How come the query SELECT CONCAT('"',CONCAT_WS('";"',title,prio,category,program,bugdesc,created,modif ied,bugstatus,submitter), '"') FROM tbl_bug; returns something like "4","4","4" "10","10","10" while only SELECT

Re: Privilege system of Mysql...

David Bouw writes: Hi there.. I am not understanding something how the mysql priviege system works: I want to do the following: Give a user access to all tables in an database (also tables which will be added in the future) except a few private tables like the mysql table

Re: MySQLGUI

Roy Wasse writes: Hello, I'm testing MYSQL client with MSWIN2K adv. server and I wonder how the edit table function works. It is in the works ;o) Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic

Re: sql command - copy of one row

super! it work fine. Thank You! S pozdravem, Michal Kolesar +420 608 225025 [EMAIL PROTECTED] http://www.egarden.cz server of free unix services - Original Message - From: "Peter Pentchev" [EMAIL PROTECTED] To: "- = k o l i s k o = -" [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent:

ARCHIVING UNDER HEAVY LOAD

Hello! There's a need to design a system (something like online forum) that will be storing huge amount of small messages in database. There must be fast access only to messages for the last 3 days (guess this means that main table with indexes on it must be kept small?), while other messages

phpmyadmin + mysql + Unknown database 'test'

Hi! I have installed many of mysql servers and phpMyAdmin clients. And every time it worked together fine. Now i have problem on RH70 with mysql and phpMyAdmin: Database pokus Error SQL-query: Content-Type: application/octet-stream MySQL said: Unknown database ' pokus' Back

Problem with MySQL ASP

Hi I am running the latest versions of MySQL and MyODBC on my windows 200 webserver. I am trying to connect to my database and pull out some simple data with asp. The code i am using is: % dim db dim strConn dim rs dim QueryStr QueryStr = "SELECT * FROM imagedata" strConn = "mediaSafe"

Re: error with mysql configuration.

Make sure all directories in the path to your mysql.sock file are world readable and searchable. Abid Ghufran wrote: Dear All, I am trying to setup a web based email setup on RedHat Linux 7 platform. I am using Horde 2.2, Imp 1.2, Php 4, Apache 1.3 alongwith the following rpms required

Will MySQL_Linux_Apache handle Yahoo level traffic data?

I'm a newbie to the Linux-Apache+MySQL world. 1 - Will MySQL handle a data base as large as a Yahoo or Google or E-Bay ? 2 - Will MySQL running on a Linux/Apache system handle traffic that approaches that of a Yahoo, Google or E-Bay? 3 - Does MySQL have an equilivant to "stored proceedures?

RE: Will MySQL_Linux_Apache handle Yahoo level traffic data?

Welcome! 1: You'll have to be more specific than that. How many tables/records per table are you looking to store? Are you wanting to optimize it for querying or is it going to be an active database with heavy inserting/updating? 2: That depends on the hardware you run it on. Technically, yes,

Re: Add password to a existing database/table

Read chapter 6 of the MySQL manual. It is explained there. Nyon wrote: Hi, I am a newbie in Mysql and is confused about setting login/passwords. Just want a simple security measure as I am the only user. Here's the scenario: I managed to connect using PHP to mysql via the

RE: Problem with MySQL ASP

Hi Craig, You can give the following a try which does give you direct access to MySQL from ASP skipping the slower ODBC and is almost code compatible with your code: http://www.scibit.com/MySQLX or MyVBQL on the mysql API/contrib pages Regards Jacques http://www.scibit.com

Again: module shr.o

Hallo MySQLers I have posted this problem already, but i have still problems installing MySQL Version 3.23.33 on RS/6000 AIX4.3.3 Description: exec(): 0509-036 Cannot load program ../bin/mysqld because of the following errors: 0509-150 Dependent module

Re: C API problem

You clibs are too old. You are probably running a very old version of Linux. john1 wrote: Dear Sir : MySQL 3.22.32 on my linux 486 PC seems work so good. When I compile a simple C API program which catched from MySQL tutorial, it chokes at the end of compile process . The program is as

RE: strange ws_concat,concat result

"Nystrm, Rasmus" writes: I tried it now. Not on the 2000 Server, but on my NT4 SP6 The problem still occures, let's me describe the tests. The table looks like this: id| int(10) unsigned | | PRI | NULL| auto_increment title | varchar(255) | YES |

Re: for configure

Install your curses from your installation CD. Ali Muhhanmad wrote: Dear Mysql: when i execute the configure , it always display: checking for tgetent in -lncurses... no checking for tgetent in -lcurses... no checking for tgetent in -ltermcap... no checking for termcap functions

Re: very strange but reproducable error in 3.23.35

This does not answer your problem, but 'timestamp' is a reserved word. Jan Legenhausen wrote: Hi, i just upgraded from 3.23.33 to 3.23.35 and found that a little script of mine which simply modifys a table went mad completly. I figured out a testcase which shows at least one of the

Question/problem with MySQL 3.23 on Win98 and using MySQL-Maker

Hello, I am using MySQL for the first time and have it installed on a Windows98 machine. I also am running MySQL Maker by presult and a couple of other GUIs. Unfortunatley, it seems like any time I make a table that has fields which aren't varchar or integer, I can not insert any information

Traffic accounting

Hi! I want provide access to my MySQL Server to several customers. How can I count IO traffic per user, and any user accesses (I don't want a full log, only log ins)? Thanks -- Dipl.-Ing. Gernot Hueber Institut fr Integrierte Schaltungen Freistdter Strasse 315/2 A-4040 Linz Tel: +43 732

Re: ROWNUM???

I have no problem doing this with server variables ... here is an example that I tried on the acc (account) table in our db ... SET @a:=0; SELECT @a:=@a+1 AS MyRowNum, acc.* FROM acc; This gives me the result that you are looking for ... Eric Peter Holm wrote: Hi, how do I get something

log-update bug

Hi, Can you guys confirm that "create database" statements are not logged in the log-update log? The version I am using is 3.22.32. Regards, Jerry. - Before posting, please check: http://www.mysql.com/manual.php (the

Fw: [BQ75]

ACABEI DE RECEBER. NO TEMOS NADA A PEDER. Prezados e queridos amigos, Leiam esta carta e ajam rapidamente. Estou enviando esta carta para vocs porque recebi informao por parte de um profissional e amigo. A MICROSOFT e a AOL (America On Line), atualmente as duas maiores empresas da Internet,

3.23.35 failed to upgrade

Hi, I am trying to upgrade my MySQL server to 3.23.35 from 3.23.33. The following command is used. I got the following error messages. Any Ideas !! rpm -Fvh MySQL-client-3.23.35-1.i386.rpm MySQL-devel-3.23.35-1.i386.rpm MySQL-client-3.23.35-1.i386.rpm MySQL-client

replication or log-update

FYI Just noticed that statements like "LOAD DATA LOCAL INFILE 'testload.data' INTO TABLE testload ;" won't work via replication(3.23.33) or log-update(3.22.32) unless the data files are copied to remote slave servers in advance. Better implementation? Workarounds? Regards, Jerry.

Order by using alias?

Hello everyone, It seems as though I am unable to perform an order by with a DATETIME field when the column is named as an alias. For example... SELECT DATE_FORMAT(service_date,'%m-%d-%Y') AS 'Serv. Date' FROM documents ORDER by 'Serv. Date' DESC LIMIT 0,10; Can anyone give me an explanation?

Re: Query optimization

Hello On Sat, 17 Mar 2001, Brd Farstad wrote: I have a query in my program which is taking to long when I get data in the database. I'm currently testing with ~40.000 articles in the system. [...] Is it possible to optimize this query further? Have you played with EXPLAIN SELECT and

to MySQL serwer

Hello, Sorry, Im don't very good speak english. :( I have connet to server MySQL from delphi 5 please send mi driver(s) for delphi, or please tell mi how connect. Fantik [EMAIL PROTECTED] - Before posting, please check:

Re: Order by using alias?

Periods are not allowed in field names. Dave Juntgen wrote: Hello everyone, It seems as though I am unable to perform an order by with a DATETIME field when the column is named as an alias. For example... SELECT DATE_FORMAT(service_date,'%m-%d-%Y') AS 'Serv. Date' FROM documents ORDER

multiple charsets per server?

I need to do some tests for a client involving japanese text. I've recompiled the server with extra charsets = complex to have multi-byte support. I see how I can select the default charset upon startup. How can I tell mysql that a particular set of tables (or the whole DB) should use the

Do outer joins not work in MySQL?

Hi all, I'm new to MySQL and am puzzled by a curious problem. This join syntax has always worked fine for me on SQLServer but it seems to work like an inner join on MySQL: SELECT d.doccat_ID, d.doccatname FROM doccats d LEFT OUTER JOIN doccat_group dg ON d.doccat_ID = dg.doccat_ID WHERE

Got an error reading communication packets

after upgrading to 3.23.35 (from 3.22.32) i've got several times: 010319 20:45:18 Aborted connection 4 to db: 'unconnected' user: 'admin' host: `localhost' (Got an error reading communication packets) it's running on a productive server, but it's not working correctly. some infos: apache

column types

Hello, Just starting out with MySQL. I like to put images or links to images in a database, Is this possible? If so what would be the column type be? Thanks for the help Mike

Selecting random rows with MySQL 3.22?

Hi, I'm sure this has been covered before, so I'm sorry for repeating the question. A search of the list archives yielded nothing. What I need to do is grab one random row from a table. What I would do in MySQL 3.23 is: SELECT * FROM fid_links WHERE featured='yes' ORDER BY RAND() LIMIT 1 How

RE: column types

Hi. If you want to store the binary images in the database, the column type will most likely be a BLOB assuming the images are not bigger that 60k. If you want to store just url or file paths (http://www.myhost.com/pict.jpg or /home/bob/image.gif) use a VARCHAR(XX) where XX is a reasonable

RE: Selecting random rows with MySQL 3.22?

Hi. for mysql 3.23 you can do something like this. select ID, ID*0+rand() as rand from partner order by rand limit 1 have fun. -ravi. -Original Message- From: Chris Boot [mailto:[EMAIL PROTECTED]] Sent: Monday, March 19, 2001 3:16 PM To: MySQL Mailing List Subject: Selecting random

RE: Selecting random rows with MySQL 3.22?

It has been. Check the archives for 2-3 weeks ago. Cal http://www.calevans.com -Original Message- From: Chris Boot [mailto:[EMAIL PROTECTED]] Sent: Monday, March 19, 2001 2:16 PM To: MySQL Mailing List Subject: Selecting random rows with MySQL 3.22? Hi, I'm sure this has been

Re: Selecting random rows with MySQL 3.22?

Hi, for mysql 3.23 you can do something like this. select ID, ID*0+rand() as rand from partner order by rand limit 1 Thanks a million for the speedy response! It works like a charm! I don't quite understand how it works though... Could anyone explain? I really don't like knowing

mysql error

I have suse linux 7.1, I installed mysql and php, I tyr to connect to the database and I get a socket error why? is there any kind of special confg? I type mysql on a terminal window and get the error msg, cheers -

moving database between servers

I've created the databases on the new server, but when I do: mysqldump --quick --add-drop-table --add-locks --extended-insert --lock-tables TestDatabase | mysql -h newserver TestDatabase I get the error message: ERROR 1063 at line 30: Incorrect column specifier for column 'ID' The originating

RE: Selecting random rows with MySQL 3.22?

You're selecting your index column [ID] for every record and generating a column containing a random number [ID*0+RAND()], ordering by the random column [ORDER BY rand], and then just grabbing the first record [LIMIT 1]. the RAND() function generates random numbers. In my version of mysql (most

HASH tables...

Hello, I would like to ask those of you who have used temporary hash tables in MySQL version 2.23.x if you have encountered any problems, concurs or known issues. I have been testing it myself and everything sees to working just fine. Please list your thoughts and comments on temporary hash

New Versions

Can you put any warning that you plan to release new version few days before release ? I have downloaded 3.23.34, and when i visited mySQL.com on the next day, 3.23.35 was released. -- Martin Jeremic - JSoft http://jsoft.webjump.com/ mailto:[EMAIL PROTECTED]

Re: Order by using alias?

Yes, you are right, periods are not allowed, but I am still not getting a successfully ORDER BY on the field. I tried remove the DATE_FORMAT() function and everything worked fine. Am'I not allowed to alias function returns? - Original Message - From: "Gerald L. Clark" [EMAIL PROTECTED]

Re: HASH tables...

Am 22:21 19.03.2001 schrieb Dave Juntgen: *This message was transferred with a trial version of CommuniGate(tm) Pro* Hello, I would like to ask those of you who have used temporary hash tables in MySQL version 2.23.x if you have encountered any problems, concurs or known issues. I have been

AW: suggestions for implementing heavily used log tables with nightly delete

I basically have a situation where 300,000+ rows are being inserted into a log table daily, and also needing to be cleared out based on a tstamp. What I've found is that the inserts work fantastic, but when I got to do the delete, even if it doesn't do anything, it sits there and blocks

Re: suggestions for implementing heavily used log tables with nightly delete

On Mon, Mar 19, 2001 at 02:40:58PM -0600, Neulinger, Nathan R. wrote: Got any suggestions on how these could be implemented? particular table types/setups/etc? I basically have a situation where 300,000+ rows are being inserted into a log table daily, and also needing to be cleared out

RE: suggestions for implementing heavily used log tables with nightly delete

Ok. The second one below sounds semi reasonable - it does mean that the table will be somewhat useless for queries during the delete, but that's not tragic. Is there any way to drop all the indexes on a table with a single statement? Third one sounds good as well, but unfortunately, there is a

Re: Will MySQL_Linux_Apache handle Yahoo level traffic data?

On Mon, Mar 19, 2001 at 06:05:47AM -0800, tmb wrote: I'm a newbie to the Linux-Apache+MySQL world. 1 - Will MySQL handle a data base as large as a Yahoo or Google or E-Bay ? Done properly, yes. 2 - Will MySQL running on a Linux/Apache system handle traffic that approaches that of a

Build Search Query - STUMPED!! - REFERRAL.SQL (1/1)

# # Table structure for table 'bus_info' # CREATE TABLE bus_info ( info_id int(11) unsigned DEFAULT '' NOT NULL auto_increment, bus_name varchar(100) DEFAULT '' NOT NULL , contact_fname varchar(20) DEFAULT '' NOT NULL , contact_lname varchar(20) DEFAULT '' NOT NULL , refer_by int(8))

Build Search Query - STUMPED!! - REFERRAL.SQL (0/1)

Hello All, MySQL version 3.23.33 I was hoping someone maybe able to offer some suggestion on a search query I've been working for a day or so, but seems to be getting no where fast! I've attached the tables and test inserts I'm working with. This is for a business referral search where people

problems with linking

Dear MySQL Sirs, I have been trying to run a simple client program using the C API and unfortunatelly I am still getting the same error over and over again: ./client1: error in loading shared libraries: libmysqlclient.so.10: cannot open shared object file: No such file or directory Attached is

Build Search Query - STUMPED!!

Hello All, MySQL version 3.23.33 I was hoping someone maybe able to offer some suggestion on a search query I've been working for a day or so, but seems to be getting no where fast! I've attached the tables and test inserts I'm working with. This is for a business referral search where people

Re: problems with linking

make sure you have -L/usr/local/mysql/lib/mysql/ in your compile and make sure that /usr/local/mysql/lib/mysql/ is in your shared object cache. ldconfig -r will list your current cache entries. if /usr/local/mysql/lib/mysql/libmysqlclient.so.10 is not in there then add the path:

Re: Looking only for uniqueness

Hello JCampell, Friday, December 22, 2000, 11:25:51 AM, you wrote: RTFM about SELECT and about DISTINCT option J I want to know if it is possible to build a MySQL query which will only J return the unique values of a specific column. Ie if I had this table: J id | name |date___ J 1 | Jon

Re: Looking only for uniqueness

"Alexey V. Litvinov" wrote: Hello JCampell, Friday, December 22, 2000, 11:25:51 AM, you wrote: RTFM about SELECT and about DISTINCT option J I want to know if it is possible to build a MySQL query which will only J return the unique values of a specific column. Ie if I had this

Re: Problem with Mysql

Hello all. I was wondering if someone could help me out with simple question i have . I just download MySQL-3.23.33-1.i386.rpm and installed it. now would this be the right way of setting up the msyql root password #mysqladmin -u root -p password 'newpassword' or #mysqladmin -u

Serious LEFT JOIN bug in 3.23

EXPLAIN LEFT JOIN fails when joining on an empty table with constant in WHERE clause CREATE TABLE idx ( id mediumint, KEY id (id), ) TYPE=MyISAM CREATE TABLE hist ( id mediumint, link mediumint, KEY id (id,link) ) TYPE=MyISAM Table idx is populated with thousands or records. Consider

Re: Serious LEFT JOIN bug in 3.23

hist.id will never be NULL and 5 at the same time. Your clauses conflict with each other. You need to re-write your query. "Michael Griffith" [EMAIL PROTECTED] wrote: EXPLAIN LEFT JOIN fails when joining on an empty table with constant in WHERE clause CREATE TABLE idx ( id mediumint,

members list categories inserting db into webpage

I've got mysql and php installed on my server and i was wondering if anyone could give me some feedback/pointers on setting up a membership list for a local chamber of commerce. I've been able to set up the initial table (calling chamber.txt for the info, converted from a word.doc) but i need to

RE: Split results

You can use the 'limit' construct on the end of the select statement. So for first query do select blah from blah where blah limit 20; each succeeding query will be select blah from blah where blah limit 20,20; check the doco for explanation. You can do a count to start with to determine

Re: Split results

On Mon, 19 Mar 2001, Andres M.V. Paglayan wrote: Hi you all, I´m trying to resolve how to manage a large resultset (about 500), showing only 20 rows per page and then to have the option to show more results from several buttons, like when you search something with a lot of pages in the

substring

Hi I need some help with substring. How can I extract last four digit of a field say card_no (this field has in some instance 10 digits and for some value has 20 digits). Thanks

Re: substring

I believe there is a function called Right(). Sample is as follows (pardon the VB): DIM sString, sLast4Characters sString = "Hello There" sLast4Characters = Right(sString, 4) So, sLast4Characters now equals "here". Hope this helps! --- Hammad Nasim [EMAIL PROTECTED] wrote: Hi I need

Re: Got an error reading communication packets

Steven Glogger wrote: after upgrading to 3.23.35 (from 3.22.32) i've got several times: 010319 20:45:18 Aborted connection 4 to db: 'unconnected' user: 'admin' host: `localhost' (Got an error reading communication packets) it's running on a productive server, but it's not working

Resolved {Was Re: Fire Your Magician}

Van wrote: Van wrote: This one's great: /usr/local/libexec/mysqld: ready for connections 010319 1:51:41 Slave: connected to master 'pima@scottsdale:3306', replication started in log 'FIRST' at position 4 010319 1:51:41 Error reading packet from server: Binlog has bad magic

Re: Serious LEFT JOIN bug in 3.23

hist.id will never be NULL and 5 at the same time. Your clauses conflict with each other. You need to re-write your query. This is ture, except the query suceeds if there is records in 'hist' Even if it is not a bug it is at least inconsistent behaviour of MySQL "Michael Griffith"

Invalid authorization specification

hello all. I'm new to mysql and to this list. Here's my problem. I am using mysql and jsp. From a jsp page I try to connect to the mysql server I get error " Invalid authorization specification: Access denied for user : javaworks@localhost (using password: NO) at

[OT] SQL syntax qestion

Hi, Just a quick quesiton, I have a table that contains difined as create table picks( handle char(30) primary key, ... total int unsigned); there is a user table that has a list of handles and other user info. handle is the primary key. If I issue the command "select handle,

RE: [OT] SQL syntax qestion

Hi, Yes, in MySQL you can go select handle, sum(total) as t group by handle order by t; in ANSI (?) you can go select handle, sum(total) group by handle order by 2; 2 being the column number of the result. Regards Quentin -Original Message- From: Curtis Maurand [mailto:[EMAIL

Re: [OT] SQL syntax qestion

On Mon, 19 Mar 2001, Curtis Maurand wrote: Hi, Just a quick quesiton, I have a table that contains difined as create table picks( handle char(30) primary key, ... total int unsigned); there is a user table that has a list of handles and other user info. handle is the

Re: Traffic accounting

On Mon, Mar 19, 2001 at 05:06:28PM +0100, Gernot Hueber wrote: I want provide access to my MySQL Server to several customers. How can I count IO traffic per user, and any user accesses (I don't want a full log, only log ins)? There's not built in facility for doing that today. Are all the

Re: Alteon + forks

On Mon, Mar 19, 2001 at 04:13:25PM -, Pedro wrote: I have 2 servers and 1 alteon in HA. But the problem is that the alteon , when trying, to see if the servers are up or down , makes mysql to fork , till it dies.. I'm not sure I understand... Probably because I don't know what an aleton

Re: mysql on redhat 7.0

dear sanjeev run on cmmd promt /etc/rc.d/init.d/mysqld restart you can now run mysql luck naveed - Original Message - From: Sanjeev Adhyapak [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, March 17, 2001 11:20 PM Subject: mysql on redhat 7.0 Dear Sir, We have installed

Re: to MySQL serwer

Hello Fantik, Monday, March 19, 2001, 9:43:20 PM, you wrote: F I have connet to server MySQL from delphi 5 F please send mi driver(s) for delphi, or please tell mi how connect. Try our mySQLDAC: http://www.microolap.com/mysqldac.htm -- Best regards, Edward Smirnov microOLAP Technologies LLC

Re: Problem with Mysql

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Sun, 19 May 2002, Luis wrote: #mysqladmin -u root -p password 'newpassword' or #mysqladmin -u root password 'newpassword' i got a error. but when i tried the 2 one it work. But in the manual it says to do the top one I'm

  1   2   >