Re: tellme Timestamp

I apologize for this, But how exactly do I that? When I run a query that has a timestamp field, How can I query on just the date. Time stamp puts in the min, hour, and sec. All I need is the year, month, and day. SELECT * FROM table_name WHERE date = '2003-08-25'; - Original Message

Re: MySQL 3.23.54 + update

On Thu, 2003-08-21 at 20:21, Taylor Sittler wrote: > Is there any way to update table values based on values in another table? > > For instance, given: > > Table 1 (jobid, jobname) > Table 2 (person, jobid, jobname) > > could I update Table 2, setting jobname=Table1.jobname where > Table1.jobid

RE: Lots of FULLTEXT stuff (suggestions)

> Thanks for replying. Your posts that I've found when searching for > FULLTEXT information have had great ideas. :-) Searching millions of > posts efficiently and effectively isn't easy. :-( Heh. FULLTEXT does not scale very well once the files get bigger than your RAM. The redesign of the index

Re: mysql server crashes - high context switch rate - large 'merge' table

Johannes, InnoDB asserts because it has waited for a page to be read from a data file for > 600 seconds. I fixed a bug to 4.0.14 where a big index scan on an InnoDB table could cause this phenomenon. You can try upgrading to 4.0.14. If the problem is in the MERGE table, then InnoDB is innocent.

Re: mysql server crashes - high context switch rate - large 'merge' table

In message <[EMAIL PROTECTED]>, Johannes B. Ullrich <[EMAIL PROTECTED]> writes I am having problems with MySQL 4.0.12 on RedHat Advanced Server 2.1 using a dual Xeon with 8 GByte of RAM. I have a database collecting logs. Each day, a new table is created. In order to allow for queries across more

Raising Relevance

Dear MySQL developers: This is probably a little surprising for you -- getting a question like this from someone who is not a software developer. But, I saw that this list looked at a 'weighted average' question back in July of last year, and various other 'weighting' issues. Maybe people from th

Re: UPDATE based on value in another table

On Sat, 2003-08-23 at 22:19, Rajesh Kumar wrote: > Dan Jones unknowingly asked us: > > > UPDATE table1 SET table2ID = NULL WHERE table1.table2ID NOT FOUND IN > > table2.ID; > > > > The NOT FOUND IN isn't SQL, of course, but I'm not sure what should go > > there. > > In MySql, its 'NOT IN' > > a

Re: how to show all locks on a table?

At 03:49 PM 8/25/2003 +0300, Egor Egorov wrote: Bennett Haselton <[EMAIL PROTECTED]> wrote: > > I found a way to do this before, but I didn't write down how I did it, so I > don't remember it now. And I've searched http://www.mysql.com/doc/ in > vain. > > What's the command to show all current lo

Finding warnings/skips from mysqlimport

Hi, I'm importing ~2000 rows using mysqlimport with the following syntax: mysqlimport -d -v --ignore -u root -p[rootpw] [database] [tablename].txt Connecting to localhost Selecting database [database] Deleting the old data from table [tablename] Loading data from SERVER file: /[path]/[tablenam

Re: Optimize Question

In the last episode (Aug 25), Patrick Crowley said: > I'm running 3.23.52 locally, but I just noticed my production server > is running 4.0.12. > > Given the complexity of this query, should I use subqueries instead > of joins? Would that make any difference? The subquery equivalent to your joins

Re: simple query

* Pag > Imagine i have a table "phrases" with a field "ph" with > contents like these: > > - who was it > - who wasnt it > - no i didnt > - yes i was > - dont know who > > I want to make a SELECT that gives me only the entries that > have the word "who": >

Re: Multi-table query in one select - possible?

* Mike Morton > Runnint Mysql 3.23.47 > > I have the following two tables: > backorder_notification > ->product_code varchar > ->email varchar > ->date_added date > Products > ->code varchar > ->name varchar > ->other stuff that is not important > > Essencially - I want t

RE: simple query

Try "SELECT * FROM `phrases` WHERE ph like "%who%"; The percent symbol is the wildcard character for mysql queries HTH > -Original Message- > From: Pag [mailto:[EMAIL PROTECTED] > Sent: Monday, August 25, 2003 11:08 AM > To: [EMAIL PROTECTED] > Subject: simple query > > > > >

Re: Restricting user access to databases

you give the root user all privileges (see GRANT command) (but this should be set by default, anyway) and no (global) privileges (that is, 'usage') for other users. then you give the users only contents/structure related rights on their databases. did you try phpmyadmin for this yet? it's a bit

simple query

Imagine i have a table "phrases" with a field "ph" with contents like these: - who was it - who wasnt it - no i didnt - yes i was - dont know who I want to make a SELECT that gives me only the entries that have the word "who": Something like SELECT *

Re: Optimize Question

I'm running 3.23.52 locally, but I just noticed my production server is running 4.0.12. Given the complexity of this query, should I use subqueries instead of joins? Would that make any difference? Best, Patrick > What version of mysql is this? If you're running 3.23, does 4.0.14 do the > same

Re: Optimize Question

In the last episode (Aug 25), Patrick Crowley said: > I just tried that, but with mixed results. > > Like before, when I added an index on publish, I get a 'range' join, but > it's still doing filesort. > > > | theater | range | status_publish | 1 | NULL | 4279 | where used; Using filesort > > A

Multi-table query in one select - possible?

Runnint Mysql 3.23.47 I have the following two tables: backorder_notification ->product_code varchar ->email varchar ->date_added date Products ->code varchar ->name varchar ->other stuff that is not important Essencially - I want to get a count of the product codes that a

Re: MySQL 3.23.54 + update

Is there any way to update table values based on values in another table? For instance, given: Table 1 (jobid, jobname) Table 2 (person, jobid, jobname) could I update Table 2, setting jobname=Table1.jobname where Table1.jobid=Table.jobid? Is it possible to do this in one SQL command, so that

Re: Optimize Question

I just tried that, but with mixed results. Like before, when I added an index on publish, I get a 'range' join, but it's still doing filesort. > | theater | range | status_publish | 1 | NULL | 4279 | where used; Using filesort Any way around that? Best, Patrick > An index on t (publish,photo,n

Restricting user access to databases

Just wondering, how do I limit a user to one database but let the administrator have universal access? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Optimize Question

In the last episode (Aug 25), Patrick Crowley said: > Hi all! > > I'm trying to optimize the statement below, but I can't figure out why this > query is still doing an ALL join with a filesort. > > There are several indexes on both my main table ('t'), and all the tables > I'm trying to join. (I

Optimize Question

Hi all! I'm trying to optimize the statement below, but I can't figure out why this query is still doing an ALL join with a filesort. There are several indexes on both my main table ('t'), and all the tables I'm trying to join. (I also tried adding an index for t.publish, which bumped my join typ

Upgrade from 3.23 to 4 in Linux

Hi, I have an installation of MySQL 3.23 located in /usr/local/mysql.3.23.51, which is working perfectly. Now I installed in /usr/local/mysql.4.0.14 the binaries for a new version (4.0.14 of course), and don't know how to start using it instead of the older one. I have a link: /usr/local/mysq

RE: Master-Slave Replication

Got it to work after the restart. Now works fine. SO now back to the Master-Master replication Dathan Vance Pattishall <[EMAIL PROTECTED]> wrote: Type show slave status to figure out what the problem is on the slave. Type show full processlist on the master to see if the slave is connecte

Re: pswd hlp!!!!

"Silent Bob" <[EMAIL PROTECTED]> wrote: > > I need to change my mysql password but don't know how to do it! My server crashed > because of power failure and when I turn it on the MySQL service won't start. It > only says " > > "Starting MySQL ServerYou are required to change your password immed

pswd help

Hello I need to change my mysql password but don't know how to do it! My server crashed because of power failure and when I turn it on the MySQL service won't start. It only says " "Starting MySQL ServerYou are required to change your password immediately (password aged)" I don't know how to cha

mysql server crashes - high context switch rate - large 'merge' table

I am having problems with MySQL 4.0.12 on RedHat Advanced Server 2.1 using a dual Xeon with 8 GByte of RAM. I have a database collecting logs. Each day, a new table is created. In order to allow for queries across more than one day, I use 'MERGE' tables. Each individual table contains 10-30 Milli

RE: "union" question

One more thing: the question isn't "how to solve the problem" - becouse it's very easy, but "wy it's working on 4.0.14 and not on 4.1.0". > -Original Message- > From: Marek Lewczyk [mailto:[EMAIL PROTECTED] > Sent: Monday, August 25, 2003 4:15 PM > To: [EMAIL PROTECTED] > Subject: "union"

pswd hlp!!!!

Hello I need to change my mysql password but don't know how to do it! My server crashed because of power failure and when I turn it on the MySQL service won't start. It only says " "Starting MySQL ServerYou are required to change your password immediately (password aged)" I don't know how to

Re: Difficulty with thai columns

John Francis Lee <[EMAIL PROTECTED]> wrote: > > I've downloaded 4.1 and am experimenting with a thai-english word list > to discover just how this will work with mysql. > > So far I'm not having success. > > First I tried > create table words ( > thai varchar(30) character set tis620, > tha

"union" question

Hello, Currently I'm testing my app using MySQL 4.1.0 version, and I have a strange error during execution a union query. (SELECT IF(_DAT.pri <=> null, null, ROUND(_DAT.pri/1.22)) AS pri_net, IF(_DAT.pri <=> null, null, ROUND(_DAT.price*1)) AS pri_gross, _DAT.cuid, _CUR.code FROM tab1 _DAT, tab2 _

OLAP Proposal for MySQL

Hi all, Please tell me if any of this makes sense. Any pointers to relevant projects/articles will be much appreciated. Philip Stoev http://www.stoev.org/pivot/manifest.htm === OLAP PROPOSAL FOR MYSQL The goal is to create an OLAP engine coupled with a presentat

Re: own privileges

[EMAIL PROTECTED] wrote: > Is there a way for a user to get knowledge about his own privileges? > For example can a user know if he/she has rights to INSERT INTO some table? > I'm using PHP4 > User can use SHOW GRANTS command: http://www.mysql.com/doc/en/SHOW_GRANTS.html -- For technic

Re: UPDATE based on value in another table

Dan Jones <[EMAIL PROTECTED]> wrote: > How do I update a table to remove orphaned references to a second > table? I've deleted rows in the second table, which has a unique > auto_increment key. The first table now has references to keys that no > longer exist. I need to update the first table, s

Explanation of multiple-column indexes

After some discussion in a separate thread, I've been trying to get a better understanding of the workings of multiple-column indexes, and think I'm still missing the point. I understand indexing (last_name, first_name) in that order if you'd always be searching last names and only be searching fi

Re: Version 3.x tables with a new 4.0.x engine

Yrj? M?enp?? <[EMAIL PROTECTED]> wrote: > > Can I expect newly upgraded MySQL 4.0.1x engine to > read my old version 3.x tables without trouble, so I can > optimize them after I have installed the the new engine. Yes. You should make database backup before upgrading in any case. > > I am using

Re: own privileges

SHOW GRANTS FOR [EMAIL PROTECTED]; It is important that the mix of username and hostname is the one which is specified in the privilege database. Please see the manual for details. show grants for [EMAIL PROTECTED]; +-

Re: utf8 support

"Li, John" <[EMAIL PROTECTED]> wrote: > > MySql 4.1 should have utf8 charset support, I downloaded the alpha version > but don't seem to have the utf8.xml file comes with it. > > Any one know how to get the needed charset support files? utf8 is a built in character set. -- For technical supp

RE: own privileges

[snip] Is there a way for a user to get knowledge about his own privileges? For example can a user know if he/she has rights to INSERT INTO some table? I'm using PHP4 [/snip] Of course! If they have access to a query on the mysql.user table they can see their permissions. -- MySQL General Mailing

Re: how to show all locks on a table?

Bennett Haselton <[EMAIL PROTECTED]> wrote: > > I found a way to do this before, but I didn't write down how I did it, so I > don't remember it now. And I've searched http://www.mysql.com/doc/ in > vain. > > What's the command to show all current locks on a database table? > There is no comm

own privileges

Is there a way for a user to get knowledge about his own privileges? For example can a user know if he/she has rights to INSERT INTO some table? I'm using PHP4 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: user types

- Original Message - From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: ???, 25 ? 2003 2:58 ?? Subject: Re: user types > 1.) > [EMAIL PROTECTED] > 2.) > [EMAIL PROTECTED] > 3.) > [EMAIL PROTECTED] > > No. 1 means user "root" at ALL servers, > No. 2 means user "root" at

