MYISAM + Group By

Hello All, I have a MYISAM table (employment_summary) with over 6 Lac records. I use it to do fast keyword searches on employments and want to retrieve the results grouped by the executive. The executive table is also a huge INNODB table and has over 6 Lac records. If I do any join operations wit

innodb error

Recently, I got the following error. I found the solution to solve the problem by increasing the log file size. However, I want to know why this error will happen. I can't find the explanation for that error. Anyone can give me some information about the error? 070321 16:38:41 InnoDB: Starte

RE: Are there any tools to get "diff" (alter commands) between tow tables ?

> > > I wonder if there are any tools to do a "diff" between two tables > > > struture to result alter command to convert table A > > > structure to table B structure ? > > > > Yes, our tool "Database Workbench" includes a so-called > > "Schema Compare" tool which allows you to compare structures

RE: What does NOW() return: linux time or something else?

> -Original Message- > From: murthy gandikota [mailto:[EMAIL PROTECTED] > Sent: Wednesday, March 21, 2007 6:05 PM > To: mysql@lists.mysql.com > Subject: What does NOW() return: linux time or something else? > > Hi > I tried to look up the time functions specifically for the disparity >

Re: Rename of Table That Receives a High Volume of Reads

Great. That is the assumption under which I have been working. I was really hoping for confirmation. I appreciate it! Thanks for responding. Thanks, Paul Chris Comparini wrote: On Wednesday 21 March 2007 16:31, Paul J. Boyes wrote: Hello, I have a fairly sizeable aggregate tabl

Re: Rename of Table That Receives a High Volume of Reads

On Wednesday 21 March 2007 16:31, Paul J. Boyes wrote: > Hello, > > I have a fairly sizeable aggregate table that is built from a large > amount of data that is going to receive a large volume of reads. I am > looking at possibly using the rename to swap the table out regularly > with an updated on

Rename of Table That Receives a High Volume of Reads

Hello, I have a fairly sizeable aggregate table that is built from a large amount of data that is going to receive a large volume of reads. I am looking at possibly using the rename to swap the table out regularly with an updated one. Is this a viable solution for a table that experiences a l

What does NOW() return: linux time or something else?

Hi I tried to look up the time functions specifically for the disparity between NOW() and the linux time obtained with 'date'. Why are they different? How can I set the database time? Thanks Murthy - Looking for earth-friendly autos? Browse Top Cars

comparing storing engines

Hi, Is there somewhere a speed comparison between the storage engines that can be used in MySQL? Thank you. Octavian -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Functions and NULL with standard install

I don't see how to use this here, I will have to research the |/||/| select rpad(|IFNULL(|null, ''),5,'1'); |/||/| but this below works thank you SELECT RPAD(CASE WHEN NULL IS NULL THEN '' ELSE '2' END, 5, '1'); If you are using it on an actual field, you would replace the first NULL and t

RE: ORDER BY question

I think you can also do SELECT *, DATE_FORMAT(deadline, '%d-%m-%Y') AS deadline_f, Status + 0 AS sorted_grade FROM v_issue_project_task ORDER BY sorted_grade That way you do not have to change the code if you add a value t

Re: Functions and NULL with standard install

select rpad(|IFNULL(|null, ''),5,'1'); |/||/| [EMAIL PROTECTED] ha scritto: I am running a basic install of MySQL 5.0 with "strict mode" turned on I would like to use RPAD however at times a NULL var will be sent to the function. My goal is to have a function that will convert the NULL to a

Re: Functions and NULL with standard install

On 3/21/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: I am running a basic install of MySQL 5.0 with "strict mode" turned on I would like to use RPAD however at times a NULL var will be sent to the function. My goal is to have a function that will convert the NULL to a blank string to get th

Updates and Records Changed. Bug?

I think this is a bug in MySQL 5.1.16-beta (I'm using SUSE 10.2 Linux), but I can't find any information on it. When performing an update which doesn't change any rows, I get different results back depending on the declarations of the fields in the table. If a 'normal' NDB table is created

Functions and NULL with standard install

I am running a basic install of MySQL 5.0 with "strict mode" turned on I would like to use RPAD however at times a NULL var will be sent to the function. My goal is to have a function that will convert the NULL to a blank string to get the result of EXAMPLE3 if a NULL is returned. EXAMPLE 1

Re: Database creation question

You might try issueing a FLUSH PRIVILEGES command instead of restarting. This is supposed to be implicit when you use the GRANT statement. If you do a direct insert into the user table you have to issue this command. - Original Message - From: "Lopez, Denise" <[EMAIL PROTECTED]> To:

problems with replication when db is changed

Greetings, We have regular problems with mysql replication when there is a db change. This is mostly ALTER TABLE. The sync breaks and we either have to do the changes manually or either shut down the whole system for a new sync from zero. Is there a way to sync alter table commands on the f

Re: Creating Password & Username with phpMyAdmin

Ah, that does look like a better way. Thanks! Schalk Neethling <[EMAIL PROTECTED]> wrote: Hi David, Actually the way to do this would be as follows: When you have created a new database, click on the SQL tab and the use the following to create the user and password: GRANT ALL PRIVILEGES ON data

Re: Database creation question

In your conf file, please add : Previously create a temp directory [mysqld] tmpdir=/usr/local/mysql/temp Regards, Juan On 3/20/07, Lopez, Denise <[EMAIL PROTECTED]> wrote: That still didn't work. I think I just need to restart the mysql service. Denise Lopez UCLA Center for Digital Human

Re: ORDER BY question

Thanks, that is also a solution. Friend of mine pointed me to the following: SELECT *, DATE_FORMAT(deadline, '%d-%m-%Y') as deadline_f, CASE `status` WHEN 'not yet started' then 1 WHEN 'in progress' then 4 WHEN 'finished' then 5

Re: ORDER BY question

Hey Mike, Sounds like you would be better of with an ENUM of integers, e.g. ENUM(-1,1,2,3) where -1 stands for to be started, 1 for started and so on. To answer your question: ORDER BY `status` = 'to be started', `status` = 'started', `status` = 'finished', `status` = 'canceled' Mike van Hoo

ORDER BY question

Hello everybody, I got a small problem with ordering on en ENUM field. The values in this field are: - to be started - started - finished - canceled And i want to order on this field, but in the direction the are above here (and not alpabetically). Is that possible? - Mike -- Medusa, Media

Re: Creating Password & Username with phpMyAdmin

Hi David, Actually the way to do this would be as follows: When you have created a new database, click on the SQL tab and the use the following to create the user and password: GRANT ALL PRIVILEGES ON databasename.* TO [EMAIL PROTECTED] IDENTIFIED BY 'password' Hit the submit button and you