New User for mysql

Dear sir, I am a new use for My Sql , but some of the problem i have face, wish to have a help I am using a new version of My Sql (5.0.0) for WIn 2000 use, but I cannot create a new database, since always have a access denied problem, and i have try to add a hosts in windows , but the problem

RE: New User for mysql

Hi Alesi, I hate to RTFM as an answer but this is covered on numerous sites but here is the link to the windows section of post installation http://dev.mysql.com/doc/mysql/en/Windows_post-installation.html I hope that helps Dave Carrera -- UK Web Hosting @ http://www.ephgroup.com

Re: Cloned machine mysql startup problem with innodb

Paul, - Original Message - From: Paul W [EMAIL PROTECTED] Newsgroups: mailing.database.myodbc Sent: Monday, October 25, 2004 11:33 AM Subject: Cloned machine mysql startup problem with innodb For backup purposes I have what amounts to a complete clone of a live server. During the

Re: rounding problem

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I came upon an alogrithm years ago somewhere that showed how to programmatically round numbers. Here it is: // num is the number we want to round. it may be int or fp. // what is what we want to round num to (ie nearest 10, 1/100, etc) // The rounding

Re: Index not used for select distinct?

Hi, Bill Easton wrote: I think that MySQL is doing what would be expected, namely an index scan which reads entire index on IP and selects distinct values of IP. What I expect it to do is to give me all the distinct values in that row. It should be able to notice that there are only a few

Re: Two Instances

Christopher Chamber [EMAIL PROTECTED] wrote: Hi Everyone. My problem is that i want to create 2 instances of a sub-query. For Example: SELECT DISTINCT V4.* FROM (SELECT v2.* FROM cell v1,cell v2 WHERE v1.name = 'reviews' AND v2.sal = v1.sal ) v3 , v4 This query will gives an error as V4

Re: multiple mysql installations?

Minuk Choi [EMAIL PROTECTED] wrote: I managed to get multiple instances of mysql to install and run(via = mysqld_multi), but only by compiling the source. The system I had was Redhat9 and I used the Mysql RPM, but I couldn't = get that to work, so I opted to download and compile the source.

Re: Result returned by LOAD LOCAL...

Karam Chand [EMAIL PROTECTED] wrote: When I execute a LOAD DATA INFILE statment.. mySQL returns a result with info like: Records: 1 Deleted: 0 Skipped: 0 Warnings: 0 How can I get more information about deletions, warnings etc? See:

RE: New User for mysql

Hi Dave, thank you with your support, the problem has solve , since for the DNS problem for windows Best Regards Alesi Lee Ascalade / Marketing Sample Team HK tel: +85292699082 China: Mobile: 13829166715 / OFFICE : EXT 6240 mail to : [EMAIL PROTECTED] 2004/10/26 -Original

Re: Calculating a value based on an aliased column

In article [EMAIL PROTECTED], Eamon Daly [EMAIL PROTECTED] writes: SELECT CASE WHEN in_method = 'Add' THEN value + in_value WHEN in_method = 'Subtract' THEN value - in_value WHEN in_method = 'Multiply' THEN value * in_value WHEN in_method = 'Divide' THEN value / in_value END as

ulimit problem

Hi, I've run myisampack to compress a table and am now trying to recreate the index using myisamchk (as root) but I get an error 27. # myisamchk -rq --sort-index --analyze --tmpdir=/proxydb/mysql/tmp internet_usage.MYI - check record delete-chain - recovering (with sort) MyISAM-table

RE: ulimit problem

Hi, I've run myisampack to compress a table and am now trying to recreate the index using myisamchk (as root) but I get an error 27. # myisamchk -rq --sort-index --analyze --tmpdir=/proxydb/mysql/tmp internet_usage.MYI - check record delete-chain - recovering (with sort) MyISAM-table

Querying on subsets of one-to-many and many-to-many

Greetings, I have several solutions to a problem which requires temporary or cache tables but the different solutions are time consuming to test for performance and I was wondering if anyone had more information on this than myself. The server is 3.23.40 without possibility for upgrade to 4.x

Re: Calculating a value based on an aliased column

I thought about using a user variable to store the results of the phase_1 calculation. That would have changed the query to be: SELECT @p1 := CASE WHEN in_method = 'Add' THEN value + in_value WHEN in_method = 'Subtract' THEN value - in_value WHEN in_method = 'Multiply' THEN value *

List of Dates Grouped by Week

Hi, I am creating an online timesheet application. Most parts are done, however I have a problem displaying a list of unapproved timesheets. Here is my timesheet table: mysql DESCRIBE Timesheets; +---+-+--+-+++ | Field |

Re: Full-Text Search

1. The rows are sorted in the same order as any other query that doesn't have and order by specified, which means usually in the order they were entered. 2. When you mean location of matches, do you mean something like highlighting? That's the responsibility of the interface, not the

Re: Querying on subsets of one-to-many and many-to-many