Re: mysqlbinlog question

"Nils Valentin" <[EMAIL PROTECTED]> wrote: > Hi Victoria, > > 2003? 8? 21? ??? 20:20?Victoria Reznichenko : >> "Nils Valentin" <[EMAIL PROTECTED]> wrote: >> > 2003? 8? 21? ??? 16:09?Victoria Reznichenko : >> >> "Nils Valentin" <[EMAIL PROTECTED]> wrote: >> >> > This time I am using

Re: user types

Andrew, Andrew Simpson said: > [EMAIL PROTECTED] > [EMAIL PROTECTED] > [EMAIL PROTECTED] > > > can anyone tell me the difference between the above 3. These are for the > root user. > > i need to create a newuser and im not sure which of the above they are > supposed to have > > thanks > Your ques

Re: user types

1.) > [EMAIL PROTECTED] 2.) > [EMAIL PROTECTED] 3.) > [EMAIL PROTECTED] No. 1 means user "root" at ALL servers, No. 2 means user "root" at server localhost (127.0.0.1) via TCP/IP, No. 3 means user "root" at server www, and so on,. Is that clear to you? HTH, Jakob -- COMPUTERBILD 15/03: Premiu

Fw: PHP or Perl? (or Rebol via TCP/IP)

Hello Tim, Do've an example on using Rebol to connect to mySQL via TCP/IP? How do you do it? How do you execute SQL quieries? Return results etc ? Do you use some kind of "middleware" that your communicating to from Rebol via TCP/IP which gets the data for you? I'm actually a Delphi, Java, VB,

