Re: Using multiple character sets (Russian & English)

Just an update (but a good one): I have this working now if I issue all of my SQL statements direct from the MySQL monitor. Egor was 100% correct that this can be done. As a native English speaker, I was confused on how MySQL would handle characters that were not of the Western European type sinc

RE: Can't start MySQL

Herewith is the ERROR LOG FROM \apache group\apache2\logs per Marty's suggestion. Special note: The domain name and server name default to that of my ISP. Can't understand why that would be since the installation is entirely local. ERROR LOG [Mon Sep 01 11:47:26 2003] [notice] Parent: Created chi

subquery with left join in mysql 3.23.53 consume to much time - URGENT

Hi I have 2 tables and I want a faster report like this. | counter | user_company_name | +-++ | 65537 | company1 | | 65535 | company2 | | 64563 | company3 | | 52676 | company4 | User_table description | Field

RE: Show database problem

I used the flush privileges command There are in total 6 databases But only mysql and cehdb are visible. The MySQL version is 4.1.0-max-nt There are no other hosts configured for that user other then % Because it's mysql 4, the safe-show-database option is not usefull All the users that exist

optimization headaches.

hi all , and thanx for your help on my weird_indexes problem. no that i've created the indexes , the things are going a bit better but it's still not so fast : here's some output from mytop : - Queries Total: 442,666Avg/Sec: 7.74 Now/Sec: 16.27 Slow

make test error + make test --force error / Mysql 5.0 / Suse 8.2

I downloaded version 5.0 on 30/08/03, everything went fine until I did make test it failed with an error in derived, /root/mysql5.0/mysql-5.0/client/.libs/mysqltest: At line 97: Result content mismatch see output and attached. I then tried make test --force as suggested, but --force is an unrec

Re: Can't start MySQL

He is on Win32, probably Win98 Regards, Jakob > Might also help if he would specify the O/S ... > > - Original Message - > From: "Martin Gainty" <[EMAIL PROTECTED]> > To: "Bob Demers" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> > Sent: Monday, September 01, 2003 1:12 PM > Subject: Re: Can't

Re: listing all people who have the same firstname and lastname

On Fri, 29 Aug 2003 12:42:03 -0700 Grant Cooper <[EMAIL PROTECTED]> wrote: > I'm trying to get a query to work by listing all the people in a row with > the same last name and first name. > > key, fname, lname > 1 ,John, Smith > 4, John, Smith > 5, Cody,Edwards > 2, Cody, Edwards SELECT fname,ln

Re: Show database problem

On Monday, September 01, 2003 5:19 PM CEST, Joris Beckers wrote: > But, when I log in using that username. That user can access the main > database... > > > > Does anyone know how to fix this? > Only cehdb should be accessable. Did you try to set the safe-show-database flag? Hm, let me see where

Re: NFS and MySQL

On Mon, 1 Sep 2003 15:40:09 +0100 Simon Green <[EMAIL PROTECTED]> wrote: > Hi > I know that there are two problems when using NFS and MySQL. > One is speed. > My question is that with a good filer like a Netapps with Gig Ethernet would > speed stop being a problem? > > Two locking. > Why is thi

Re: Can't start MySQL

Might also help if he would specify the O/S ... - Original Message - From: "Martin Gainty" <[EMAIL PROTECTED]> To: "Bob Demers" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Monday, September 01, 2003 1:12 PM Subject: Re: Can't start MySQL Bob- I would start to look in \Apache Group\Ap

Re: Show database problem

On Mon, 1 Sep 2003 17:19:52 +0200 "Joris Beckers" <[EMAIL PROTECTED]> wrote: > I've got a user, admFrederic > He got the grants shown below. > Those are correct and I configured them that way. don't forget about FLUSH PRIVILEGES; --- WBR, Antony Dovgal aka tony2001 [EMAIL PROTECTED] -- MySQL G

Show database problem

