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
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
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
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
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
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 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')
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
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)
>
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
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
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
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
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
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
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,
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
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
- 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.
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
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
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
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
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:
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
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
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
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,
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
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
> 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
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
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
[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
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.
-
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,
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
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
38 matches
Mail list logo
