FW: CSETI Announcement - Urgent Disclosure Project Update

Please read and forward. -Original Message- From: James [mailto:[EMAIL PROTECTED]] Sent: 14 February 2001 21:39 To: Young, Stuart; Raf; Nicky Gosney; Nick; [EMAIL PROTECTED]; John Boddy; Iain; Green, Karen; Darren S; Andy; [EMAIL PROTECTED] Subject: FW: CSETI Announcement - Urgent

Order of the update log

Are entries in the update log recorded in the *exact* order that the SQL 'hits the database'? I am using mysql version 3.22.22. I would normally assume the log was accurate but someone just told me that with mySQL log entries can be out of order by a few seconds because different mySQL

Win2K and MyODBC?

Hi, When I ran the application that uses myodbc as the interface to the mysql server (linux) on a Win98 platform, it works fine. But when I transferred the application to a Win2K pc and run it, I cannot even get through a connect. I have already granted access for the Win2K pc to access the

MySQL Client Application Suggestions

Hello all, I'm planning to develop a MySQL client application for Windows. This application should be able to connect, make queries, search, insert, view and create and print reports. My intention is to make the source code free to download for anyone interested. Help, advice, suggestions and

Select Problem

Linux , Apache, MySQL I have a problem in my MySQL database, this is the senario: I made an update statement on my table by wrong, then I restor my backup copy by copying the backup files on the exist ones without stopping the MySQL. Now I have problems in searching data: for example when I made

Re: Help please: getting the total from the results of SUM

hi rus, It seems my first question was not very clear. I wanted to use a function that I don't know if it exists or if there is some way to do this. Its name is TOTAL and what it does is add all values ignoring the GROUP BY clause, unlike SUM that is affected by GROUP BY. So from a bigger

unsecsribe

unsecsribe - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail

Can't connect in Windows 2000

I have installed Mysql on my Windows 2000 machine and everything seems to be working fine. However, when I try to telnet using the ip address on port 23 it won't connect. Sometimes it says something like 'NTLM authentication required'. I have IIS 5 installed. Does anyone know what I can do to

RE: Select Problem

Try rebuilding the indexes. -Original Message- From: Alaiddin Tayeh [SMTP:[EMAIL PROTECTED]] Sent: 15 February 2001 10:34 To: [EMAIL PROTECTED] Subject: Select Problem Linux , Apache, MySQL I have a problem in my MySQL database, this is the senario: I made an update

Seg fault after install with 3.32.23 on 2.2 Debian SMP.

I've looked for info on this, but the only thing I could find that was close was BSD and thread libs. Build .32, install it, and the daemon segfaults when I try to set up the initial load. Can some one point my to the right starting place. TNX -- Paul Repacholi 1

conversion of sql data to mysql

hi I am willing to convert the data from sql to mysql but i don't what quary should i pass to do the same, can you help me out. thanking you in anticipation manish __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a

from SQLServer7 to MySQL

Does anyone know of any good resources on converting an SQLServer7 database to MySQL? In particular, what's the best method of copying the data (about 150MB over 10 000 kilometres), and do any changes need to be made to datatypes? thx for any info or pointers to resources Dan

mysql takes so much resources

Hi there, I have 2 different websites using a single mysql server. Today the websites respons very slow and when I check the mysql proces i got the following info: PID %CPU %MEMVSZ RSS TT STAT STARTED TIME COMMAND 24339 51.6 0.7 6876 3704 p2- R10:56AM

RE: Can't connect in Windows 2000

Hi James, Yes this IS mysql related as MySQL does not support a Telnet connection to it :) You can either use the mysql.exe utility in the mysql\bin directory to use your mysql server or try one of the many MySQL GUI clients available in the Contrib section of www.mysql.com ,for ex.

Importing data to Excell

I have a table in my database, witch have a column thas is float(12,3), when i try to make a filter width that column i get an error message that says "Column PRPRVEND1 can't be used in criteria". Can someone tell me how to solve this problem?

Re: mysql takes so much resources