Under most circumstances, even with data tables as large as yours, I have found that direct JOIN statements have provided acceptable performance. On certain highly normalized databases, where the requirements of the query needed more than 4 or 5 tables joined at once, I have also used your

Re: List of Dates Grouped by Week

Hi, You can use the WEEK function http://dev.mysql.com/doc/mysql/en/Date_and_time_functions.html and the query will look like select week(Date) as weekID,User_ID,sum(hours) from Timesheets group by weekID,User_ID order by weekID; You will have to do some additional math in your application to

Data Truncated warning about join, not insert?

Hi Everybody. I have a funny problem: I'm getting thousands of Data Truncated warnings when I insert a single row of data into a table, using an INSERT...SELECT. The funny thing is, the warning is for a column I'm not even inserting. It's only a column that I'm doing a join on. The query is

question about indexes

hello, I have a main table called client_tbl which contains: clientid bigint(14) [primary key] zoneid smallint(2) [secondary key] clientame varchar(255) clientaddress clientemail clientwww clientinfo clientamount decimal(6,1) and a lot of dictionaries that are int he same schema - so I describe

load data from file: warnings

I want to see the warnings when load data from text file using command mysal load data local infile 'mydata.txt' into table my_table; When I got Query OK, 1431 rows affected, 1506 warnings (0.27 sec) Records:1431 Deleted: 0 Skipped:0 Warnings:1506 I have to find out what cause the warnings. I

Re: Calculating a value based on an aliased column

Okay, upon reading the documentation, I came away with the same conclusion Shawn did. That said, I was curious to see what the results would look like, and lo and behold I got exactly the right result, even with GROUP BY: mysql SELECT - id, - name, - @p1 := CASE - WHEN in_method =

date type select

I have comlumn in mysql type datetime. I need to get the date in DATE format. select DATE(reg_date) as test from a1; It gives me an error. How to select date in different date format? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Re: date type select

- Original Message - From: Jerry Swanson [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, October 26, 2004 11:20 AM Subject: date type select I have comlumn in mysql type datetime. I need to get the date in DATE format. select DATE(reg_date) as test from a1; It gives me an

Re: load data from file: warnings

At 09:24 AM 10/26/2004, you wrote: I want to see the warnings when load data from text file using command mysal load data local infile 'mydata.txt' into table my_table; When I got Query OK, 1431 rows affected, 1506 warnings (0.27 sec) Records:1431 Deleted: 0 Skipped:0 Warnings:1506 I have to find

hostname

hi i have changed my host name now I got this when I tried to restart mysql mysql 6382 0.0 1.5 31340 3512 ?SOct25 0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/localhost.localdomain.pid --skip-locking what to do ? --

Re: date type select

What version of MySQL are you running? If you are on a version of 4.1 or higher, you have many more options than if you aren't. (I would refer you to the online manual but it seems to be busy right now and I can't get to the URL I need.) Shawn Green Database Administrator Unimin Corporation -

Re: Querying on subsets of one-to-many and many-to-many

Many thanks for the quick answer. I apologize for leaving out a few details that should have explained the context in greater detail. I'll use less theory below to further explain what's going on and then I'll make some remarks on your answer. Simplified down to the basics of this problem, we

InnoDB table mon

hello, my co-worker just tryed to create a InnoDB table on our running db and then all the sudden the db hangs for a minute then INNODB TABLE MONITOR comes on and starts writing to db.err file is this normal for the table monitor to come on by itself? thanks, jd -- MySQL General

Re: question about indexes

You asked about indexes for these tables I would make dictionaryid the PK of each dictionary_tbl. I would add an index to each dictionary_tbl for dictionaryword. I would make the PK for dict_client_tbl (clientid, dictionaryid) You also asked about fastest possible searches. Whenever you have

RE: ulimit problem

Hi, I've run myisampack to compress a table and am now trying to recreate the index using myisamchk (as root) but I get an error 27. # myisamchk -rq --sort-index --analyze --tmpdir=/proxydb/mysql/tmp internet_usage.MYI - check record delete-chain - recovering (with sort) MyISAM-table

Re: Querying on subsets of one-to-many and many-to-many

OK, now that I have a better model to work with, let me try again. (And stop being so discouraged! This is hard for everyone until they get the hang of it!!! =8-D ) Given a query that resembles this select * from A where (no links) or ((links to both 3 and 4) and (no links to 2)) This may

Re: question about indexes

hi again, I always must search within keywords that are in dictionary_tbl and always the searched word must be beginning-of-string maybe better solution is to use question like that: select c.* from dictionary_tbl d, dict_client_tbl k, client_tbl c where

Re: InnoDB table mon

On Tue, 2004-10-26 at 10:00, Jason Davis wrote: hello, my co-worker just tryed to create a InnoDB table on our running db and then all the sudden the db hangs for a minute then INNODB TABLE MONITOR comes on and starts writing to db.err file is this normal for the table monitor to

Re: question about indexes

