> I'm running "MySQL 4.0.23-standard", and trying to create a stored
function.
> Am I doing something wrong, or can I not create a stored function in
4.0.23?
> What I want is a stored function to take an int from a column and alter it
> (mask off the low 16-bits).
>
> SQL-query :
> CREATE FUNCTION
Its pretty simple for me to audit my databases and see what ones are old,
and can be dropped or whatever, is there some way to get a list of users
that are not hooked into any databases, so I can delete those, since they
are no longer needed?
--
Mysql 4.0.18-standard
revoke all on *.* from 'deleteatanytime'@'localhost';
mysql> revoke all on *.* from 'deleteatanytime'@'localhost';
ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)
mysql> revoke all on *.* from [EMAIL PROTECTED];
ERROR 1045: Access denied for use
Thanks for your reply Gleb,
I understand that we can setup the binlogfile name in 'my.cnf' file, but
I am sure that there is no change in the 'my.cnf'.
The hostname program reports the machine name correctly i.e. foo.
Cheers,
Tedy
-Original Message-
From: Gleb Paharenko [mailto:[EM
Thanks for your reply Gleb,
I understand that we can setup the binlogfile name in 'my.cnf' file, but
I am sure that there is no change in the 'my.cnf'.
The hostname program reports the machine name correctly i.e. foo.
Cheers,
Tedy
-Original Message-
From: Gleb Paharenko [mailto:[EMAI
Start your day with Yahoo! - make it your home page From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: cannot create database
Description:
How to get the promt "mysql>"?
Usually i will follow the steps at the command prompt:
1.cd..
2.cd
I'm running "MySQL 4.0.23-standard", and trying to create a stored function.
Am I doing something wrong, or can I not create a stored function in 4.0.23?
What I want is a stored function to take an int from a column and alter it
(mask off the low 16-bits).
SQL-query :
CREATE FUNCTION hello(
s C
Clyde,
> Does anyone know of a straght forward approach to migrate a
> mysql(4.1.11) Schema to Oracle(9i release 2).
> Also, please provide any best practices.
Check out our database development IDE (running on Windows):
Database Workbench - works with Oracle, MySQL, Firebird,
InterBase and MS SQ
--- Partha Dutta <[EMAIL PROTECTED]> wrote:
> Nick Jones wrote:
>
> >--- "J.R. Bullington" <[EMAIL PROTECTED]>
> wrote:
> >
> >
> >
> >>Automatically populate??
> >>
> >>Not that _I_ know of, but of course there are
> those
> >>on this list that know
> >>much more than I.
> >>
> >>I do know
Here's a little heads-up, as you will need some XML coding to make it "look
right".
PLEASE NOTE: I'm an ASP programmer, so PHP is a little foreign to me. You
will need to do some conversion.
Here is the way to do it:
1) Define your recordset and connection strings.
2) Write PHP strings to add Co
Hi,
I'm running FreeBSD 5.4 on the system in question. It was
my understanding on newer Unixes that things like a call to gethostbyname(3)
would cause it to go against the nsdispatch(3) in libc and determine
what method to perform its various lookups. Right now its set to
read nsswitch.con
Nick Jones wrote:
--- "J.R. Bullington" <[EMAIL PROTECTED]> wrote:
Automatically populate??
Not that _I_ know of, but of course there are those
on this list that know
much more than I.
I do know that you can export the values into tab
delimited format and then
import it into Excel.
I t
Nick Jones <[EMAIL PROTECTED]> wrote on 09/01/2005 03:18:39 PM:
>
>
> --- "J.R. Bullington" <[EMAIL PROTECTED]> wrote:
>
> > Automatically populate??
> >
> > Not that _I_ know of, but of course there are those
> > on this list that know
> > much more than I.
> >
> > I do know that you can ex
--- "J.R. Bullington" <[EMAIL PROTECTED]> wrote:
> Automatically populate??
>
> Not that _I_ know of, but of course there are those
> on this list that know
> much more than I.
>
> I do know that you can export the values into tab
> delimited format and then
> import it into Excel.
>
> I thi
Vladimir,
>Is there any portable alternative to LIMIT? I'd like
>to create a portable PHP pager for a web site ...
No, there's not a 'super SQL' which all SQL engines understand. To hide
the details of LIMIT | TOP from your apps, you can write a PHP funcion
which applies or updates the appro
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Today mysql 4.1.8 has a segmentation fault (signal 11), and crashed.
In the process one table was left corrupted, when it started back up.
An application continued to call insert...select on the corrupted table
as it wasn't realized this happened.
S
Look at http://www.ispirer.com
It is free and very good tool to do it. I did it from Oracle to MySQL, but
you can do it from Mysql to oracle. Good luck!
-Original Message-
From: David Griffiths [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 01, 2005 2:17 PM
To: mysql@lists.mysql.co
Nick Jones wrote:
Does anyone know if it is possible to populate values
into an Excel spreadsheet from a MySQL database? Can I
do this directly in Excel or do I need to create an
external program to do the work (i.e. in VB).
Thanks
-Nick
__
Do You
Automatically populate??
Not that _I_ know of, but of course there are those on this list that know
much more than I.
I do know that you can export the values into tab delimited format and then
import it into Excel.
I think that you may want to do this via ASP or PHP. It would make life a
lot e
Hello,
I have 200-300 kb slow log daily with fulltext queries only :-( All
queries using fulltext indexes. I use huge mysql cofig (huge.cfg).
What can I change in the mysql configuration for better performance?
Sincerely,
Michael,
http://xoib.com/ http://3d2f.com/
http://qaix.com/ htt
Does anyone know if it is possible to populate values
into an Excel spreadsheet from a MySQL database? Can I
do this directly in Excel or do I need to create an
external program to do the work (i.e. in VB).
Thanks
-Nick
__
Do You Yahoo!?
Tired of sp
You need to talk to Oracle, or look on an Oracle mailing list. People
here are more concerned about migrating from Oracle to MySQL, rather
than the other way around.
There are probably lots of commercial tools out there that will do it
(and compared to your Oracle licensing costs, they are pro
Mayuran Yogarajah wrote:
Is it just me or are there no RPMS for x86 64bit? Does this mean I
am stuck using the 32bit version? This machine has 16gigs of ram
and the 32bit version won't be able to make use of all of it.
thanks,
M
Sorry Ignore this, Intel EM64T rpm works just fine.
M
--
MySQ
Is it just me or are there no RPMS for x86 64bit? Does this mean I
am stuck using the 32bit version? This machine has 16gigs of ram
and the 32bit version won't be able to make use of all of it.
thanks,
M
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscrib
Does anyone know of a straght forward approach to migrate a
mysql(4.1.11) Schema to Oracle(9i release 2).
Also, please provide any best practices.
Thanks in advance.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PR
Yah, I tested in SQL*Plus - one window could see inserts, updates and
deletes that had been committed in another window (in which a commit or
rollback had not been issued). I ran the test again - delete data from a
table in one window and commit the change, and a select in the other
window disp
Hey all,
Trying to upgrade MySQL from 3.23 to 4.0.16 on a new fedora core3
system.
I keep getting the following when I run the servers-standard rpm...
Preparing...###
[100%]
1:MySQL-server-standard ##
If you are NOT in autocommit mode, your connection (or the server, it
doesn't matter which) starts a transaction *when you issue your first
command*. Every command you issue on that connection is in that initial
transaction until you EXPLICITLY commit or rollback (or do something else
that comm
I believe you - I'm just a but surprised. I guess I had a singular view
of how a session should work based on Oracle. I would have expected that
until you execute SQL that requires a commit or a rollback, you wouldn't
be in a transaction. Unfortunately, if you have connections that are
read and
We are running mysql 4.1.13 on solaris 9 box. Everything was fine until
someone accidentally deleted the mysql directory where the application was
installed. I had to retrieve it from our backup tape. I then stopped and
started mysqld daemon. Please note that we had installed mysql with the
bin
I don't know how your OS does it or what you need to do to use it, but if
I have a file called HOSTS in my (c:\winnt\system32\drivers\etc\ directory
(each OS has a similar location for this file)) that contains a list of
hostname - IP address pairs then whenever I attempt to do a hostname
reso
Hi,
(Lets not get into top/bottom/mixed post discussions. :) )
I'm not sure why putting in hosts would make a difference.
Doesn't the --skip-name-resolve bypass any sort of name resolution,
be it /etc/hosts or resolver? Or are you telling me to change
nsswitch.conf from "hosts: f
(please, either top-post or bottom-post but don't mix it up)
One way to bypass a broken DNS server is to create complete HOSTS files on
your servers. That way you can keep using your hostnames but avoid the
problems of actual DNS server negotiations going sour as all hostname to
IP address tran
>
> Hello.
>
> Have a look here:
> http://dev.mysql.com/doc/mysql/en/dns.html
>
> You may want to start mysqld with the --skip-name-resolve option.
>
Hi,
Thanks for the reply. I did see that page before, but
I guess my bigger question is why if the DNS is broken/slow, why
does the e
dEeZAcK SweETtY <[EMAIL PROTECTED]> wrote on 09/01/2005 10:27:28
AM:
> __
> Do You Yahoo!?
> Tired of spam? Yahoo! Mail has the best spam protection around
> http://mail.yahoo.com From: [EMAIL PROTECTED]
> To: [EMAIL PROTECTED]
> Subject: cannot
MySQL on Palm.
It's possible? Anyone have just tried?
Any suggestion will be appreciated.
Paolo
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
dEeZAcK SweETtY wrote:
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Martijn Tonies wrote:
I wonder how I'll get a div-function in SQL?
I dunno, maybe by looking in the manual? From [1]:
Division:
mysql> SELECT 3/5;
-> 0.60
[1] http://dev.mysql.com/doc/mysql/en/arithmetic-functions.html
Gustav is looking for the DIV-function.
But it is there
|DIV|
Thanks, but that link is for 4.1.x and not for 4.0.x
Osvaldo Sommer
-Original Message-
From: Nuno Pereira [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 01, 2005 7:38 AM
To: Osvaldo Sommer
Cc: mysql@lists.mysql.com
Subject: Re: Upgrade from 4.0.12 to 4.0.25
Osvaldo Sommer wrote:
>
__Do You Yahoo!?Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: cannot create database
Description:
I have already set the path to c:\mysql\bin
<[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> "Shaun" <[EMAIL PROTECTED]> wrote on 09/01/2005 05:38:01 AM:
>
>
>> >> The corrected query should read:
>> >> SELECT m.name as month, YEAR(b.Booking_Start_Date) as year,
>> >> COUNT(b.Booking_ID) AS "Num_Bookings"
>> >> FROM monthList
"Vladimir B. Tsarkov" <[EMAIL PROTECTED]> wrote on 09/01/2005 06:16:12 AM:
> Hello!
>
> I've heard that LIMIT is a MySQL specific, and cannot be used in any
other
> DBMS. Is there any portable alternative to LIMIT? I'd like to create a
> portable PHP pager for a web site, but all the tutorials
JM <[EMAIL PROTECTED]> wrote on 09/01/2005 06:01:57 AM:
> Hi all,
>
>Ive read this link "http://dev.mysql.com/doc/mysql/en/gone-away.
> html" hoping
> this has something to do with the error...
>
>Ive already checked based on the page the list of roots of error
> to produce
> gone-awa
"Shaun" <[EMAIL PROTECTED]> wrote on 09/01/2005 05:38:01 AM:
> >> The corrected query should read:
> >> SELECT m.name as month, YEAR(b.Booking_Start_Date) as year,
> >> COUNT(b.Booking_ID) AS "Num_Bookings"
> >> FROM monthList m
> >> LEFT JOIN Bookings b
> >>ON m.id = MONTH(b.Booking_Star
David Griffiths wrote:
"No, with the default transaction isolation level, REPEATABLE READ,
that's how it is supposed to work. You've started a transaction in
Window B, so Window B is immune to changes made in Window A until you
finish the transaction in Window B. See the manual for details
h
Osvaldo Sommer wrote:
Hi List
I look up on the online manual for directions for this kind of upgrade
but i found nothing.
Is there something I have to do extra or the upgrade so smoth?
Osvaldo Sommer
See http://lists.mysql.com/mysql/186726
--
Nuno Pereira
--
MySQL General Mailing List
Fo
It does not seem fine to me, mysql seems to really get slow once you
break about the 3 gig myd size, or 1.5 gig myi size
not sure why, I've changed every setting, but nothing seems to help
Matt
Clyde Lewis wrote:
Matt,
Looking at how the database if currently configured, do you have any
su
Hi List
I look up on the online manual for directions for this kind of upgrade
but i found nothing.
Is there something I have to do extra or the upgrade so smoth?
Osvaldo Sommer
--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.344 / Virus Database: 267.10.
Hi,
what is the error in your error log ?
Does your server crash for every query it makes ? Or only some ?
Are you using the official binary from MySQL or the one used for you
distro vendor ?
Are you using UDF ?
... We need more inputs ;-)
2005/9/1, JM <[EMAIL PROTECTED]>:
> Hi all,
>
>
2005/9/1, Vladimir B. Tsarkov <[EMAIL PROTECTED]>:
> Hello!
>
> I've heard that LIMIT is a MySQL specific, and cannot be used in any other
> DBMS. Is there any portable alternative to LIMIT? I'd like to create a
> portable PHP pager for a web site, but all the tutorials that I've found,
> contain
Hi Pooly!
>> mysql> SELECT criterio, idSite
>> -> FROM dominios_propios_completos
>> -> WHERE criterio NOT IN (
>> -> SELECT criterio_pub
>> -> FROM sites_criterios
>> -> );
>> Empty set (0.05 sec)
>
> Do you have NULL values in sites_criterios.criterio_pub ?
Yes P
Vladimir B. Tsarkov wrote:
> Hello!
>
> I've heard that LIMIT is a MySQL specific, and cannot be used in any other
> DBMS. Is there any portable alternative to LIMIT? I'd like to create a
> portable PHP pager for a web site, but all the tutorials that I've found,
> contain solutions based on th
Hi,
> mysql> SELECT criterio, idSite
> -> FROM dominios_propios_completos
> -> WHERE criterio NOT IN (
> -> SELECT criterio_pub
> -> FROM sites_criterios
> -> );
> Empty set (0.05 sec)
>
Do you have NULL values in sites_criterios.criterio_pub ?
--
Pooly
Webzine Roc
Hello!
I've heard that LIMIT is a MySQL specific, and cannot be used in any other
DBMS. Is there any portable alternative to LIMIT? I'd like to create a
portable PHP pager for a web site, but all the tutorials that I've found,
contain solutions based on the LIMIT usage.
Thanks!
--
Good Luck
Hi all,
Ive read this link "http://dev.mysql.com/doc/mysql/en/gone-away.html";
hoping
this has something to do with the error...
Ive already checked based on the page the list of roots of error to
produce
gone-away.. w/c i hope leads to " Lost connection to MySQL server during
Hi Folks!
I have a problem with a subquery using MySQL 4.1.12 (Fedora Core 4). I
will include the SHOW CREATE TABLE for the two tables involved. Please,
forgive me if I include this information in my original language (Spanish)
but I wish to keep the field names as is to avoid any mistake.
Hello All,
I have a strange situation while doing Bulk upload (using LOAD DATA
FILE). I have a database which has 60 records, when I try to insert
1 more records it is taking around 50-55 seconds to complete the task
(I feel this is much higher than the normal timings). I notice a
""Shaun"" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
>
> <[EMAIL PROTECTED]> wrote in message
> news:[EMAIL PROTECTED]
>> "Shaun" <[EMAIL PROTECTED]> wrote on 08/31/2005 04:56:23 PM:
>>
>>>
>>> <[EMAIL PROTECTED]> wrote in message
>>>
>> news:[EMAIL PROTECTED]
>>> > "Shaun" <[EM
Hello.
Program options can be specified in different ways, check them
all. See:
http://dev.mysql.com/doc/mysql/en/program-options.html
What name does the hostname program reports?
"Tedy Aulia" <[EMAIL PROTECTED]> wrote:
>Hi All,
>
>I have found that the binlogfiles have changed
Hello.
> Yesterday I try to migrate a database from mysql version is '4.1.5-gamma' to
> mysql version 3.23.45 using mysqldump:
>.
> loki# mysqldump clasificados > /usr/backup/clasificados.sql
You should remove column and table options. Some o
"No, with the default transaction isolation level, REPEATABLE READ,
that's how it is supposed to work. You've started a transaction in
Window B, so Window B is immune to changes made in Window A until you
finish the transaction in Window B. See the manual for details
http://dev.mysql.com/doc
61 matches
Mail list logo
