Re: Synchronizing a remote database with a local database

Janek, Thanks for responding. I was really hoping to not have to go to any third parties and start a whole new learning curve. Is what I'm after really not possible with MySQL? -- Dave M G Ubuntu 6.10 Edgy Eft Kernel 2.6.20-5-generic Pentium D Dual Core Processor PHP 5, MySQL 5, Apache 2

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

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,

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

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: 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

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

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

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:

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

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

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 the

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: 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

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

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]

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

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

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 one. Is

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

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 between

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 and create a