Re: Moving to version 4.1

Robert Mark Bram wrote: and Clients 3.23.55" and then in stall 4.1, how will my "MySQL ODBC 3.51 Driver" driver know to connect to 4.1 now? Is there anything else I need to do? If you also dumped and removed the database files then you probaply have to reinstall the 3.23.xx or an 4.0.xx to creat

user types

[EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED] can anyone tell me the difference between the above 3. These are for the root user. i need to create a newuser and im not sure which of the above they are supposed to have thanks

Re: Union and Order By give strange results in Mysql 4.0.13

Neculai Macarie wrote: >> To my observations constants in a column declaration limit the >> column width to just fit the initial constant. >> Your choice of values 'gallary' and 'gallery-categ' just masked that >> out ;-) > Yes, you are right. Based on your observation I was able to trick him > wit

Re: Lots of FULLTEXT stuff (suggestions)

My TODO List: 1. Speed More speed in inserts, deletes and selects. 2. Stoplist 1 stoplist for each index create fulltext index on x( y) stoplist 'mystop' the stoplist could be divided in section like my.cfg: [STOPWORD] [VARIABLES] ft_min_word_len=3 [CLASSES] ... [SPECIAL CHARS] ... The c

Re: Union and Order By give strange results in Mysql 4.0.13