On Thu, Feb 15, 2001 at 11:41:48AM +0800, Teddy A Jasin wrote: Hi there, I have 2 different websites using a single mysql server. Today the websites respons very slow and when I check the mysql proces i got the following info: PID %CPU %MEMVSZ RSS TT STAT STARTED TIME

Re: auto_increment problem with mysql 3.23.32

William R. Mussatto writes: On Wed, 14 Feb 2001, Sinisa Milivojevic wrote: can an auto_increment column also have the attribute "unsigned" safely? Sincerely, William Mussatto, Senior Systems Engineer CyberStrategies, Inc ph. 909-920-9154 ext. 27 Yes it can. Regards,

Re: Linking problems.

Dave Juntgen wrote: I am unable to link libmysqlclient staticlly. I have tryed everything I could have thought, please look at the linking below, I tried to look for the file my_compress.o and my file system and I was unable to find it. gcc -g -Wall -O6 -static -o webchart.cgi

Compiling MySQL for other character sets

Hi all, Would like to ask a few questions on how to go about compiling support for a multibyte character set into MySQL. When I compile by default without specifying any character sets, it's supposed to compile in ALL character sets. Yet, when I try to run a mysql daemon that was compiled in

Re: SELECT help

Sir, haven't you posted this before? It looks familiar. You can't apply an aggregate function to an entire table if the SELECT statement has a GROUP BY clause. The aggregate function will return totals for the groups, not for the entire table. Bob Hall Can someone help me combine this

Re: Can anyone do this ?