I've got a user, admFrederic He got the grants shown below. Those are correct and I configured them that way. mysql> SHOW GRANTS FOR admFrederic; +--- + | Grants for [EMAIL PROTECTED] | +---

Re: Can't start MySQL

Bob- I would start to look in \Apache Group\Apache2\logs and tell us what error.log says -Martin - Original Message - From: "Bob Demers" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, September 01, 2003 6:46 AM Subject: Can't start MySQL > I've clearly done something worng but,

Re: Need help with oracledump (contributed program)

Doug I copied this from an SAP integration with Orace site http://saphelp.cob.csuchico.edu/OraHelp/Darwin36/inst36fhp/html/5-odbc.htm 5.5.3 tsnames.ora File the file ORACLE_HOME/network/admin/tnsnames.ora must point to the listener (i.e., the TCP/IP port) on the database server. (ORACLE_HOME is th

NFS and MySQL

Hi I know that there are two problems when using NFS and MySQL. One is speed. My question is that with a good filer like a Netapps with Gig Ethernet would speed stop being a problem? Two locking. Why is this a problem? Do locks get missed when righting from the system to the filer? Thanks for an

Re: Can we remove the results of "Analyze Table"?

Hi! On Aug 29, Kevin Fries wrote: > Can we 'unanalyze' a table? I'd like to remove the statistical > information from my analyzed table, for testing purposes. yes, but it is not easy. You cannot mark the table as "unanalyzed" - so you need to rebuild it somehow. REPAIR TABLE table_name EXTENDED

Can't start MySQL

I've clearly done something worng but, novice that I am, I'm at a dead end to figuring out just where I've gone astray. I've scoured the help files and faqs locally and online but can't seem to find anything I recognize as relevant. Perhaps someone can point me in the right direction. Have insta

Re: Need help with oracledump (contributed program)

On Mon, Sep 01, 2003 at 01:03:48PM +0100, Jim Smith wrote: > > I'm trying to figure out how to use the contributed program > > "oracledump" in an environment where I don't have a login to the *nix > > host running Oracle. All my connectivity to the Oracle host is via > > port 1521 and JDBC. > > >

Re: Cannot Connect to Server

Make sure %WINDOWS%\my.ini has the entry bind-address=127.0.0.1 -Martin - Original Message - From: "Antony Dovgal" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Monday, September 01, 2003 3:42 AM Subject: Re: Cannot Connect to Server > On Mon, 1 Sep 2003 11:34:

Re: repeated Show Status query

