 | | | MySQL General | | Hi all
I 've inherited a PHP app that uses a MySQL database. The following query
is extremely slow and I 've been battling for a couple of days on an off
to try and get a combination of indexes to o
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 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 cGuys 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
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(lpaHi
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 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 moHi.
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
valueHello
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 InnoDBHello
sorry if this is not the right mailing list to ask this question hope someone
can point me to a better list in the case.
My problem is that I 'd like to use mysql as database for storing userDear all
Right Now I am having different kind of problem in mysql
server . mysqld service automatically goes off . when we open a website and
enter something to search from mysql datab
On Thu 2007-11-08 at 17 56 -0800 Lucky Wijaya wrote
> Yes the trigger code is works. Many thanks !!
> Now I understand the use of delimiter command. Thanks again... )
>
> My next question is dHello members
I have two mysqld run on the same host (redhat linux OS with 2.4 kernel).
the two mysqld are in different versions one is 4.0.20 another is 5.0.45.
the mysql 4.0.20 uses /etc/my.cnf
hi all
right now i 'm trying to migrate from db2 running under linux to mysql v5.1.
i manage to export out the db2 structure & data into a del (ascii) file.
but when i try to load the data from thOn Nov 4 2007 3 19 PM David Campbell <dave@(protected) > wrote
>
> Grant Peel wrote
> > Hi all
> >
> > This is my first post to this list so bear with me if I ramble on a
> > bit. I have been readAt 02 18 PM 11/6/2007 Richard Edward Horner wrote
>Hi
>
>I 'm working on a program that will run in the event that tables are
>crashed or corrupt. Can anyone recommend a good method for crashing my
Thanks Russell for your help.
My user 'usuario1 ' did have the host 'localhost ' asigned.
It was kind of weird I couldn 't enter back then. But today days after and
not even entering the server ... HI
*sql
in datawarehousing*
i was using the ETL tool INFORMATICA - version 6.2 . and i am creating a
TARGET TABLE manualHi
I 'm working on a program that will run in the event that tables are
crashed or corrupt. Can anyone recommend a good method for crashing my
tables or corrupting them so I have some test cases? I 'm
----- Original Message -----
From "Russell E Glaue " <rglaue@(protected) >
To <anebi@(protected) >
Cc <mysql@(protected) >
Sent Tuesday November 06 2007 8 55 PM
Subject Re Please help to solve
The mysql.sock location '/var/lib/mysql/mysql.sock ' attempted to be used by your
connecting client may be wrong.
linux$ ls -la /var/lib/mysql/mysql.sock
Does the file exist?
You say this is the somysql@(protected) wrote
> Baron Schwartz wrote
> > hi
> >
> > mysql@(protected) wrote
> > >
> > > GRANT SELECT INSERT UPDATE ON the_database.*
> > > - > TO the_user@(protected) IDENTIFIED BY 'thBaron Schwartz wrote
> hi
>
> mysql@(protected) wrote
> >
> > GRANT SELECT INSERT UPDATE ON the_database.*
> > - > TO the_user@(protected) IDENTIFIED BY 'the_password '
> > Query OK 0 rows affOn Tue 2007-11-06 at 09 32 -0600 hwigoda@(protected) wrote
> i believe you need to have root create the file /var/lib/mysql/mysql.sock
> and then make it readable and writable by the user that oYou guys are correct that is exactly what happened.
I must thing of this in the future.
At this moment I have a lot of other projects to take care that it is
eaiser for me to read the information i believe you need to have root create the file /var/lib/mysql/mysql.sock
and then make it readable and writable by the user that owns mysql.
You can make that same file owner by the user that runs m
I assume your collation on the database table 'city ' is utf8_general_ci
And also check the columns of the database table 'city ' to ensure they are also
utf8_general_ci.
The database its tables andHi i need of help for a serios problem.
We have installed mysql 5 and we are using InnoDB engine. OS is CentOS
5 x86.
Our problem is this.
We get this message in the log
ERROR 2002 (HY000) CRun this SQL Query
mysql > select Host User from user
Make sure the output has this record values
+-----------+----------+
| Host | User |
+-----------+----------+
| localhost | usuario1 |
--- mysql@(protected) wrote
> N?stor wrote
>
> I think you 'd best begin by normalising your
> database. Something along
> these lines
>
very true indeed that would save you major heada |
|
|