Sir, 99% of the time, if someone can't create a TEMPORARY table, it means that they're using an earlier version of MySQL that doesn't support temp tables. The best thing to do is to update to the most recent version. If you can't update (e.g. if MySQL is being maintained by a web hosting

ERROR 2003: Can't connect to MySQL server on 'localhost' (10061) on Windows2000

ERROR 2003: Can't connect to MySQL server on 'localhost' (10061) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread,

Re: Can anyone do this ?

Hi: the way I handle this situation is: "create temporary table if not exists tblName (somefld I need, etc.) select iptable.* (or field names) from myTable where bluemoon = yes" Works every time for me. You need to know that temporary tables are only available to the creating user during the

Re: MySQL set up plan

Teddy A Jasin wrote: Hi All, Currently I have four websites using one MySQL server. The MySQL and the four websites each is placed on different server. However this MySQL server, I dont know why after running for a few days can stop responding that I have to restart the MySQL server.

Re: how can i get a table array of a database

yindu wrote: hello,sir; i do know i can use "show tables" to get the table names list.but i need get a table name array to use in my application.like the array i get by "select" function . how can i do it?thank you! yin du "show tables" returns a table,

CREATE TABLE

Hello, does anybody know why the following statement does not work when it contains "IF NOT EXISTS" CREATE TABLE IF NOT EXISTS tab_name. This is given in the manual but it does not work in this case. Any hint is appreciated. Ali

Re: Win2K and MyODBC?

At 18:13 15/02/2001 +0800, Li Sze wrote: Hi, I had connected a Win2k machine against a Linux Server using MyODBC but I don't remember if it was before or after the use of the encryption feature of Samba on the Linux Server. How you know Win2k machine only uses the encryption authentication. So I

Re: Table timestamps? More specific control of SHOW TABLE STATUS command

Atle, your suggestion is for the last time a record was updated. I am interested in the entire table. The closest that I have seen thus far is: SHOW TABLE STATUS The Update_time field is most likely what I am after. However I was hoping to do something more like select Update_time from

Replication - how to refresh the slave thread when the connection is lost ?

Hi ! I have two servers in a co-master relationship between an ISDN router. When I shutdown the router (so the connection is down), the slave thread doesn't react. On the show processlist, I have reading master update even if the connection is lost. Why ? It's a problem because on the other

ORDER BY on a column of type FLOAT

Hi, I'm trying to do a select in a table an want to get the result ordered by a column 8col2) of type FLOAT. select col1,col2 from table where col1='vvv' ORDER BY col2; It does not work. Is this supposed to work and if so how should I do it. /Pelle

Duplication Question

I want to make an exact duplicate (differenet name) of my entire DB for test purposes. My DB is not too large 8 tables, about max 200 records in any table. What is the best way to do this? -- Joseph Ferrara Member of the Engineering Staff LOCKHEED

Re: Excel-MySQL

I am not a Perl Guru. How would I set up this environment? Or is there another way to go from excel to MySQL? -- Joseph Ferrara Member of the Engineering Staff LOCKHEED MARTIN Naval Electronics Surveillance Systems

Can't find ./mysql/host.frm when starting mysqld

Hi; I have mysql-server-3.23.22.6 and mysql-3.23.22.6, pakages installed on my PC during Linux RedHat 7.0 installation. The probleme occurs when starting mysqld program : The command : mysql_install_db is OK but the command : safe_mysqld starts the server mysqld witch stops immediatly after.

concurrency in mysqld library ?

Hi, We would be very interested in the possibility to link our application to mysqld library. We wanted to know if some concurrency will be managed to provide data integrity if two instances of my application are working at the same time... If not, is there a possibility to do it or do I just

Re: CREATE TABLE

In article 000d01c0975e$08f57d40$[EMAIL PROTECTED], "Ali" [EMAIL PROTECTED] writes: Hello, does anybody know why the following statement does not work when it contains "IF NOT EXISTS" CREATE TABLE IF NOT EXISTS tab_name. This is given in the manual but it does not work in this case. Any

Re: Restart MySQL after rebooting Linux

I believe so. I was trying that and was missing something because I could not get it to work. Dave Hodgkinson wrote: kentj [EMAIL PROTECTED] writes: I have been reading the mysql book by Dubois and trying to figure out how to implement his restart methods on a SUSE Linux 7.0 Box. Has

Re: Duplication Question

mysqladmin create newdatabasename mysqldump olddatabasename | mysql newdatabasename Of course you'll need the usual username/password parameters as well. On Thu, 15 Feb 2001, Joe Ferrara wrote: I want to make an exact duplicate (differenet name) of my entire DB for test purposes. My DB

Server configuration denies access to the data source

Within the last few days we've started having serious problems with our database. We have no problems connecting to it using "mysql" and "mysqladmin". For instance, this command lets us into the database just fine: mysql -ucustomer -p customer_database The database seems to be working

Restart server when it hangs?

Hi, I am running a PIII 733 with 256 MB Ram and the mysql server keeps locking up. I go into the "top" program and the mysql process is taking up 95-98% of the processor and continually has to be killed and restarted. We are running on an BSDI4.2 / Apache server using PHP pages, I am not

Re: Excel-MySQL

Save to a CSV (comma-delimited file) from Excel, and take a look at the "load data infile..." command within the mysql documentation. regards, P On Thu, 15 Feb 2001, Joe Ferrara wrote: I am not a Perl Guru. How would I set up this environment? Or is there another way to go from excel

Accessing mysql tables from apache

Hello, We created a database in mysql and would like to know if there is any way to access them through a Web browser using Apache? Thanks for your help Mark - Before posting, please check:

SQL executes on command-line but not in PERL

Hi, everyone, I've recently run into a strange phenomenon. I try to tun the statement "update accounts set loggedin=10 where username='user'" -- works fine from the command line. But I used it in a PERL DBI situation and it does NOTHING -- no error, nothing. I know the PERL code is fine,

user variables length

How many Bytes can I save in a user variable? Because I have the following strategy: I want to save all PrimaryKeys in a user variable SELECT @a:=' '; SELECT @a := CONCAT(@a, ', ', TPrimKey) FROM table WHERE condition; so it is very important to know how many bytes can be stored. regards

Re: Table timestamps? More specific control of SHOW TABLE STATUScommand

On Thu, 15 Feb 2001, Jay Lawrence wrote: Atle, your suggestion is for the last time a record was updated. I am interested in the entire table. A temporary workaround could be select max(timestamp) from sometable. Jan -

Percent?

I can't find this in the manual (maybe I'm looking in the wrong place). How do I show a value as a percent? For example. SELECT data1, data2, data3 FROM table; Assuming data1 is 0.25, how do I show it as 25%? SELECT PERC(data1), data2, data3 FROM table;? Thanks. John Halladay