> Neculai Macarie wrote: > [] > > select 'gallery' as table_name, d_image_small, d_image_big > > from gallery > > UNION > > select 'gallery_categ' as table_name, d_image, NULL > > from gallery_categ > > order by table_name; > [] > > select 'gallery' as table_name, d_image_small, d_image_big > > fr

Re: newbie > mysql table size?

On Mon, 25 Aug 2003 15:17:25 +0700 Alf Koswara <[EMAIL PROTECTED]> wrote: > Hi, > i read the mysql manual and it's explained the maximum table size in many > operating system, but i can't find the maximum size for MS window (win32), > what's the maximum table size for win32? > > My office want

Version 3.x tables with a new 4.0.x engine

Hi Can I expect newly upgraded MySQL 4.0.1x engine to read my old version 3.x tables without trouble, so I can optimize them after I have installed the the new engine. I am using MyISAM tables in both systems. thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysq

newbie > mysql table size?

Hi, i read the mysql manual and it's explained the maximum table size in many operating system, but i can't find the maximum size for MS window (win32), what's the maximum table size for win32? My office want to migrate the database server to mysql, and it's contains a millions record. Can mys

Re: utf8 support

* John Li > MySql 4.1 should have utf8 charset support, I downloaded the alpha version > but don't seem to have the utf8.xml file comes with it. > > Any one know how to get the needed charset support files? It looks like a bug. Try version 4.1.1. See e.g.:

