RE: Limits and order bys

For the best I know, it is not possible to do your task with single sql with MySQL. I have done similar task before but I need to put them into temp table and sort or create an index on the temp table. As you can create temp table in memory (server), speed is really not a problem. You may find

Re: InterBase vs. Mysql

Firstly excuse my poor english ;))) I read the entire mail thread. I'm useing MySQL for our own data storage (I use it to store our oceanographic data for internal use) - I guess that I don't need a commercial license for this. I have another question ... if I will do a commercial program in futu

RE: Limits and order bys

I was hoping to do it in sql, since it would be faster. Any other ideas? --- Rob ** Rob Cherry mailto:[EMAIL PROTECTED] +27 21 447 7440 Jam Warehouse RSA Smart Business Innovation http://www.jamwarehouse.com ** -Original Message- From: ge

Re: Problem reloading data...

Interesting update on this... I went to the production server (Solaris 2.8 on E250) and tarred the data directory for this database. Then I FTPed it over to the test server (Solaris 2.8 on Sparc 20), deleted the files in the same data directory and untarred the files from the production server.

RE: Problem with replication and corrupting tables

Below is a trace (--debug=d,enter,exit,info,error,query,general,where: O,/tmp/mysqld.trace) of the slave thread. This is the best I can do as far as a bug report. No other queries were running and the slave I/O thread was idle (I firewalled its connection to the master/rest of the world). Without

Re: How to create a schema