You should be able to change that ins sqlsysadmin (the traffic light) under the section options if I remember correctly and change default 10 to whatever you wish Albert - Original Message - From: "Pam Vermeer" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Cc: "Pam" <[

RE: Need help with oracledump (contributed program)

> I'm trying to figure out how to use the contributed program > "oracledump" in an environment where I don't have a login to the *nix > host running Oracle. All my connectivity to the Oracle host is via > port 1521 and JDBC. > > The oracle dump command seems to be looking for a SID in a file calle

repeated Show Status query

I recently upgraded to MySQL 4.0.12 and I logged all queries for a little while, just to see what was happening. When I looked at the log, I saw that there was a Show Status query happening every 10 seconds. This happens both on my server which runs WIndows 2000 Server and on my laptop which r

Re: Can we remove the results of "Analyze Table"?

"Kevin Fries" <[EMAIL PROTECTED]> wrote: > > Can we 'unanalyze' a table? I'd like to remove the statistical > information from my analyzed table, for testing purposes. > You can't. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.

Re: Cannot Connect to Server

On Mon, 1 Sep 2003 11:51:07 +0100 "Phil Ewington - 43 Plc" <[EMAIL PROTECTED]> wrote: > Could not read response from last sender :o( from <[EMAIL PROTECTED]> ? it's Yet Another Spammer(or Autoresponder) on this list. YAS(A) =) dunno why list administration haven't blocked him yet. These robots ar

RE: Cannot Connect to Server

Could not read response from last sender :o( -Original Message- From: Phil Ewington - 43 Plc [mailto:[EMAIL PROTECTED] Sent: 01 September 2003 11:35 To: Mysql Subject: Cannot Connect to Server Hi All, Having problems with connecting to mysql server as we have had to change all the IP

Re: Cannot Connect to Server

On Mon, 1 Sep 2003 11:34:31 +0100 "Phil Ewington - 43 Plc" <[EMAIL PROTECTED]> wrote: > The error message is: > "Warning: mysql_connect(): Can't connect to local MySQL server through > socket '/var/tmp/mysql.sock' (111) in /home/sites/.. on line 3 > Unable to select database" is MySQL socket real

Cannot Connect to Server

Hi All, Having problems with connecting to mysql server as we have had to change all the IP addresses on the server. I am assuming that localhost is the problem, how can I manually change localhost to be an IP address? The error message is: "Warning: mysql_connect(): Can't connect to local MySQL

Re: Help Instalation

[EMAIL PROTECTED] wrote: > > In a normal case, to install Mysql in windows we need to run setup.exe and > it's launch a wizard when we define some things like a destination > directory. > > I want to know (if somebody can help me) if it is possible to install mysql > and the wizard not be lau

Re: Using multiple character sets (Russian & English)

Rachel Rodriguez <[EMAIL PROTECTED]> wrote: > > I have experience using MySQL and SQL commands in > general, but I am going through my first experience > with working with multiple character sets. > > I am working on a Russian/English translation project > and I'd like to create a table where col

Re: uniques, keys, etc?

Joseph <[EMAIL PROTECTED]> wrote: > I have a table I use to keep track of referred users on my top list. Below > you will find the four columns in my table. What I need to do is keep > entries (rows) unique based on the linkid, ipaddress, and the clicktype so > that a user is not counted twice if t

Re: Dates

Joseph Bueno wrote: . . . rt3=# select age(now(),'2003-08-26'::timestamp); age 6 days 10:14:43.421275 +++ Thanks, and select age('2003-08-26',resolved) where 'resolved' is a 'timestamp'. -- MySQL General Mailing List For list archi

Re: Dates

Mixo Shiburi wrote: I am in the process of porting some python scripts to Mysql. Currently, the scripts I have queries a Pg database for entries (made) between certain dates. The python script snippet of the query mainQuery = """ select distinct id,queue,own

Re: TABLE - OR

wow. yeah it works. Thanks a lot. -N. > On Mon, 01 Sep 2003 17:13:20 +0900 > Nishant <[EMAIL PROTECTED]> wrote: > > > I dont know why my brain stopped working :) > > > > I have two tables T1 and T2, both of which have a column : Seria

Dates

I am in the process of porting some python scripts to Mysql. Currently, the scripts I have queries a Pg database for entries (made) between certain dates. The python script snippet of the query mainQuery = """ select distinct id,queue,owner,created,now(),age

Re: TABLE - OR

On Mon, 01 Sep 2003 17:13:20 +0900 Nishant <[EMAIL PROTECTED]> wrote: > I dont know why my brain stopped working :) > > I have two tables T1 and T2, both of which have a column : SerialNo > > Now I want to select those rows from T1 whose SerialNo is not present in > T2. > > This dont work: >

TABLE - OR

I dont know why my brain stopped working :) I have two tables T1 and T2, both of which have a column : SerialNo Now I want to select those rows from T1 whose SerialNo is not present in T2. This dont work: select T1.* from table1 as T1 straight_join table2 as T2 where

Re[2]: Regex and email

Bonjour Matthew ! MS> Not sure about php syntax, but check out the perl module (in CPAN) MS> Email::Valid. I'm not searching the PHP syntax, but the SQL syntax... :) A + -- ** Richard CARLIER htt

RE: Regex and email

Hi, Not sure about php syntax, but check out the perl module (in CPAN) Email::Valid. Here is the code fragment for the regex: # Regular expression built using Jeffrey Friedl's example in # _Mastering Regular Expressions_ (http://www.ora.com/catalog/regexp/). $RFC822PAT = <<'EOF'; [\040\t]*(?:\(

Regex and email

Hi ! I'm working on a regex to "validate" emails stored in a table. I'll try other regex from php tips or javascripts tips, but the exact syntaxe of regex in mysql are differents and nothing work fine... And I'm not very good with regex :\ I find this : SELECT email FROM mailing WHERE emai

Re: Records Mysql can handle??

http://www.mysql.com/doc/en/Table_size.html On Sunday, August 31, 2003, at 01:07 PM, Binay Agarwal wrote: Hi All, Can any body tell me how many records mysql can hold efficiently. i.e Is there any boundation on number of records mysql can handle? Please let me know ... Thanks Binay -- MyS

Records Mysql can handle??

Hi All, Can any body tell me how many records mysql can hold efficiently. i.e Is there any boundation on number of records mysql can handle? Please let me know ... Thanks Binay

Help with SQL Query

Hi Having 2 tables TOrders: ProductID Amount 400810 4008 -5 4110 7 4110 2 4110 -4 4110 1 TStock ProductID Count 4110 3 4110 2 What I want Is a sum of product nee

Need help with oracledump (contributed program)

Hello, I'm trying to figure out how to use the contributed program "oracledump" in an environment where I don't have a login to the *nix host running Oracle. All my connectivity to the Oracle host is via port 1521 and JDBC. The oracle dump command seems to be looking for a SID in a file called t

Re: spaces in index name

Hi, - Original Message - From: "Benjamin KRIEF" Sent: Sunday, August 31, 2003 8:17 PM Subject: Re: spaces in index name > thanks for all your answers ! i'd never imagine that mailing-list to be > so active and efficient! It's usually not that active on weekends, volume-wise. And I see R

Re: Re[2]: Dump FK

Just use SET FOREIGN_KEY_CHECKS=0 To turn off all foreign key contraints before you import the data. Then use SET FOREIGN_KEY_CHECKS=1 to turn them back on. Go to http://www.innodb.com/ibman.html and search for foreign_key_checks for the docs. Hope this helps. Toro > On 01/09/2003 at 1:01 Chris

Re: spaces in index name

thanks for all your answers ! i'd never imagine that mailing-list to be so active and efficient! matt : does mysql locks the table during the whole alter table execution? Matt W wrote: Hi Ben, When using column/index names with odd characters (such as spaces), you need to use backticks (SHIFT

Re: spaces in index name

Hi Ben, When using column/index names with odd characters (such as spaces), you need to use backticks (SHIFT + the ~ key) around the name: `index id` This ALTER TABLE query should make all the changes you want: ALTER TABLE v2easy0_users DROP INDEX `login connexion`, DROP INDEX `index id`, -- Dro

Re: spaces in index name

In the last episode (Sep 01), Benjamin KRIEF said: > hi all , > > i'm trying to improve performance of a quite big and heavily used mysql > set of tables. > i want to create some indexes on this table , but before this , i'd like > to remove the ones created by my predecessor , which are sometim

Re: spaces in index name

* Benjamin KRIEF [...] > first of all , i'm asking myself : why is there 2 primary keys on the > same column ? Don't know... strange. [...] > mysql> drop index login connexion on v2easy0_users; > ERROR 1064: You have an error in your SQL syntax near 'connexion on > v2easy0_users' at line 1

spaces in index name

hi all , i'm trying to improve performance of a quite big and heavily used mysql set of tables. i want to create some indexes on this table , but before this , i'd like to remove the ones created by my predecessor , which are sometimes duplicate , and somtimes useless. here is an output from s

Re: how to select with a set type field

* Jonathan Soons > I have a table 'organisms' with a field 'category' > of type SET('birds','bees','flowers','trees'). > A record could have none or more of these in that field. > How do I select all records with both 'flowers' and 'trees'? > I can "SELECT category,key FROM organisms;" > Then I can