Re: Lots of FULLTEXT stuff (suggestions)

Hi Steven, Thanks for replying. Your posts that I've found when searching for FULLTEXT information have had great ideas. :-) Searching millions of posts efficiently and effectively isn't easy. :-( Heh. Thinking about ft_min_word_len some more (and how I wish they'd lower the default), I don't re

Re: Re: Approved

Due to a dramatic increase in the volume of spam and virus-related messages received at this email address, this address has been disabled. Please resend your inquiry to the new address: [EMAIL PROTECTED] We apologize for any inconvenience this may have caused. High-Logic -- MySQL Genera

REPLICATION PROBLEM ON 4.0.14 (see prevoius e-mail)

When the 4.0.15 version will be avalaible ? The problem fo replication make impossible to install the .14 version and I came back to .13 release. Best regards Massimo -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

Re: How many records can a single MySql Table Hold.

On Mon, 25 Aug 2003 10:05:32 +0530 (IST) "Rupak Banerjee" <[EMAIL PROTECTED]> wrote: > > Hi, > I have a mysql database running on Mysql version 3.23.53 on a Red Hat > Linux 7.2. In the database there is a single table with over 150,000 > records. Unfortunately, the performance of that table is

Re: differance between InnoDB and MyISAM tables ?

Hi Nils Valentin, Thanks for the sincere efforts and valuable tips sanjay gupta - Original Message - From: "Nils Valentin" <[EMAIL PROTECTED]> To: "sanjay gupta" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Sunday, August 24, 2003 6:31 PM Subject: Re: differance

How many records can a single MySql Table Hold.

Hi, I have a mysql database running on Mysql version 3.23.53 on a Red Hat Linux 7.2. In the database there is a single table with over 150,000 records. Unfortunately, the performance of that table is very poor, comparing to other tables in the same database. Can somebody help me out. Thanks, R

Re: How many records can a single MySql Table Hold.

Hi Jeremy, Thankx for the solution..but can you please tell me how to increase the key buffer fo mysql ?? Its urgent...we are facing a lot of problems. Thankx once again for the solution. > On Fri, Aug 22, 2003 at 10:55:49AM +0530, Rupak Banerjee wrote: >> Hi, >> >> We are using MySql ve

Re: Replication from 2 Master

On Sun, Aug 24, 2003 at 02:45:01PM -0400, Eric Frazier wrote: > Hi, > > That makes a lot of sense, in fact we are using two servers as > "Masters" replicating to each other in a circle, but one has an > extra slave which is in our office. So in effect that does what this > guy was looking for, wit

Re: Upgrading 3.23->4.0 under WinXP ?

- Original Message - From: "Thomas Andersson" Sent: Saturday, August 23, 2003 8:15 AM Subject: Upgrading 3.23->4.0 under WinXP ? > Hi! > > I'm pretty green at this and I'm a bit clueless here, After reinstalling my > system I upgraded from 3.23 to 4.0 of MySQL, then I moved my old dbs in

Re: Replication from 2 Master

Hi, That makes a lot of sense, in fact we are using two servers as "Masters" replicating to each other in a circle, but one has an extra slave which is in our office. So in effect that does what this guy was looking for, without doing anything weird and strange. Thanks, Eric At 02:42 PM 8/2