Hi all,
I need a database that is able to handle french characters. I read the "Mysql
Reference Manual" and have done the following in a table to test the
different results but I wasn't successful which leads me to believe I am
doing something wrong... and yes, I'm a noob. ;)
CREATE TABLE comp
Hi,
I'm not that used to MySQL, yet. I wonder if it's possible to do the
following grouping with summery on a record set?
Tha records set looks as follows:
- type
- topic
- description
- time
Example of data:
Admin Email Email to customer A 0,25
Admin Email Email to customer B
Hello,
my question refers to the user "root" in MySQL 5.0.22.
Is the standard MySQL root user really required with the name "root" or can I
rename the root user for example to "myroot"?
Our software vendor affirms that MySQL need the User "root" always but I argue
the convers.
The application
Hi
No. MySQL doesn't insist on any 'root' user. If necessary you can rename
it. If you have the supervisor privileges, you can edit the same. Make
sure to Grant Permissions.
For instance: mysql> grant all on *.* to 'myroot'@localhost identified by
'myroot';
Thanks
ViSolve DB Team.
-
[EMAIL PROTECTED] schrieb:
Hello,
my question refers to the user "root" in MySQL 5.0.22.
Is the standard MySQL root user really required with the name "root" or can I rename the
root user for example to "myroot"?
Our software vendor affirms that MySQL need the User "root" always but I argue
Dear All:
I have a table T1 with these columns:
location - varchar
odd_even - varchar
I have a php page that is called from VC applications installed in 5
different locations (L1, L2, L3, L4 and L5). The page returns 0 or 1
depending on even call or odd call from each location. (1s
Hello list.
Can somebody tells what's wrong with this fuction?
DELIMITER $$
DROP FUNCTION IF EXISTS `qbit`.`myprice_xondr`$$
CREATE FUNCTION `qbit`.`myprice_xondr`(x float(7,2)) RETURNS float(7,2)
BEGIN
CASE x
WHEN x<50 THEN ceiling(x+x*0.25)
when x>=50 AND x<100 then ceiling(x
> Can somebody tells what's wrong with this fuction?
I guess that depends on what it should do, wouldn't it?
Martijn Tonies
Database Workbench - development tool for MySQL, and more!
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development ques
On Thursday 07 December 2006 10:09, Ed wrote:
> Hi all,
> I need a database that is able to handle french characters.
Sorry about that, it's probably due to my OS rather than MySQL.
$ echo "Fête"
Fête
$ touch Fête
$ ls -l
-rw-r--r-- 1 me me 0 Dec 7 14:20 F?te
$ rm Fête
Hmmm, ba
I need to write a query that joins 3 tables, a master with 2 detail tables
and I need to end up with 1 row per each row of the master table. The tables
are students, previous_institutions, and test_scores. So what I want is the
first previous institution and the average of the scores.
table st
Output of: show innodb status;
| InnoDB | |
=
061207 4:56:43 INNODB MONITOR OUTPUT
=
Per second averages calculated from the last 17 seconds
--
SEMAPHORES
--
OS WAIT ARRAY INFO: reservation count 11349,
On 12/7/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
Hello,
my question refers to the user "root" in MySQL 5.0.22.
Is the standard MySQL root user really required with the name "root" or can I rename the
root user for example to "myroot"?
No, it isn't required, you can rename it or simpl
I'm pretty sure that the only way to do this is to use an engine (such as
InnoDB) that supports transactions across multiple statements. You need some
global resource that is single-threaded, and unless you have something in a
file system somewhere that supports locking there I don't see any ready
Hello everyone,
We have a 4 CPU master server running the 5.0.27 RPM x86_64 version of
MySQL with a mix of InnoDB and MyISAM tables.
We normally run at 1500 queries/per second and lately, the server will
all of a sudden lock up and we are forced to restart mysql.
This is not related to higher l
Hi
I have this select:
SELECT tab1.field, tab2.field, tab3.field
FROM table
JOIN
JOIN
WHERE tab4.type=b
GROUP BY etc
ORDER BY etc
Now, the tab4 has three fields: id, color, type.
I want to select where type=b and to count all the occurrences of
color in the same query.
Example:
General duties of the position:
Responsible for independently performing the complex technical
operations/tasks or portions of the larger projects such as upgrading
database or writing code/scripts to resolve complex business
problems. Troubleshoot the technical issues by interfacing with
app
Hi,
Do you use MySQL with a NPTL or a linuxthread glibc configuration ?
Regards,
Jocelyn Fournier
www.mesdiscussions.net
> Hello everyone,
>
> We have a 4 CPU master server running the 5.0.27 RPM x86_64 version of
> MySQL with a mix of InnoDB and MyISAM tables.
>
> We normally run at 1500 qu
On Wednesday 06 December 2006 17:13, Ed Reed wrote:
> Can someone tell me if it is possible to create stored procedures with
> Query Browser and if it is can you provide an example the works?
>
> Thanks
Should just be "Script->Create Stored Procedure/Function", give it a name and
got at it. Only
On Thursday 07 December 2006 04:57, nikos wrote:
> WHEN x<50 THEN ceiling(x+x*0.25)
>
> when x>=50 AND x<100 then ceiling(x+x*0.20)
>
> when x>=100 AND x<150 then ceiling(x+x*0.15)
>
> when (x>=150 AND x<200) then (ceiling(x+x*0.10))
>
> when (x>=200) then (ceiling(x+x*0.09))
You've declared a ret
- Original Message -
From: "Daniel da Veiga" <[EMAIL PROTECTED]>
To:
Sent: Thursday, December 07, 2006 9:48 AM
Subject: Re: Renaming the root user - problems.
> On 12/7/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> > Hello,
> >
> > my question refers to the user "root" in MySQL 5.
Hello All,
I know this is little bit off-topic but I think users of this group
can give good advice on this topic.
We have a in-house built application using MySQL + PHP + Apache. It is
essentially a elaborate collection of online forms that will be used
for managing school scholarship in the 3r
Have you looked at ubuntu distribution of linux. I think they have a
'school' variant which might be close to what you need. Also, the people
there might be able to give you more help. Good luck.
On Thu, December 7, 2006 9:39, Saqib Ali said:
> Hello All,
>
> I know this is little bit off-topic
Another thought is - do you have backups running during this time?
Something that might be attempting to backup live the InnoDB files?
We had similar problems with MySQL and backup software a while ago,
though we used all-MyISAM.
Dan
On 12/7/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
Hi,
RAM too, how are you on RAM?
Obviously 100GB+ probably isn't going to fit in cache, but the usage pattern
during slower periods might be causing killer thrashing.
On Thu, Dec 07, 2006 at 12:43:17PM -0600, Dan Buettner wrote:
> Another thought is - do you have backups running during this time?
> S
No backups (like innodb-backup) running during these times.
We have 16GB of RAM and are currently using about 8GB of it.
We think we might have narrowed it down to a few hellish queries that
are hitting a few tables that we recently converted to InnoDB from
MyISAM. We're gonna convert them back
Kevin Old wrote:
> Hello everyone,
>
> We have a 4 CPU master server running the 5.0.27 RPM x86_64 version of
> MySQL with a mix of InnoDB and MyISAM tables.
>
> We normally run at 1500 queries/per second and lately, the server will
> all of a sudden lock up and we are forced to restart mysql.
T
Hey all
I would guess this would be a pretty simple question.
How do I select a row whose value for a given column is the greatest
or the least or whatever for that table?
e.g:
select * from table where creation_date > all_other_creation_dates;
Hope that makes some sense. Thanks in advance
It's actually pretty easy -
select * from table order by creation_date desc limit 1
Now one catch to this use of LIMIT is that you only get one row - even
if there are multiple rows that share the same greatest creation_date.
Sometimes that's acceptable, sometimes not.
Dan
On 12/7/06, Tim McI
At 03:10 PM 12/7/2006, Tim McIntyre wrote:
Hey all
I would guess this would be a pretty simple question.
How do I select a row whose value for a given column is the greatest
or the least or whatever for that table?
e.g:
select * from table where creation_date > all_other_creation_dates;
Hope
David Sparks wrote:
> I want to move 3 100GB .ibd files into a new DB.
>
> I followed the instructions here:
>
> http://dev.mysql.com/doc/refman/5.0/en/multiple-tablespaces.html
>
> But it doesn't work:
>
> mysql> alter table reports discard tablespace;
> Query OK, 0 rows affected (0.04 sec)
>
Can someone help me with this?
I have a text field that sometimes contains a number preceded with the
letter N. So it might look like this
A test N60
or
N45 someother text
or
This happened. N122, Then there was this.
I need to come up with a Select statement that can show me all the
On Thursday 07 December 2006 14:57, Ed Reed wrote:
> Can someone help me with this?
quick hack, but it works from what you've stated:
mysql> create table num_test (id SERIAL PRIMARY KEY, value VARCHAR(256));
Query OK, 0 rows affected (0.07 sec)
mysql> insert into num_test (value) VALUES ('N400')
Thanks for the quick reply Chris.
It's close but it's a little off. Your example also returns all
instances that where the letter N exists in another words as well
Do you know of a way to prevent that?
Thanks again
>>> Chris White <[EMAIL PROTECTED]> 12/7/06 3:11 PM >>>
On Thursday 07 Decemb
On Thursday 07 December 2006 16:34, Ed Reed wrote:
> Thanks for the quick reply Chris.
>
> It's close but it's a little off. Your example also returns all
> instances that where the letter N exists in another words as well
SELECT SUBSTRING(value,2) as value_num, value FROM num_test WHERE value
li
Hi,
I am new to MySQL, never used it before. I have basic knowledge of databases
and have used Oracle in the past, as far as writing SQL queries and
starting/shutting down the database instance.
I need to write server side scripts (php scripts) that communicate with
MySQL database.
I want to do
Eric, you'll likely want the community edition to get started with.
It's essentially the same software, at least for now, but community is
free whereas enterprise is cost (but includes support).
I've read good things about, and have just ordered, this:
MySQL Cookbook, 2nd edition
http://www.amazo
Thanks a lot Dan :).
I just started downloading the "Complete Install" package of Community
Server MySQL for Windows.
I'll look around the sites you mentioned and see if I can make sense out of
them.
Thanks again,
Eric.
On 12/8/06, Dan Buettner <[EMAIL PROTECTED]> wrote:
Eric, you'll likely w
Hi all,
Does any know command to rename the database name in Mysql db.
-
Find out what India is talking about on - Yahoo! Answers India
Send FREE SMS to your friend's mobile from Yahoo! Messenger Version 8. Get it
38 matches
Mail list logo