Maybe If I get you in the right way, the answer for your second question is (B (Byou can use SQLYog or similar tools and can use them as a front end. (Bhttp://www.webyog.com/ (B (B (Bregards (BKS (B (B- Original Message - (BFrom: "Ayyaparaju Ganapathiraju" <[EMAIL PROTECTED]> (BT

Re: problem in connecting to DB

Yes, it is one of the security feature of MySQL that cause problem. Instead of using IP address, MySQL always perform a reverse DNS lookup and use host name instead. One of my past painful experience is I add a user with host for 192.168.0.33. However, no matter how hard I tried, I can't connec

Archive on remote Machine .

I use Select * into outfile "filepath" from table to archive the database. Is there any way to archive this into a different machine. (Not current machine). Also Note the target machibe does not have MySQL installed. Yes Mapping to new machine and then giving path is an option. Any other op

Re: problem in connecting to DB

one more thing i would like to ask u gurus when i have given my host with an IP address... why is it giving the message " username@localhost " wherein it should give me as " username@IPaddress " Thanks Ganesh Rajan - Original Message - From: "Ganesh Rajan" <[EMAIL PROTECTED]> To: "Dian

Re: InterBase vs. Mysql

On Tue, Feb 18, 2003 at 05:06:17PM +, Ben Clewett wrote: > This will be my last posting. I don't belive I am being constructive > and have no wish to instantly be hated by the whole of MySQL. Probably wasn't wise to make a post about how you felt MySQL was expensive (huh?) and their staff ru

SuSE DBD::mysql

iH trying to get v7.3 of SuSE/PPC working with mysql and perl. i have the mysql server working and perl reports that the mysql driver is available but when trying to connect to the a database i get error while loading shared libraries: /usr/lib/perl5/site_perl/5.6.1/ppc-linux/auto/DBD/mysql/my

Re: problem in connecting to DB

Thanks for the response but as the document states to "RUN mysqladmin flush-privileges and mysqladmin reload" i tried bothways... but in vain ... i still get the same error message "Error 1045: Access Denied for user:(username@localhost) (user password :YES)" Ganesh Rajan - Original M

Re: License question

First of all, I am not mysql person and I would like to share my personal understanding only. If your program is under GNU's GPL (ie. free open source software) you can use MySQL right away. There is no need to buy license. Otherwise, you may ask whether MySQL is an option or not. It means that

Re: Archive on remote Machine.

You may try the following command mysqldump -u -p samp_db | mysql -h samp_db -u -p Please also note that samp_db must be exist on your remote machine. Of course, you should sub. samp_db with your to be achieve database name. Regards, > Hi, > I use Select * into outfile "filepath" from

Re: cygwin strangeness

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Amy & Joseph Kormann wrote: Mark, thanks for your reply. My commends inline below. Mark Matthews wrote: [snip] Is there a reason the native Win32 binaries we ship won't work for you? The binaries (mysql, mysqlc and mysqld) appear to work perfect

Re: GROUP BY is too greedy

At 18:32 -0800 2/18/03, Jon Drukman wrote: this query: select ep.product, s.id,s.type,s.headline,date_format(post_date,'%a, %m/%d/%y - %h:%m %p') date,user_level,s.ext_url from story s left join e_prod ep on ep.story=s.id where s.post_date > date_sub(now(), interval 14 day) and s.status = 9 or

GROUP BY is too greedy

this query: select ep.product, s.id,s.type,s.headline,date_format(post_date,'%a, %m/%d/%y - %h:%m %p') date,user_level,s.ext_url from story s left join e_prod ep on ep.story=s.id where s.post_date > date_sub(now(), interval 14 day) and s.status = 9 order by post_date desc limit 10 returns the

incomplete rpm install

>Description: After running the RPM installs the user/group mysql/mysql is not created and neither is /var/lib/mysql directory. So when I attempt to start mysql daemon this happens : [root@dino masiak]# /sbin/service mysql start [root@dino masiak]# touch: creating `/var/lib/mysql/dino.er

How to create a schema

Hi, I have two questions here, please. 1). Is there an equivalent to creating a schema in MySQL. I would like to create tables in multiple schemas within the same database. Some of the tables will have foregign keys across schemas. I'm aware that I can create multiple databases and switch betw

Re: cygwin strangeness

Mark, thanks for your reply. My commends inline below. Mark Matthews wrote: Amy & Joseph Kormann wrote: Feels strange being the only one replying to myself, but I'm hoping that someone will come up with a suggestion if I keep posting what I'm doing. I've downloaded the version of cygwin tha

Re: C API Changes?

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Amy & Joseph Kormann wrote: Stephen Brownlow wrote: "ggelu" <[EMAIL PROTECTED]> wrote: --- Amy & Joseph Kormann <[EMAIL PROTECTED]> wrote: Are there any (significant) changes in the C API between MySQL 3.X and 4.X? If so, where are they locat

Re: cygwin strangeness

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Amy & Joseph Kormann wrote: Feels strange being the only one replying to myself, but I'm hoping that someone will come up with a suggestion if I keep posting what I'm doing. I've downloaded the version of cygwin that is suggested on the mysql downl

Re: Limit the database size

Thank you very much for your information. I have encountered another problem if I use this approach. The problem is I can change the database directory to another group which has quota. However, whatever mysql create new table, it will use its configrated group (namely 'mysql' in Redhat default

Re: cygwin strangeness

Feels strange being the only one replying to myself, but I'm hoping that someone will come up with a suggestion if I keep posting what I'm doing. I've downloaded the version of cygwin that is suggested on the mysql download page. I re-compiled my programs using the cygwin version and the one st

Problem reloading data...

I am having a strange problem reloading data into one copy of MySQL. Details: production server: MySQL - Ver 8.38 Distrib 4.0.5a-beta, for sun-solaris2.8 on sparc development system: MySQL - Ver 8.38 Distrib 4.0.5a-beta, for Win95/Win98 on i32 test system: MySQL - Ver 8.38 Distrib 4.0.5a-beta,

Re: C API Changes?

Stephen Brownlow wrote: "ggelu" <[EMAIL PROTECTED]> wrote: --- Amy & Joseph Kormann <[EMAIL PROTECTED]> wrote: Are there any (significant) changes in the C API between MySQL 3.X and 4.X? If so, where are they located. Yes. Are some changes between ver 3.x and 4.x.If i understand we

Re: Creating Tab Delimited Textfile to Load Data Into MySQL Table

Thanks to Gerald and Stefan for taking the time. Here's where I am ... Perhaps because I'm still wet behind the ears, I brainlessly included the column heads in the textfile. Of course, that's unnecessary. I substituted \N for NULL and stuck \n at the end of each line--the latter because I'm no

Re: InterBase vs. Mysql

On Tue 2003-02-18 at 17:06:17 +, [EMAIL PROTECTED] wrote: > This will be my last posting. I don't belive I am being constructive > and have no wish to instantly be hated by the whole of MySQL. [...] Oh, I do not have anything at all against you. I just tried to correct what I saw as a miscon

Re: Quick License Question...

Hi. First, I am not a lawyer. On Tue 2003-02-18 at 15:48:00 -0500, [EMAIL PROTECTED] wrote: > Quick question about the license issue that I thought of while reading > through the Interbase Vs. MySQL threads. > If I develop a program that uses MySQL for my company and it is only used > for interna

Re: The Solaris 2.7 version of the binaries

Thanks for the reply, if I can get the compile to work on my Solaris 2.7 I am more than happy for you to send me the make options you want used and I will send you the binaries once compiled. Now back to my problem, I am using gcc 2.95.3 which could be a problem as the compile process stops at

Re: Creating Tab Delimited Textfile to Load Data Into MySQL Table

Stephen, > The entries in a row are > separated by a single tab; at the end of a row, I'm hitting . I > entered twelve rows of data. The book I'm working from shows "NULL" as > some entries; and the last column, shows a timestamp in each cell of > that last column. I typed "NULL" every time my

Re[2]: Inserting '#' char as part of a field

Rob, > Are there any other characters with the same problem like #? http://www.mysql.com/doc/en/String_syntax.html Regards, -- Stefan Hinz <[EMAIL PROTECTED]> iConnect GmbH Heesestr. 6, 12169 Berlin (Germany) Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3 [filter

Re: C API Changes?

"ggelu" <[EMAIL PROTECTED]> wrote: > --- Amy & Joseph Kormann <[EMAIL PROTECTED]> wrote: > > Are there any (significant) changes in the C API between MySQL 3.X and > > 4.X? If so, where are they located. > > Yes. Are some changes between ver 3.x and 4.x.If i understand well i > think you try to f

Re: The Solaris 2.7 version of the binaries

- Original Message - From: "Nesh Nenad Mijailovic" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, February 18, 2003 5:23 PM Subject: The Solaris 2.7 version of the binaries > > Hi All, > > is there a reason why there are no MySQL binaries for Solaris 2.7 any more. > I have b

Re: problem building mysql as an embedded server

> Hi All, > > I am trying to run mysqld as an embedded server within > my application. I have read the manual which says to > run configure with --with-embedded-server option, but > I have not succeded in building libmysqld.a. It builds > all the remaining libs, but I don't find libmysqld.a > anyw

The Solaris 2.7 version of the binaries

Hi All, is there a reason why there are no MySQL binaries for Solaris 2.7 any more. I have been downloading the binaries before for Solaris 2.7 from the Web Site and now trying to compile the source doesn't work. Is it possible to put a link on the download page to a Solaris 2.7 binaries if y

Re: Different value from same function

Your INT in your table is a signed INT, which is going to have a maximum value of 2^31, thus your IP address is causing the field to "roll over." You need to change your IP column to UNSIGNED INT. That should solve your problem. j- k- On Tuesday 18 February 2003 12:33, Aaron Conaway

Feature Request: Return AUTO_INCREMENT on INSERT

How about this: mysql> CREATE TABLE tablename (value1 int(10) AUTO_INCREMENT, value2 timestamp(14), PRIMARY KEY (value1)); Query OK, 0 rows affected (0.00 sec) mysql> INSERT SQL_RETURN_INSERT_ID INTO tablename (value1, value2) VALUES (0, NOW()); +-+ | INSERT_ID() | +-+ |

Re: Limits and order bys

Sort them yourself after retrieving them. Rob wrote: I have a question regarding the use of LIMIT with ORDER BY. My problem is as follows: I want my users to be able to pageanate through result sets, so I've written some code that will display the results of a query 15 rows at a time in a HTML

Different value from same function

Weird problem here running 3.23.55-Max. I'm (still) trying to get my IP address DB working, but have run into a problem. When I use the inet_aton function during an insert, I get a very different value than if I use the function by itself on the CLI. Please see below. The IP address I am tr

Re: C API Changes?

--- Amy & Joseph Kormann <[EMAIL PROTECTED]> wrote: > Are there any (significant) changes in the C API between MySQL 3.X and > 4.X? If so, where are they located. Yes.Are some changes between ver 3.x and 4.x.If i understand well i think you try to find where this changes are declared/prototype

Re: Creating Tab Delimited Textfile to Load Data Into MySQL Table

Stephen Tiano wrote: I'm just starting out, doing tutorials and exercises up the wazoo, trying to learn MySQL and PHP. I've created a table in a test database. When I do a DESCRIBE [table_name], the columns come up just as they should. Populating them with data's another story. I've create

Quick License Question...

Quick question about the license issue that I thought of while reading through the Interbase Vs. MySQL threads. If I develop a program that uses MySQL for my company and it is only used for internal use, never repacked and sold/distributed outside the company what type of license aggrement is that

Creating Tab Delimited Textfile to Load Data Into MySQL Table

I'm just starting out, doing tutorials and exercises up the wazoo, trying to learn MySQL and PHP. I've created a table in a test database. When I do a DESCRIBE [table_name], the columns come up just as they should. Populating them with data's another story. I've created a textfile in a text ed

MySQL Connector/J 3.1.0 ALPHA Has Been Released

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, MySQL Connector/J 3.1.0 a new version of the Type-IV all-Java JDBC driver for MySQL has been released. It is now available in source and binary form from the Connector/J download pages at http://www.mysql.com/downloads/api-jdbc-dev.html and mirro

MySQL Connector/J 3.0.6 STABLE Has Been Released

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, MySQL Connector/J 3.0.6 a new version of the Type-IV all-Java JDBC driver for MySQL has been released. It is now available in source and binary form from the Connector/J download pages at http://www.mysql.com/downloads/api-jdbc-stable.html and m

Re: Various replication problems with 4.0.10-gamma

On Tuesday 18 February 2003 15:36, Harald Fuchs wrote: > In article <[EMAIL PROTECTED]>, > John Taylor <[EMAIL PROTECTED]> writes: > > > I get the error: > > ERROR 1227: Access denied. You need the REPLICATION SLAVE privilege for this >operation > > > I've tried setting the grants again, but it

% does not match the mysql host in mysql.user table

>Description: The % character in the Host field of the mysql.user table does not seem to match the host on which mysqld is running. >How-To-Repeat: GRANT USAGE ON *.* TO user@'%' mysql -u user -h machine.apple.com (from machine.apple.com) >Fix: GRANT USAGE ON *.* TO

Re: reserved or key words as database object names.

Excellent, Thanks a lot. It worked. - Original Message - From: "Dan Nelson" <[EMAIL PROTECTED]> To: "Ayyapraju Ganapathiraju" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Tuesday, February 18, 2003 1:37 PM Subject: Re: reserved or key words as database object names. > In the last ep

Printing out tables...tip

Since my original posting, asking how to: "print out tables in mysql" via out put to a printer. Thanks to all that responded, big thanks to Edward! Here is the tip for all Mac users, running 10.2.x and mysql. goto: http://localhost:631/ ( this program is built-in on 10.2 ) its called CUPS, goto

Re: reserved or key words as database object names.

In the last episode (Feb 18), Ayyapraju Ganapathiraju said: > I need to create a table named "Case", but MySQL is rejecting it, may > be because it is a reserved word. I understand that I can change the > name to something sensible. Is there still a way to create a table > with such names, for exam

reserved or key words as database object names.

Hi, I need to create a table named "Case", but MySQL is rejecting it, may be because it is a reserved word. I understand that I can change the name to something sensible. Is there still a way to create a table with such names, for example, by enclosing them in double quotes. I would like to use su

Re: AW: InterBase vs. Mysql

You can require GPL components without having to distribute them. That way you don't have to support them, either. Curtis Ben Clewett said: > Okay... > > BTW, I have cleared purchacing licences with my own people, and we do > not have a problem. Neither do I not like MySQL, I do. > > The lice

C API Changes?

Are there any (significant) changes in the C API between MySQL 3.X and 4.X? If so, where are they located. mail-filter: sql,query,queries,smallint -- Amy and Joseph Kormann - Before posting, please check: http://www.mysql.

Re: stuck with converting a query from a sub query

Hi, you may try: SELECT DISTINCT portlet.* FROM portletAssignment PortletAssignment, portlet LEFT JOIN UserTabAssignment UTA ON (portlet.name=UTA.portlet_fk AND UTA.user_fk = 'guest' AND UTA.portal_FK = 'mysqlPortal' AND UTA.tabNumber = 0 AND UTA.subtabName = 'firstSubtab'

License question

My company develops commercial project which is close to well know ICQ but has slightly different appliance. Can I use MYSQL for storing list of users, collecting some statistics, logs and other related information or I have to buy license? __ D

Re: InterBase vs. Mysql

Ben Clewett wrote: What you say is that the API is in my application. The API is part of MySQL. Therefore my application is GPL or needs a licence. Please don't confuse API and library. The libmysql or libmysqld libraries are GPL'd. Anything linked against them is automatically also GPL

AW: AW: InterBase vs. Mysql

Hi Ben, > > I feal I am digging my self a grave here, so this will be > about my last > ever posting... Either that or your mailing administrator will start > bouncing my mail I don't think so. You said nothing bad! Just talking about things which perhaps could be better or discuss that w

Re: InterBase vs. Mysql

On Tue 2003-02-18 at 16:11:11 +, [EMAIL PROTECTED] wrote: > Benjamin Pflugmann wrote: [...] > There is also some middle ground here. Which is the overlap of the two. No. Either the way you distribute your software is GPL-compliant or not. If it is not, you need a commercial license, if it is

Need some help accessing unsigned columns from Delphi

I'm trying to write a Delphi program that accesses a MySQL database via MyODBC. It's going pretty well except for a sticky problem I'm having with an unsigned integer column. I have a column named 'IP', type unsigned integer, that will hold IP addresses. However, Delphi seems to assume this colu

stuck with converting a query from a sub query

Hi I am having trouble to convert the following query with a sub query to use a join, any advice I would be most grateful Select Distinct portlet.* from portlet, portletAssignment PortletAssignment where PortletAssignment.Group_FK in ('group1', 'group2') AND portlet.name not in ( SELECT

Re: InterBase vs. Mysql

This will be my last posting. I don't belive I am being constructive and have no wish to instantly be hated by the whole of MySQL. Michael T. Babcock wrote: Ben Clewett wrote: MySQL say that this is an extension of the application, and therefore breaks the GPL, and therefore a licence is need

Re: Slow retrieval of distinct on indexed fields

I grant you that, however my point was about the total count of the indexed word's appearance, which would still stay the same, regardless of the encoding of the position information. Peter <^_^> - Peter Grigor Hoobly Free Classifieds http://www.hoobly.c

RE: Bug in ORDER BY

I'm glad you found the problem! Sorry my suggestion did not work. I'm still confused on why you have quotes around the field names in the order by part of the query, though. All the best! -steve- - Before posting, please chec

RE: Problem with replication and corrupting tables

An update. I'm now running the debug version on the slave. I could not trace out 'info' since it wrote way too much to the trace file. What I did find that was unique when the table crashed is this: handle_slave_sql: query: insert into forums_posts_new_3 ( w_search: error: Got errno: 0 from

Re: AW: InterBase vs. Mysql

Okay... BTW, I have cleared purchacing licences with my own people, and we do not have a problem. Neither do I not like MySQL, I do. The licence model you have supports a model similar to that of Oricle. Large, small quantity, expensive products. We are at the opposite end. Small low cost p

re[2]: InterBase vs. Mysql

Actually, I think you are not quite right in all respects. but feel free to correct me if I am wrong Somebody, or some entity still needs to hold the copyright of a product. How that entity chooses to sell or distribute that product is up to them. In this case MySQL AB is the copyright hold

Re: InterBase vs. Mysql

Ben Clewett wrote: MySQL say that this is an extension of the application, and therefore breaks the GPL, and therefore a licence is needed. They are however, the only big GPL user who thinks this way. No they're not. The issue is not the use of the server (as previously discussed a few w

Bug in UNION? Different results

>Description: if i use the following UNION statement, i do not get the same result as if i'm using the two selects separately or with a temporary table. i do not know if this is a bug, but i can not explain this behaviour. maybe someone can help me out... >How-To-Repeat: using the following quer

AW: InterBase vs. Mysql

Hi Ben, I'm not sure what you really want to sell. If you have to take a license from MySQL because of a commercial use, you just have to take ONE license. Correct me, if I'm wrong! If you want to sell your programs etc. which uses MySQL then see it in another way: Firstly MySQL isn't very expensi

Re: Question

I'd create a table with id, username, ,badgenumber, url. then have i.e. 1, Jerry, 007, /dir/images/jerry.jpg 2, Bob, 008, /dir/images/bob.jpg or something like that. The scripting to get that out and generate the html would be very easy. There are a few examples here that would cover what you

Re: Slow retrieval of distinct on indexed fields

In the last episode (Feb 18), Peter Grigor said: > I've always thought that adding a count of index entries to the index > file would be helpful. > > Like (generic index entry): word:15:1,2,5,7,etc... > > where word is the indexed value, 15 is the number of times it > appears, and 1,2,5,7 is the

Re: InterBase vs. Mysql

I'm not here to slag MySQL, but this point is extremely interesting. Benjamin Pflugmann wrote: > Aehem. There seems to be some misconception here. Either your program > is fine with MySQL being GPL or not. > > If it is (and your forking example would work for you) either by using > MySQL in a way

Re: Question

* McGraw, Robert--G3(Contractor-ANTEON Corp) > I am building a database (using MySQL) consisting of a list of > emplyees with > specific and unique information for each. I want to link an > employees badge > number with their photo. I have photos for all employees in JPG format. > How can I lin

Re: Slow retrieval of distinct on indexed fields [OT?]

Dan Nelson wrote: You need to walk the entire index to make sure you have all the values. There might be a single "AAB" inbetween those million "AAA"'s and million "BBB"'s. Another DBA and I once discussed that an index of index values would be helpful for such large searches as web search e

RE: received 0 length packet from server

Resetting the binlogs on the master didn't make a difference. Syncing all MySQL versions didn't make a difference. I've checked network configuration, permissions on both the replication user (on the master) and the files on slaves. The master error log has nothing in it. Is there a way to turn

Re: 'Disappearance of the mysql.sock when the computer is shut downand restarted'

Maybe you don't have your mysqld setup to start automatically when the system boots. Check the manual for help on setting up mysql daemon to start automatically after a boot: http://www.mysql.com/doc/en/Automatic_start.html On Tue, 2003-02-18 at 08:48, Fredrik Lundgren wrote: > Hello, > > I'm n

aes_encrypt/aes_decrypt returns null for valid input data

>Description: aes_encrypt/aes_decrypt works correctly for a test case. Change only the last two digits of the string needing to be encrypted and it returns null. I formed the queries below by cut and paste, so I was sure that the password was constant. The

RE: Question

Usually the best way to do this is to store the images in an accessible directory and then store the URL for the image in the database. It's a fairly simple exercise also to create an upload function that will associate the two for you automatically. Hope this helps, _M ]-Original Message

RE: Question

Why don't you link the badge number to the url of the photo? e.g. BadgeNumber PhotoURL 1 c:\MyPhoto\1.jpg 2 c:\MyPhoto\1.jpg etc ... Then you can get the URL and simply load the photo --- Rob ** Rob Cherry mailto:[EMAIL

Re: Slow retrieval of distinct on indexed fields

I've always thought that adding a count of index entries to the index file would be helpful. Like (generic index entry): word:15:1,2,5,7,etc... where word is the indexed value, 15 is the number of times it appears, and 1,2,5,7 is the record offsets (or byte offsets for dynamic stuff) of the appea

Access denied 3.23.55

Hi! Is it a bug? C:\mysql>mysql -u root Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 29 to server version: 3.23.55-max-nt mysql> create database R; Query OK, 1 row affected (0.06 sec) mysql> grant all privileges on `R%`.* to b; Query OK, 0 rows affected

Question

Sir/Ma'am, I am building a database (using MySQL) consisting of a list of emplyees with specific and unique information for each. I want to link an employees badge number with their photo. I have photos for all employees in JPG format. How can I link the badge number to a photo? Ideally, I woul

Re: Slow retrieval of distinct on indexed fields

In the last episode (Feb 18), Renars Jeromans said: > This is not an urgent problem, but it has always intrigued me... It's > simplified case, but it makes the point. Let us assume that we have a > table > > create table T (id unsigned int unique, name char(10)); > create index i_name on T(name);

Re: problem in connecting to DB

Everytime you use UPDATE, INSERT, DELETE to update user privileges you must do a FLUSH PRIVILEGES for changes to take effect. Check the manual: http://www.mysql.com/doc/en/Privilege_changes.html On Tue, 2003-02-18 at 11:57, Ganesh Rajan wrote: > hello all, > > i would like to put a problem as w

ANN: EMS MySQL DataPump 1.1 released!

EMS HiTech company is very glad to announce MySQL DataPump 1.1 -- the next version of our data conversion utility. You can download the latest version from http://www.ems-hitech.com/mysqlutils/download.phtml What's new in version 1.1? 1. The console version of MySQL DataPump is immediately avai

replication problems

Hi All I am trying to make a replication for my database. The master and the slave both in version 3.23.41 and i am working on windows 2000. I create user with FILE privilege and I flush all the tables and block write queries. Now I run the query SHOW MASTER STATUS and I get null in all the column

Various replication problems with 4.0.10-gamma

Hi, I'm having a bit of a nightmare getting replication working. Both slave and master are 4.0.10-gamma If I install fresh copies on two clean machines, and follow the instructions in manual.txt, everything works fine. The problem is that I need to do this in a production environment, so I c

Re: InterBase vs. Mysql

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi I am getting tired of this argument. This is the MySQL Users mail list, not a list to slagg of MySQL, its features or staff. Constructive comment is always welcome, but people on this list have chosen to use MySQL because of what it is and will

RE: Inserting '#' char as part of a field

Hi Are there any other characters with the same problem like #? Thanks -Original Message- From: Robby Tanner [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 18, 2003 1:16 AM To: Stefan Hinz Cc: [EMAIL PROTECTED] Subject: RE: Inserting '#' char as part of a field I solved the issue (e

Limits and order bys

I have a question regarding the use of LIMIT with ORDER BY. My problem is as follows: I want my users to be able to pageanate through result sets, so I've written some code that will display the results of a query 15 rows at a time in a HTML table. The next set of results can be accessed by press

Re: InterBase vs. Mysql

On Tue 2003-02-18 at 12:57:04 +, [EMAIL PROTECTED] wrote: [...] > Most benchmark published actually give credit to mysql when it comes to > Mysql Vs Interbase, but as an end user, the best tests are the one i > conduct myself in my premises. > Therefor when i say that mysql Vs interbase defin

Re: InterBase vs. Mysql

Benjamin Pflugmann wrote: So the speak about university degrees is pointless (aside from that, why do you think volunteers wouldn't have a degree...). Any volunteer who actually manages to improve MySQL in some way is good enough by my books; with or without the degree. A Comp. Sci. degree

re: Limit the database size

Thank you very much for your information. Can you tell me more how to limit size of directory in Linux? I can only set quota for users or groups but not for directory. Thank you very much. > On Tuesday 18 February 2003 04:26, KH Chiu wrote: > > > I am planning to offer a free service that allo

Re: rownum

geeta varu wrote: does mySQL have "rowid" or "rownum" if yes please give an exampl Please search the archives for "_rowid" to find the previous discussions on this. It comes down to having an unsigned int auto_increment primary key value in your table to use as the rowid. That's what "w

Re: InterBase vs. Mysql

Hi. On Tue 2003-02-18 at 11:48:53 +, [EMAIL PROTECTED] wrote: > hi Maciej, > > the only arguments you can get in favour of mysql is that it's free, and > some of its SQL statement are faster than interbase. Well, and outstanding support, IMHO. > Interbase has the advantage of having views,

Re: InterBase vs. Mysql

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Inandjo Taurel wrote: hi Maciej, the only arguments you can get in favour of mysql is that it's free, and some of its SQL statement are faster than interbase. Interbase has the advantage of having views, stored procedures,triggers,and it's crazily

Re: AW: InterBase vs. Mysql

Ben Clewett wrote: Here MySQL cannot compete. Your too expensive. Possibly only that MS-MSDE is 50Mb to download that anybody thinks about MySQL at all. Here there are very little competitive DBMS systems. But there are some, and more each day. PostgreSQL, MSDE, SapDB, OpenInterbase (or w

Re: InterBase vs. Mysql

On Tue 2003-02-18 at 12:02:59 +, [EMAIL PROTECTED] wrote: [...] > This is the main reason why I am looking at PostgreSQL at the moment, > although I've not looked much at Interbase, any good? > > Either that, or fork MySQL into FreeMySQL, as we can do under the GPL, > and not charge our selv

Re: InterBase vs. Mysql

Hi. Just a little correction. On Tue 2003-02-18 at 12:44:39 +0100, [EMAIL PROTECTED] wrote: > Hi Maciej, > > I don't know much about Interbase, but MySQL is for some cases a very good > choice! > Some database engineers would say MySQL isn't a database because it has no > transactions by know (i

  1   2   >