MySql-Client.rpm doesn`t install at all

Dear Sir, I have a Red-hat Linux6.2 . And i have installed MySql -3.23.32 server. It installed successfully. now when go to install MySql-3.23.32.rpm it doesn`t install, same for MySql-devel-2.32.32 it also doesn`t install. And also tell em how to Uninstalled .rpm. Pls reply me asap.

Re: taxes

This is not as easy (conceptually) as it sounds. You have to know the current state tax plus any county taxes applicable. If you set up a table with this information, you can cross reference the location of the buyer with the table, calculate the appropriate taxes, and charge them

Embedded MySQL: Opinion Please

Hi! I've been monitoring this list for a while now (re: lurking), I've seen only passing comments about embedding MySQL, so I thought I would come out and directly ask the MySQL community for your opinions, or better yet, actual facts - based on experience. I am evaluating MySQL / Linux for

Urgent Call for Participation

NuSphere has been asked to chair the MySQL track for the upcoming O'Reilly Open Source Conference (July 23-27 in San Diego, CA) and the deadline is virtually here -- decisions must be made by next Tuesday, Feb. 20. This is very short notice but we need your input by end of day tomorrow, Feb. 16.

Index not used for order by when more than 1 field selected, nowhere clause

Hi, I'm having a hard time figuring why mySQL does not use the index when sorting a table without any where clause when I include more than 1 field in the select part. To resume the case, I created a temp table with 3 single fields, added an index (see bottom for more details), ran 2 queries

Re: SQL executes on command-line but not in PERL

Thank you, Ryan, but the PERL code runs perfectly if I try it on any other field. It just doesn't run on THIS field. It's not a SPECIAL field in any way (like PRI Key or Unique or anything like that). When I run it in a compound statement like "update accounts set users=10, loggedin=10 where

sometimes hanging queries

I've been having a problem for quite awhile now with a particular query sometimes taking a long time. The query in question is a web-based search for messages in a bbs archive. Every time a message is added to the bbs each word in the message is parsed out and added to the

Re: Restart server when it hangs?

Hi Alan, Sounds like you need to do some tuning, you are running MySQL low on resources. This is one situation MySQL does not handle well. You need to adjust the login class to have more memory for instance you could create a class named "sql" and place it in your login .conf, then use vipw

Re: Percent?

couldn't you just do: SELECT data1 * 100 FROM table; which if data1 is 0.25, you'd get a result of 25, and depending on what you're using for the frontend, it would be really easy to add on the percentage sign - Atle On Thu, 15 Feb 2001, John Halladay wrote: I can't find this in the

FW: Accessing mysql tables from apache

Mark: You can either load perl module and use perl/cgi , or install php with mysql module enabled karl chen Programmer , Information System Department Valley Presbyterian Hospital Tel (818) 782-6600 ext. 5141 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]

Query/Left Join problem

Hi there. I'm having a problem with a couple of tables I'm using and finding some missing records and I was hoping someone could help me. Here is the setup. I have a table that is called "perms". Within here I have a bunch of columns, only 2 of which are important. ID which is an auto

FW: from SQLServer7 to MySQL

Hi Dan: I am looking for solution now , please email me if you get the answer karl chen Programmer , Information System Department Valley Presbyterian Hospital Tel (818) 782-6600 ext. 5141 -Original Message- From: Daniel Kirk [mailto:[EMAIL PROTECTED]] Sent: Thursday,

Re: taxes

Actually its even more complicated than this. There are city taxes and other taxes on other boundaries. In addition the rules as far as what things are taxable vary by locality. For example, some localities charge taxes on shipping and others don't. Brady Orand wrote: This is not as easy

RE: Index not used for order by when more than 1 field selected, no where clause

Hi, I think you are mis-understanding the information provided. What the "using index" note means is that the isbn column is part of the index, and since that is all that is selected, the index file is used to provide the data, the data file is not touched. Since there is (usually) less data in

Re: MySQL/MyODBC on Netware network

I implemented something almost identical to this setup in 1999. It worked well with Netware 4.11 (with IP enabled on the network) and mySQL 3.22.x running on both a Solaris and FreeBSD box. It should work fine with newer versions of Netware controlling the network. There are the standard

Re: Embedded MySQL: Opinion Please

http://www.qnx.com/ Tey actually have a headline right now about BerkleyDB being ported. While I take nothing away from the Mysql/Linux combo as a stable OS. I would stay that a specifically designed RTOS for embeded devices might be better in this situation. Gregg - Original Message

Size of database vs. performance?

Hey folks... quick question -- are there any performance issues associated with databases of extremely large size? I'm not talking about hundreds of thousands of records to be searched -- I'm talking about a few hundred images being stored in a database. It's not like I'd be full text searching

Re: Percent?

SELECT CONCAT(data1*100,'%') as percdata1, data2, data3 FROM table; John Halladay [EMAIL PROTECTED] wrote: I can't find this in the manual (maybe I'm looking in the wrong place). How do I show a value as a percent? For example. SELECT data1, data2, data3 FROM table; Assuming data1 is 0.25,

Re: Restart server when it hangs?

PHP4.0.4pl1 does not appear to fix the "lost connections" problem as it relates to persistent connections. It does appear to be fixed in the latest CVS version (currently 4.0.5-dev). Just FYI. "Ken Menzel" [EMAIL PROTECTED] wrote: On the PHP errors Are you using the latest PHP 4.0.4pl1

RE: MySQL Client Application Suggestions

Hi Carlo : You should be able to use MyODBC for windows which work with mysql karl chen Programmer , Information System Department Valley Presbyterian Hospital Tel (818) 782-6600 ext. 5141 -Original Message- From: Carlo Macis [mailto:[EMAIL PROTECTED]] Sent: Friday, February

Re: Index not used for order by when more than 1 field selected, no where clause

15/02/01 15:14, Quentin Bennett, [EMAIL PROTECTED]: Hi, I think you are mis-understanding the information provided. What the "using index" note means is that the isbn column is part of the index, and since that is all that is selected, the index file is used to provide the data, the data

RE: Percent?

How about... mysql select concat(50/1432, '%') as percentage; ++ | percentage | ++ | 0.03% | ++ 1 row in set (0.00 sec) mysql select concat(1324/4.14, '%') as percentage; ++ | percentage | ++ | 319.8068% | ++ 1 row in

RE: Percent?

Thanks again, that works great. One more question. Aside from giving it a percentage sign, how could I specify that I wanted to see two characters after the decimal? i.e. instead of 25% I would want 25.00% -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent:

RE: Query/Left Join problem

Hi, Your left join tried to find members in newsletter_subscriptions that don't exist in perms. How about they exist, but are 'No'?: SELECT newsletter_subscription.member_id FROM newsletter_subscription LEFT JOIN perms ON newsletter_subscription.member_id=perms.id WHERE

RedHat 7

Hi, I just wanted to confirm that MySQL is supported on RedHat 7. I saw references to RedHat 5.x and 6.x on the website but no references to RedHat 7. Thanks, shawn - Before posting, please check:

Re: Setting up Access 2000 to work using a mySQL db...

I have an Access 2000 Db on a Win98 system with tables linked to a MySql23.32-1 database on Suse Linux 7.0 using the latest MyODBC with a System DSN specifying anyname.dsn, the IP of 192.168.2.5 for the host, the database name of "metrics" and port 3306. I had to setup the privileges very

Re: taxes

guys I think you are making this a way bigger problem than it really is...e-merce crap is generally taxed based on the location of the vendor; much the same way in which mail order businesses are taxed. You really only have to worry about the state/locality in which you are incorperated/operate

RE: Query/Left Join problem

Duh why didn't I think of that. Thank you graciously. :) -Original Message- From: Quentin Bennett [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 15, 2001 4:26 PM To: 'Roger Ramirez'; MySQL List Subject: RE: Query/Left Join problem Hi, Your left join tried to find members

Re: how to add to a set

Bob Hall writes: What I want to do is something like this...a set variable in a table has a current value of "a,b,c" and I want to add the value "d" to it so the new value is now "a,b,c,d". The type is already defined as setval SET ('a', 'b', 'c', 'd', 'e', 'f') Ma'am, by variable, do

Re: taxes

Most of my clients get around this problem by incorperating the web side of the business under a different name. There have typically been two reasons for this; 1. it circumvents the tax issue. 2. if the web business encounters legal troubles et cettera...they can go belly up w/o affecting the

Install Prob

Hi, I am trying to install the latest distribution of mysql on a win 2000 box. The install program returns the following error each time: "An error occurred during the move data process -132" I noticed that someone else has brought up the same problem in the past on this list. I'm very

Re: RedHat 7

Shawn Boedecker wrote: I just wanted to confirm that MySQL is supported on RedHat 7. I saw references to RedHat 5.x and 6.x on the website but no references to RedHat 7. I'm running the latest stable release under RH7 with no problems. (NOTE: I compiled it myself, instead of using

Re: taxes

Also some states, like California, base their sales taxes for mail-order on the recipients postal code, not the vendors, unless the codes are the same. There are eight or nine different sales tax rates in CA depending on local taxes. Mike Wexler wrote: Mikel King wrote: guys I think you

sometimes hanging query - more info

* I left out a piece of probably important information the first time: search_messages_archive contains 11.5 million records. messages_archive contains 760,000 records. Thanks. -karl

Re: Re: Replication Bug in 3.23.33

Does this problem exist in 3.23.32?? Thanks for the bug report. The problem is a bug in the code that skips events when it sees a log entry with the same server id - something that can only happen in the bi-directional replicaiton setup. Fix: --- 1.85/sql/slave.cc Sat Jan 27 15:33:30

RE: If, then, else . . .

Hi, Look in the manual under Flow Control functions for use in select statements, and you should find what you need. Regards Quentin -Original Message- From: John Halladay [mailto:[EMAIL PROTECTED]] Sent: Friday, 16 February 2001 12:32 To: MySQL List (E-mail) Subject: If, then, else .

Re: If, then, else . . .

Hi, U can do nested ifs in Mysql. I am not sure if there is a limit in the no of levels it can go upto. If U R going to do this for 1000's of records there may be a slight drop in performance. SELECT field1, if(field1="a",100,if(field1="b",200,"ERROR")) FROM table; will do perfect. Cheers!

Re: SQL executes on command-line but not in PERL

What about repairing the table and what does DESC tablename say? - Original Message - From: "Laszlo G. Szijarto" [EMAIL PROTECTED] To: "Ryan Wahle" [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Friday, February 16, 2001 3:20 Subject: Re: SQL executes on command-line but not in PERL

MyODBC Prompt on connect

I've setup MyODBC (Win98) so I can access a MySQL db from Excel. It works fine, except that everytime I refresh the data, I get the MyODBC prompt, even when I select the option "Don't Prompt on Connect". This is kind of anoying, as I need to execute well over 700 queries. Anybody have any ideas?

Re: Re: Replication Bug in 3.23.33

On Thursday 15 February 2001 18:50, Rodolfo Sikora wrote: Does this problem exist in 3.23.32?? Thanks for the bug report. The problem is a bug in the code that skips events when it sees a log entry with the same server id - something that can only happen in the bi-directional replicaiton

Membership will be terminated.

If you wish to continue to receiving our FREE "Stock Pick" newsletter, you must click here: http://www.actionstocks.com, and enter your email address. Otherwise, you will not receive any future updates. Cyber Digital, Inc. - OUTLOOK Overview Cyber Digital, Inc. (OTC BB: CYBD) is a leading

MyODBC Prompt on connect -- Setup

Everytime I try and connect to MySQL Server I get Host then it's IP address is not allowed to connect to this Server.. Where can I get more info for a newbie to do this.. Cheers Mike /'^'\

Re: taxes

"MK" == Mikel King [EMAIL PROTECTED] writes: MK guys I think you are making this a way bigger problem than it MK really is...e-merce crap is generally taxed based on the location MK of the vendor; much the same way in which mail order businesses MK are taxed. You really only have to worry about

Re: MyODBC Prompt on connect -- Setup

At 19:49 15/02/2001 -0700, Mike wrote: Hi! First read the MySQL Manual about the GRANT/REVOKE commands and How the privilege system works on MySQL. Here you will learn how the MySQL grant tables handle the client machine (IP number or DNS or localhost when you are connecting the server locally),

re:how to know the information about a certern database?

thanks for your help, i have read the vararies through mysqld, there's no the varary defining the max_space of a certern database.i think it's important defect in mysql. i can define how much space will be dispensed to a database,and show how much space have been used to my database

Re: [OT] C program warnning (Just a test i try to understand C in order to build my mysql client program)

Hi. You know, this question is off-topic on the MySQL list. On Wed, Feb 14, 2001 at 09:54:44AM +, [EMAIL PROTECTED] wrote: Hi folks, I am trying to compile a simple program to play with mysql. But i am running into single problems, but i guess easy to solve by too many of the wizards

Re: Reserved words in MySQL update

Hi. On Wed, Feb 14, 2001 at 03:28:23PM -, [EMAIL PROTECTED] wrote: Description: Upgrading from 3.22 to 3.23 with a field having a reserved name ALTER TABLE barfs and doesn't let me do ALTER TABLE casualties CHANGE when cas_when DATE NOT NULL; ALTER TABLE casualties CHANGE `when`

Re: MySQL/MyODBC on Netware network

In the last episode (Feb 15), [EMAIL PROTECTED] said: I have a customer that is running on a Netware network. They do have the TCP/IP protocol running on the workstations that are using the Microsoft Client for Netware. I am planning to attach a SCO Openserver 5.0.5 Unix server running

Re: ranking album plays by city, help me beat Oracle

Hi. Could you please post the result of "EXPLAIN" for both queries and "SHOW INDEX FROM album_by_city". And, for how much cities does this gets executed? Additionally, I would be interested, if you used the same method with Oracle or another. If so, would you please post it, too. Bye,

Re: ranking album plays by city, help me beat Oracle

Could you please post the result of "EXPLAIN" for both queries and "SHOW INDEX FROM album_by_city". I haven't used EXPLAIN before. There are indexes on each column. And, for how much cities does this gets executed? There are about 100 cities or regions that are used for ranking.

Re: Embedded MySQL: Opinion Please

Hi. On Thu, Feb 15, 2001 at 02:00:04PM -0500, [EMAIL PROTECTED] wrote: [...] Can they (MySQL / Linux) work in such an environment, continuously, without error or failure, or requiring operator intervention, for years on end? Well, I see no principle problem here. The servers I administer run

Re: Good tutorial sites

I have got the same confg and works perfect. WinNT Linux MySQL. Why dont U directly edit the user table of mysql DB. Let Host be '%' and give some username password. mysql insert into mysql.user values('%','username',password('passwd'),'Y','Y','Y'); For test purpose let all priv fields

Re: Index not used for order by when more than 1 field selected, no where clause

Hi. On Thu, Feb 15, 2001 at 03:53:39PM -0500, [EMAIL PROTECTED] wrote: 15/02/01 15:14, Quentin Bennett, [EMAIL PROTECTED]: [...] Adding the author to the query means that the query now has to go to the data file to get the information, and since there is no restriction on isbn, the entire

Re: Embedded MySQL: Opinion Please

Benjamin Pflugmann wrote: Or, should I drop Linux and go with Windows CE, or some other RTOS? Well, I am biased there, but I would really avoid Windows. ;-) Other RTOS are probably a good idea, as someone else already said. Or, should I stop being a software developing and become a

Re: RedHat 7

"Ashley M. Kirchner" schrieb: Shawn Boedecker wrote: I just wanted to confirm that MySQL is supported on RedHat 7. I saw references to RedHat 5.x and 6.x on the website but no references to RedHat 7. I'm running the latest stable release under RH7 with no problems. (NOTE:

  1   2   >