See responses embedded DeRyl [EMAIL PROTECTED] wrote on 10/26/2004 12:58:38 PM: hi again, I always must search within keywords that are in dictionary_tbl and always the searched word must be beginning-of-string That's good. MySQL will use an index for that type of search maybe

Fw: question about indexes

- Forwarded by Shawn Green on 10/26/2004 01:52 PM - ok - I just forgot this idea with left comparision thanks for explanation about indexes i thought about another index on client_tbl containing fields: clientid and zoneid both fields are used very often I also thought about index

MySQL 4.1.7 has been released

Hi, MySQL 4.1.7, a new version of the popular Open Source/Free Software Database Management System has been released. It is now available in source and binary form for a number of platforms from our download pages at http://dev.mysql.com/downloads/ and mirror sites. Note that not all mirror

Broken File Upload

The following php code was working to upload files to my mysql db until I upgraded to mysql 4.0. Now, the files I try to upload do not get put into the folder. There is no error, the file just does not get posted. Any ideas? p Uploading File...p ?php echo $userfile; echo 'p'; $destination =

RE: Broken File Upload

[snip] The following php code was working to upload files to my mysql db until I upgraded to mysql 4.0. Now, the files I try to upload do not get put into the folder. There is no error, the file just does not get posted. Any ideas? p Uploading File...p ?php echo $userfile; echo 'p';

MySQL 4.1 table/column names in UTF8

From http://dev.mysql.com/doc/mysql/en/Upgrading-from-4.0.html : # Important note: MySQL 4.1 stores table names and column names in UTF8. If you have table names or column names that use characters outside of the range from `A' to `Z', you may have to do a mysqldump of your tables in MySQL 4.0

Re: MySQL 4.1 table/column names in UTF8

On Tue, Oct 26, 2004 at 01:03:22PM -0700, Brian Mansell wrote: From http://dev.mysql.com/doc/mysql/en/Upgrading-from-4.0.html : # Important note: MySQL 4.1 stores table names and column names in UTF8. If you have table names or column names that use characters outside of the range from `A'

RE: Broken File Upload

[snip] That code plus this code on the front end which I forgot to post... [/snip] But, there is no INSERT statement or any other item which indicates a connection to a database... -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

RE: Broken File Upload

[snip] I'm sorry, I'm new at this... The name of the file is stored in the mysql db and the actual file is stored in a directory on a linux server. So maybe my problem is not with mysql although that the same day I upgraded, the file upload stopped working... [/snip] Aha! What you have here is a

MySQL/InnoDB-4.1.7 is released

Hi! InnoDB is the MySQL table type that supports FOREIGN KEY constraints, row-level locking, Oracle-style consistent, non-locking SELECTs, multiple tablespaces, and a non-free online hot backup tool. Release 4.1.7 is mainly a bugfix release. It is the first in the 4.1 series that has been

Query Help

I'm converting from LassoMySQL (MySQL 3.23.54) to the current version of MySQL, and I'm running into a query problem. (sum(Rush)+sum(Rec)+sum(KO)+sum(Punt)+sum(Inter)+sum(Fum)+sum(BP)) as TDs Previously, this would produce a valid number. But now, I'm getting NULL. This is a sports database for

Re: Query Help

- Original Message - From: Keith Warren [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, October 26, 2004 5:15 PM Subject: Query Help I'm converting from LassoMySQL (MySQL 3.23.54) to the current version of MySQL, and I'm running into a query problem.

Outputting Data

I have a query: $QRY = SELECT * FROM MembersData; -- Executes fine, no problems. I have another though: $DataSet3 = SELECT * INTO OUTFILE '/www/Export/DataSet3.csv' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '\' LINES TERMINATED BY '\n' FROM MembersData; -- This returns an error saying

Re: Outputting Data

on 10/26/04 3:16 PM, Christopher Chamber at [EMAIL PROTECTED] wrote: I have a query: $QRY = SELECT * FROM MembersData; -- Executes fine, no problems. I have another though: $DataSet3 = SELECT * INTO OUTFILE '/www/Export/DataSet3.csv' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY

Where is 4.1.6 max 32 bit binary for Solaris?

Is there any plan to release a 32-bit binary 4.1.6 MySQL max for Solaris 9 and Solaris 8? I see all the other binaries for Solaris for everything - any reason to exclude the 32 bit? Thx, R

RE: Full-Text Search

Brent, Thanks for the reply. 1. Is there any way to sort the boolean full-text search results in orther of relevance as in non-bolean mode? I think it is very important. 2. Yes, that is what I meant. You are right. I look into grep. Thanks, -Jalil -Original Message- From: Brent

Re: MySQL 4.1.7 has been released

This is the first 4.1 production release. What about MyODBC 3.52 / 3.53 / whatever compatible with MySQL 4.1? -- ./ premax ./ [EMAIL PROTECTED] ./ koniec i bomba, a kto czytal ten traba. w.g. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

MySQL Icons?

Hi all. Is there an official / unofficial list of MySQL icons around somewhere? It's for a application launcher bar... -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL