Re: Subscription

Dear Tom [aka Cedomilj], Thank you for interest in MySQL AB - the world leader ... (blah-blah). Subscribing to MySQL mailing list is a free and unattended service. You don't have to remit any money to Nigeria (ZERO MILLION DOLLARS). Just sit back on your chair and read messages, posted to mailing

Re: Subscription

On Thu, 03 Jun 2004 14:56:23 -0500 "Tom Murdock" <[EMAIL PROTECTED]> wrote: > Good evening, > > I would like to subscribe to MySQL mailing list. > Thank you. Your wish appears to have been granted. :) Josh -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsub

Re: IS NULL works, but IN (NULL) doesn't

At 18:32 -0700 6/3/04, Daevid Vincent wrote: How come this one works: SELECT wifi_list, IFNULL(wifi_list, 0) as wifi_list_new, FROM wifi_table LEFT JOIN Swordfish.scanner ON scanner.scanner_id = wifi_table.scanner_id LEFT JOIN wifi_wlist_table ON wifi_table_mac = mac WHERE last_seen >= CURREN

Re: mysql error

starofframe wrote: Hi all, I have a problem when I'm trying to connect to mysql server at my web hosting... appears error message like this : Could not connect to MySQL server! 2002: Can't connect to local MySQL server through socket '/usr/home/greatdynamic/mysql/mysql-greatdynamic.sock' (2) neve

mysql error

Hi all, I have a problem when I'm trying to connect to mysql server at my web hosting... appears error message like this : Could not connect to MySQL server! 2002: Can't connect to local MySQL server through socket '/usr/home/greatdynamic/mysql/mysql-greatdynamic.sock' (2) never appeared such

IS NULL works, but IN (NULL) doesn't

How come this one works: SELECT wifi_list, IFNULL(wifi_list, 0) as wifi_list_new, FROM wifi_table LEFT JOIN Swordfish.scanner ON scanner.scanner_id = wifi_table.scanner_id LEFT JOIN wifi_wlist_table ON wifi_table_mac = mac WHERE last_seen >= CURRENT_DATE AND wifi_list IS NULL; This one wo

Subscription

Good evening, I would like to subscribe to MySQL mailing list. Thank you. Cedomilj _ FREE pop-up blocking with the new MSN Toolbar – get it now! http://toolbar.msn.click-url.com/go/onm00200415ave/direct/01/ -- MySQL General Mailing L

Re: php to mysql

venkata ramana wrote: Hi, I don't know whether I can ask this question on this mailing list or not, but I want to know how the php communicates with mysql, when it is on the localhost. Does it use unix domain sockets or it uses TCP sockets only? Any help or pointers in this regard will be of

RE: Self-Join Query

Harold and Brent, Thanks for your help. I tried Brent's solution first, but the MySQL client didn't seem to like the IF statements. The case statements worked sweet though. Cheers guys, James Katarski Systems Administrator School of Computer & Information Science Edith Cowan University ML

php to mysql

Hi, I don't know whether I can ask this question on this mailing list or not, but I want to know how the php communicates with mysql, when it is on the localhost. Does it use unix domain sockets or it uses TCP sockets only? Any help or pointers in this regard will be of great help for me. T

Re: Help with a SELECT Statement

On Thu, 3 Jun 2004 22:36:55 +0100 "Andrew Dixon" <[EMAIL PROTECTED]> wrote: > Hi Everyone. > > I have the following SELECT statement the get information from two > tables. The statement only works when it finds a value for the > image_archive.circuit value in the circuits table. However, not all

Re: Can you rename or copy a database?

"I want to make an exact copy named "works2."" what about INSERT INTO table1 (table1Columns) SELECT table2Columns FROM table2; "David Blomstrom" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > --- Schalk <[EMAIL PROTECTED]> wrote: > > I would suggest exporting your current datab

MAX question

Hi, Table "mpprim" has UNIQUE constraint on 3 fields: Primka, Tip, Godina (Document, Type, Year in English). I am trying to insert a new record into it without having first to count how manny documents of certain type exist in table for choosen year. Sample data: ID(Autoinc) Primka(INT not null

RE: Can you rename or copy a database?

--- Schalk <[EMAIL PROTECTED]> wrote: > I would suggest exporting your current database as a > .sql file taking across > all structure and data. Create your new database and > run the .sql file on > it. Thanks for the tip. Let me just make sure I understand the mechanics. Let's say I have a databa

RE: Slow querys When ADSL is down on W2K

sound like windows is looking for something.. is there any kind of DNS lookup or a machine in the Network Neighbourhood/Domain that might be unavailable when the adsl goes down? Not a network expert, so just a guess 8-) Peter > -Original Message- > From: Mauricio Pellegrini [mailto

Re: Can you rename or copy a database?

At 12:44 -0700 6/3/04, David Blomstrom wrote: My database "world" won't work online, because the online version is username_world, with a different username and password. So I want to create a copy of world named username_world. Databases don't have usernames or passwords. I created a new database

Re: Granting privileges to other users

At 13:40 -0700 6/3/04, Robert Frame wrote: Thank you for the reply. I apologize for not clearly demonstrating what I am trying to accomplish. No apology necessary. I know what you're trying to accomplish. My questions (which you have not answered) are designed to cause you to think about what you

Help with a SELECT Statement

Hi Everyone. I have the following SELECT statement the get information from two tables. The statement only works when it finds a value for the image_archive.circuit value in the circuits table. However, not all entries in the database has a value in the this field, some are set to 0 as the circui

error 2013 : Lost connection to MySQL server during query

Hello all, I'm getting the error message "2013 : Lost connection to MySQL server during query" during inserts on a lightly-loaded mysql server. I also noticed the following error in the error log... Version: '4.0.20-standard-log' socket: '/tmp/mysql.sock' port: 3306 040603 16:25:48 Aborted c

Re: Tuning MySQL 4.0.20 for large full table scans

Hi Dan, - Original Message - From: "Dan Nelson" Sent: Thursday, June 03, 2004 12:34 PM Subject: Re: Tuning MySQL 4.0.20 for large full table scans [snip] > > Not sure what can be done about making it not go straight to tmpdir > > with a BLOB column in the SELECT clause, though. Probably

Re: Slow querys When ADSL is down on W2K

I'd suggest you add a static route to the W2k clients just to see if that corrects the problem... try this command: route ADD ddd.ddd.ddd.ddd MASK mmm.mmm.mmm.mmm ggg.ggg.ggg.ggg d = destination (the mysql DB server) m = subnet mask (255.255.255.0 or whatever your route happens to be) g = gateway

Re: VB .NET & MYSQL - LOCK TABLES

Put of all three lines of your sql in one string variable with the semi-colons and execute it as one command. Works for me using the ByteFX libraries. Larry - Original Message - From: "Victor Pendleton" <[EMAIL PROTECTED]> To: "'Mirco Santori '" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>

Re: Table types

Hi Ronan, Yes, it's fine to mix table types in databases and queries. Matt - Original Message - From: "Ronan Lucio" Sent: Thursday, June 03, 2004 2:44 PM Subject: Table types > Hi, > > Is it wise to have a database with hybrid table types? > > In other words: if I have a table that w

Slow querys When ADSL is down on W2K

Hi, This seems to be a strange situation. I have a server ( Sun fire v65x ) running SuSE 8.2 and My-Sql 4.1.1alpha-max. I've detected that when our adsl internet connection is down the querys on our local network turns to be unusually slow. But this situation occurs only when querys are execu

Re: Join question

On Thu, 3 Jun 2004 15:22:36 -0500 Josh Trutwin <[EMAIL PROTECTED]> wrote: > Or in preferable INNER JOIN syntax which makes it easier to forget a > JOIN condition: Oops - I meant "harder to forget" not "easier to forget". Doh. > > SELECT c.cst_SiteID, c.cst_IDC, a.asset_ID, o.offer_ID, > o.o

RE: Can you rename or copy a database?

You have hit a foreign key constraint error. You can try appending SET FOREIGN_KEYS_CHECK = 0 at the beginning of your script and SET FOREIGN_KEYS_CHECK = 1 and the end of your script to disable the foreign key constraints. -Original Message- From: David Blomstrom To: [EMAIL PROTECTED] Sen

RE: VB .NET & MYSQL - LOCK TABLES

You will need to reuse your database connection, do not open a new connection with each call or the lock will not be there. LOCK TABLE table1 READ; SELECT * FROM table1; UNLOCK TABLES; -Original Message- From: Mirco Santori To: [EMAIL PROTECTED] Sent: 6/3/04 2:17 PM Subject: VB .NET & MYS

Re: Join question

On Thu, 3 Jun 2004 13:06:54 -0700 "Chris Dietzler" <[EMAIL PROTECTED]> wrote: > Running 4.0.18 > > I am trying to run a query where the query gets the offer_ID of a > certain customer from the offer table and displays in the results > the offer_Name associated with the offer_ID. Right now the way

Re: MySQL Warning Messages - Continued..

Yes, you were right! After reading your mail, counted the columns in my .txt file and discovered that there was a missing one. I've just added the column, issued a LOAD DATA... and the result was Zero warnings this time. Thanks a lot. Mauricio On Thu, 2004-06-03 at 09:59, Michael Stassen wro

Join question

Running 4.0.18 I am trying to run a query where the query gets the offer_ID of a certain customer from the offer table and displays in the results the offer_Name associated with the offer_ID. Right now the way the query is working it displays all the offers in the offer table regardless of the off

Table types

Hi, Is it wise to have a database with hybrid table types? In other words: if I have a table that wouldn´t have many INSERT/DELETE/UPDATE queries, may I create it as MyISAM type and even interact (make JOINs) with other InnoBD and MyISAM tables? Or is it better (faster) to create all columns wit

Can you rename or copy a database?

My database "world" won't work online, because the online version is username_world, with a different username and password. So I want to create a copy of world named username_world. I created a new database named username_world and started importing tables into it, until I hit a snag... MySQL sa

VB .NET & MYSQL - LOCK TABLES

Hello MySql List, I have create connection with VB .NET & MySql, and now i must use the LOCK TABLES statment. I want to know how i can use this sintax .. i must open connection - begin the LOCK TABLES - begin the select statment, and then UNLOCK TABLES .. I think so that is not correctly .. w

Re: v4.0.13 -> v4.0.18

michael young <[EMAIL PROTECTED]> wrote: > I want to move a DB to a new server. > The old one has MySQl version 4.0.13. > The new one has 4.0.18. Is there any kinda > prep that needs to be done or can I move it > right on in? > Making backup of your databases is always recommended. -- Fo

Re: Exporting/Importing Databases

At 21:54 -0700 on 06/02/2004, David Blomstrom wrote about Re: Exporting/Importing Databases: --- "Robert A. Rosenberg" <[EMAIL PROTECTED]> wrote: At 20:36 -0700 on 06/02/2004, David Blomstrom wrote about Exporting/Importing Databases: >Third, my practice database includes half a dozen >table

Re: Where do exported SQL files go?

At 22:17 -0700 on 06/02/2004, David Blomstrom wrote about Re: Where do exported SQL files go?: --- "Robert A. Rosenberg" <[EMAIL PROTECTED]> wrote: At 20:13 -0700 on 06/02/2004, David Blomstrom wrote about Re: Where do exported SQL files go?: >(I'm using Mozilla Firefox, which downloads >eve

Re: Exporting/Importing Databases

Wow, I tried importing my SQL file again, with the referential integrity statements. This time I got a NEW error: Database geoblue_world - Table continents running on localhost Error There seems to be an error in your SQL query. The MySQL server error output below, if there is any, may also he

SOLVED Re: mysqldump WHERE clause

On Thu, 03 Jun 2004 13:57 , Michael Stassen <[EMAIL PROTECTED]> sent: > > >McKeever Chris wrote: > >> MYSQL 4.0.13 >> >> I must be doing something wrong - I am trying to do a mysql dump and it > > keeps yelling that tables dont exist whenever I put a where clause in.. >> it runs fine when I lea

Re: Exporting/Importing Databases

--- Egor Egorov <[EMAIL PROTECTED]> wrote: > David Blomstrom <[EMAIL PROTECTED]> wrote: > >> If you use command-line client you can do: > >> > >> mysql> SET FOREIGN_KEY_CHECKS = 0; > >> mysql> SOURCE file_name; > >> mysql> SET FOREIGN_KEY_CHECKS = 1; > > > > Does anyone on this list know... > >

Re: Unicode characters become question marks

I'm confirmed that all the data were inserted into database correctly. I need to look elsewhere. The following is the test script, written in JudoScript. Silvio, this may be another easy way for you to confirm what's in the database. Suppose you have Java 1.3 or up installed; all you need is to

Re: SQL help

Bob Lockie <[EMAIL PROTECTED]> wrote: > What I really want was > mysql> update records set records.prio=2 where records.in=(select > records.id from records, audit_log, audit_log_records where > audit_log.tracker_id=audit_log_records.tracker_id and > records.id=audit_log_records.id and audit_log

Re: SQL help

Bob Lockie wrote: What I really want was mysql> update records set records.prio=2 where records.in=(select records.id from records, audit_log, audit_log_records where audit_log.tracker_id=audit_log_records.tracker_id and records.id=audit_log_records.id and audit_log.operation='D' and audit_log.

v4.0.13 -> v4.0.18

Hi, I want to move a DB to a new server. The old one has MySQl version 4.0.13. The new one has 4.0.18. Is there any kinda prep that needs to be done or can I move it right on in? thank you for your time, Michael -- MySQL General Mailing List For list archives: http://lists.mysql.com/my

Re: Exporting/Importing Databases

David Blomstrom <[EMAIL PROTECTED]> wrote: > --- Egor Egorov <[EMAIL PROTECTED]> wrote: >> David Blomstrom <[EMAIL PROTECTED]> wrote: >> > --- "Robert A. Rosenberg" <[EMAIL PROTECTED]> >> wrote: >> >> You just got caught with the old Referential >> >> Integrity Gotcha. It >> >> will not allow you

Re: mysqldump WHERE clause

McKeever Chris wrote: MYSQL 4.0.13 I must be doing something wrong - I am trying to do a mysql dump and it > keeps yelling that tables dont exist whenever I put a where clause in.. it runs fine when I leave the where clause off - any help here? mysqldump -u root -p hotswap EmailDatabase_k EmailMes

SQL help

What I really want was mysql> update records set records.prio=2 where records.in=(select records.id from records, audit_log, audit_log_records where audit_log.tracker_id=audit_log_records.tracker_id and records.id=audit_log_records.id and audit_log.operation='D' and audit_log.completed is null)

Re: can you drop multiple indexes at one time?

Donny Simonton wrote: I definitely don't see this in the documentation anywhere, but can you drop multiple indexes at one time with an alter table? Donny From the manual , ALTER TABLE has syntax ALTER [IGNORE] TABLE tbl_name alter_specific

Re: Tuning MySQL 4.0.20 for large full table scans

In the last episode (Jun 03), Dossy said: > On 2004.06.03, Dan Nelson <[EMAIL PROTECTED]> wrote: > > Consider multicolumn indexes; if you always "SELECT field1 from > > table where field2=blah", creating an index on (field2,field1) will > > let mysql bypass table lookups completely. > > Our typica

can you drop multiple indexes at one time?

I definitely don't see this in the documentation anywhere, but can you drop multiple indexes at one time with an alter table? Donny

Re: mysqldump WHERE clause

On Thu, 3 Jun 2004 12:11 , McKeever Chris <[EMAIL PROTECTED]> sent: > > >On Thu, 03 Jun 2004 12:07 , gerald_clark [EMAIL PROTECTED]> sent: > >> >> >>McKeever Chris wrote: >> >>>MYSQL 4.0.13 >>> >>>I must be doing something wrong - I am trying to do a mysql dump and it keeps >>>yelling that table

Re: Exporting/Importing Databases

--- Egor Egorov <[EMAIL PROTECTED]> wrote: > David Blomstrom <[EMAIL PROTECTED]> wrote: > > --- "Robert A. Rosenberg" <[EMAIL PROTECTED]> > wrote: > >> You just got caught with the old Referential > >> Integrity Gotcha. It > >> will not allow you to create countries since > >> statesarticles does

Re: mysqldump WHERE clause

On Thu, 03 Jun 2004 12:07 , gerald_clark <[EMAIL PROTECTED]> sent: > > >McKeever Chris wrote: > >>MYSQL 4.0.13 >> >>I must be doing something wrong - I am trying to do a mysql dump and it keeps >>yelling that tables dont exist whenever I put a where clause in.. >>it runs fine when I leave the

Re: mysqldump WHERE clause

McKeever Chris wrote: MYSQL 4.0.13 I must be doing something wrong - I am trying to do a mysql dump and it keeps yelling that tables dont exist whenever I put a where clause in.. it runs fine when I leave the where clause off - any help here? mysqldump -u root -p hotswap EmailDatabase_k EmailMess

Re: mysqldump WHERE clause

On Thu, 3 Jun 2004 11:54 , McKeever Chris <[EMAIL PROTECTED]> sent: >MYSQL 4.0.13 > >I must be doing something wrong - I am trying to do a mysql dump and it keeps yelling >that tables dont exist whenever I put a where clause in.. >it runs fine when I leave the where clause off - any help here?

Re: MySQL Warning Messages - Continued..

I believe this means mysql found fewer columns in each row of your infile than are defined in your table. Michael Mauricio Pellegrini wrote: Hi again, Thanks to all your kind answers, I've found the Warning Text is as Follows Warning|1260|Record count is fewer than the column cou

Re: Tuning MySQL 4.0.20 for large full table scans

On 2004.06.03, Dan Nelson <[EMAIL PROTECTED]> wrote: > > Consider multicolumn indexes; if you always "SELECT field1 from table > where field2=blah", creating an index on (field2,field1) will let mysql > bypass table lookups completely. Our typical queries look something like: SELECT level1, le

mysqldump WHERE clause

MYSQL 4.0.13 I must be doing something wrong - I am trying to do a mysql dump and it keeps yelling that tables dont exist whenever I put a where clause in.. it runs fine when I leave the where clause off - any help here? mysqldump -u root -p hotswap EmailDatabase_k EmailMessage_k "--where=Email

MySQL Warning Messages - Continued..

Hi again, Thanks to all your kind answers, I've found the Warning Text is as Follows Warning|1260|Record count is fewer than the column count at row 1 Warning|1260|Record count is fewer than the column count at row 2 Warning|1260|Record count is fewer than the column coun

Re: Tuning MySQL 4.0.20 for large full table scans

In the last episode (Jun 03), Dossy said: > The schema in question needs a redesign (dynamic row format, contains > two BLOB columns) but I was wondering if anyone has written up some > guidelines for general data warehouse configuration of MySQL 4.0 -- > Google has not turned up anything useful. >

Tuning MySQL 4.0.20 for large full table scans

The schema in question needs a redesign (dynamic row format, contains two BLOB columns) but I was wondering if anyone has written up some guidelines for general data warehouse configuration of MySQL 4.0 -- Google has not turned up anything useful. An example table has 2.1M rows and is 365MB in siz

Re: Does MySQL Daemonize?

In the last episode (Jun 03), Sp.Raja said: > Our software environment requires mysqld to be daemonized. (running > in nohup cannot help) Does mysqld support it? Or do we need to change > the source code to do it? Just run "safe_mysqld &", or place the mysql.server script in your system's rc.d dir

Does MySQL Daemonize?

Our software environment requires mysqld to be daemonized. (running in nohup cannot help) Does mysqld support it? Or do we need to change the source code to do it? Thanks, Sp.Raja -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mys

Re[2]: My question is too idiot for nobody answer?

On Thursday, June 3, 2004, 8:14:00 AM, Victor wrote: VP> If you choose to copy the files I would ensure that you are getting the VP> innodb binary logs as well if they do not exists in the mysql data VP> directory. The innodb backup tool or even mysqldump may provide a more VP> consistent snapshot

Re: Codes for U.S. Counties

David, I would recommend you check out the US Census, the USGS, and the USPS. All of those organizations have to deal with county-level information on a daily basis. If anyone has publicly available data (which would include the county codes you seek), they would. You should be able to get to e

RE: JOINing complication, help please

(To the esteemed members of the MySQL mailing list, my sincere apologies for the length of this post-- SG) Luc, You are killing yourself with all of those decisions. Take this for example: , IF( CONTACT_X_CUSTOMER.ID_ADDRESS > 0 , IF( CONTACT_X_CUSTOMER_ADDRESS.AddrLine2

Re: RES: How to retrieve MySQL Warning Messages

Mauricio, When I had a similar problem, I located it by using MS Excel to compare the original csv file to the results of a SELECT * INTO OUTFILE csv file of the MySQL data. The Excel formula I used was " =a1=ab1 ", where "a1" and "ab1" are the two cells you want to compare. I found it to be

Re: Self-Join Query

In article <[EMAIL PROTECTED]>, "James KATARSKI" <[EMAIL PROTECTED]> writes: > I'm trying to generate a report like this: (Which I've done in TWO > querys, the copied and pasted together) > +-+--+--+ > | Page Name | Internal | External | > +-+--+-

Re: Self-Join Query

You may want to forget all those joins and filters to create two columns, which is probably making MySQL do multiple full table scans. It sounds like what you are really looking for is to separate your hits into 2 columns based on the ip address, and perhaps put a filter on the hit time or page

RES: How to retrieve MySQL Warning Messages

Hello Mauricio, I tested in version 4.1.0 and not function. Only in version 4.1.1, according to text below extracted from MySQL manual: Note that the framework for warnings was added in MySQL 4.1.0, at which point many statements did not generate warnings. In 4.1.1, the situation is much improved

RE: How to retrieve MySQL Warning Messages

You need version 4.1.x and greater. Then issue SHOW WARNINGS after the statement that generated the warnings. -Original Message- From: Mauricio Pellegrini To: MySql List Sent: 6/3/04 11:20 AM Subject: How to retrieve MySQL Warning Messages Hi, Mysql 4.018 , SuSE 8.2. I'm using

How to retrieve MySQL Warning Messages

Hi, Mysql 4.018 , SuSE 8.2. I'm using LOAD DATA LOCAL INFILE "//.txt" INTO TABLE zz_zzz ; and I get the following message Query OK, 158063 rows affected (1 min 36.49 sec) Records: 158063 Deleted: 0 Skipped: 0 Warnings: 158115 Nothing seems to be wrong with the

RE: My question is too idiot for nobody answer?

If you choose to copy the files I would ensure that you are getting the innodb binary logs as well if they do not exists in the mysql data directory. The innodb backup tool or even mysqldump may provide a more consistent snapshot. ... If you restore to the master and you want to ensure a replicatio

RE: Unicode characters become question marks

Are you characters being escaped before being stored? \u? -Original Message- From: Silvio Lopes de Oliveira To: Victor Pendleton; James Huang ; [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: 6/2/04 6:24 PM Subject: RE: Unicode characters become question marks You know, now I'm sure that th

My question is too idiot for nobody answer?

> -Mensagem original- > De: Renato Cramer > Enviada em: quarta-feira, 2 de junho de 2004 11:07 > Para: Lista MySQL (E-mail) > Assunto: Restore from Backup done with Replication features > > Dear Friends, > > Considering what a backup is done with the method following: >

Re: Exporting/Importing Databases

David Blomstrom <[EMAIL PROTECTED]> wrote: > --- "Robert A. Rosenberg" <[EMAIL PROTECTED]> wrote: >> At 20:36 -0700 on 06/02/2004, David Blomstrom wrote >> about >> Exporting/Importing Databases: >> >> >Third, my practice database includes half a dozen >> >tables, but only one made it online, fol