I am attempting to get a simple query working:
select *,MAX(a.teaching_date) as max, MIN(a.teaching_date) as min from
teaching a, topic_cat b where a.teaching_topic = b.topic_id or
a.teaching_topic = 999 group by a.teaching_topic order by a.teaching_date
DESC
This all works, except I don't want
James Sherwood wrote:
Hello,
Thanks for the info,
For the dump, I would imagine that it is latin1 as mysql 4.x is
defaulted to that I beleive.
Is there a way to dump it to utf8?
You can convert it using iconv:
http://climbtothestars.org/archives/2004/07/18/converting-mysql-database-conten
set header is sent out.
brian
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
__ NOD32 2644 (20071107) Information __
This message was checked by NOD32 antivirus system.
http://www.eset
cribe:
http://lists.mysql.com/[EMAIL PROTECTED]
__ NOD32 2644 (20071107) Information __
This message was checked by NOD32 antivirus system.
http://www.eset.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/
t through a browser, ensure that the
correct character set header is sent out.
brian
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
__ NOD32 2644 (20071107) Information __
This message was
James Sherwood wrote:
Hello,
We are trying to upgrade from 4.0 to 5 and we are not having any luck on
the character sets.
We need to use French characters for some things.
We have tried setting utf8 for everything we can find but the characters
still show all screwed up..
I have read the
Hello,
We are trying to upgrade from 4.0 to 5 and we are not having any luck on the
character sets.
We need to use French characters for some things.
We have tried setting utf8 for everything we can find but the characters
still show all screwed up..
I have read the manual regarding all th
Guys, just wanted to thank you again for helping me with
the sql statement that I needed. I was able to sorted using
php and I was able to display the correct result.
Thanks again!!1
Nestor :-)
On Nov 6, 2007 7:37 AM, Néstor <[EMAIL PROTECTED]> wrote:
> You guys are correct, that is exactly wh
My apologies, try this:
DELIMITER ;;
CREATE TRIGGER DEL_TB_INSTRUKSI AFTER DELETE ON Tb_Instruksi
FOR EACH ROW
BEGIN
DELETE FROM Tb_Stuffing WHERE No_Instruksi = OLD.No_Instruksi;
END;
;;
DELIMITER ;
To answer your question:
The DELIMITER statement tells MySQL to use a different set of
c
Marc
ERROR 1418 (HY000): This function has none of DETERMINISTIC, NO SQL, or
READS SQL DATA in its declaration and binary logging is enabled (you *might*
want to use the less safe log_bin_trust_function_creators variable)
It has to do with whether the fnc is deterministic and how its results m
DROP FUNCTION IF EXISTS secs_to_hrs;
DELIMITER |
create function secs_to_hrs (secs varchar(10))
returns varchar(13)
DETERMINISTIC
BEGIN
return CONCAT_WS(' h ',lpad(secs/60 div 60,3,' ') ,
CONCAT(lpad(round(secs/60 mod 60),2,' '),' mins') );
END;
|
DELIMITER ;
What if I wanted to not display mi
Try putting the data directory on a small partition and let it get filled 100%
with a single update that does not get fully committed due to disk full, then
turn the power off to the computer so there is no attempt for a nice shutdown.
You should also get a corruption in the master binary logs, if
At 05:22 PM 11/6/2007, you wrote:
Hi David,
Thanks for your reply. This helped greatly.
Yeah, I supposed I could just randomly flip bits in the MySQL files
and that would do the trick.
The program I'm writing does first attempt to repair the tables with
MySQL's utilities if they're MyISAM but
Your mysql server is either not running, or is not creating the sock file at the
location "/var/lib/mysql/mysql.sock" that calendar.php expects.
What do you get when you do this?
linux$ ls -la /var/lib/mysql/mysql.sock
look in the my.cnf file to find where the MySQL sock is written to, and modify
Hi
I'm working with mysql 5.0.24a-log trying to create a procedure as is
indicated at mysql web page
and i get the following error before "delimiter ;"
mysql> delimiter //
mysql> CREATE FUNCTION hello (s CHAR(20)) RETURNS CHAR(50)
-> RETURN CONCAT('Hello, ',s,'!');
-> //
Query OK, 0 ro
Hi Charles, all !
Charles Jardine wrote:
I am planning to set up a system in which mysql servers access
their data via NFS. [[...]]
If you want to use this for testing or development - fine.
If you want to run performance measurements on this - silly.
If you want to use it for "production"
Charles Jardine wrote:
I am planning to set up a system in which mysql servers access
their data via NFS. All the computers involved run Solaris 10.
NFS version 4 will be used.
I plan to ensure that no NFS share is ever mounted by more than
one client computer, and that no client computer ever r
I am planning to set up a system in which mysql servers access
their data via NFS. All the computers involved run Solaris 10.
NFS version 4 will be used.
I plan to ensure that no NFS share is ever mounted by more than
one client computer, and that no client computer ever runs more
than one mysql
Never tried it with version 3 only 4.1 but it has a --compatible switch
with a version 3.23 switch see command line --help so I assume the mysql
guys are allowing you to dump 3.23. Try dumping it without the switch as
you will be restoring to 5.0. The idea is to make sure the restore is
done us
> Make sure you use the mysqldump from version 5 and not version 3. Also
> recheck all your application queries once you have restored the data the
> list of changes SQL syntax might haunt you.
But can I use '/usr/local/mysql5/bin/mysqldump' to dump data of MySQL 3?
--
MySQL General Mailing List
Hi All
Make sure you use the mysqldump from version 5 and not version 3. Also
recheck all your application queries once you have restored the data the
list of changes SQL syntax might haunt you.
Mark
thomas Armstrong wrote:
Hi Tiago. Thank you very much for your answer.
I decided to mi
Hi Tiago. Thank you very much for your answer.
> > I decided to migrate to MySQL 5.0, and I've got some questions:
> > - I installed MySQL from sources on '/usr/local/mysql'. Is it as easy
> > as installing it again on '/usr/local/mysql5'?
>
> Yep. Just change the '--prefix' com './configure' time
On Wed, 2007-11-07 at 10:22 +0100, thomas Armstrong wrote:
> Hi.
Hello,
> Working on Linux, I've got installed MySQL 3.23.58, but I'm
> experiencing some problems. For instance, I suffer "too many
> connections" error but I cann't set 'max_connections' parameter to a
> value bigger than 250.
..
Hi.
Working on Linux, I've got installed MySQL 3.23.58, but I'm
experiencing some problems. For instance, I suffer "too many
connections" error but I cann't set 'max_connections' parameter to a
value bigger than 250.
I decided to migrate to MySQL 5.0, and I've got some questions:
- I installed My
Hello,
today I got this in my logs and mysql stopped working.
InnoDB: http://dev.mysql.com/doc/mysql/en/InnoDB_troubleshooting_datadict.html
InnoDB: how to resolve the issue.
071107 8:46:26 InnoDB: Flushing modified pages from the buffer pool...
071107 8:46:26 InnoDB: Started; log sequence nu
25 matches
Mail list logo
