Hi all,
Just a quick question here.
May I know how to get a result without heading in Mysql (like set heading
off in Oracle) ?
Thanks and regards,
Helen
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi!
Currently, I'm running 3.23.51 on Red Hat 7.1, and I'm contemplating
upgrading to MySQL 4.0, but I'm not sure what to expect. I don't know if
MySQL 4.0 is fully backwards-compatible with 3.23.x versions, or if
something is going to break if I upgrade.
What are the main advantages of
On 7 Aug 2003 at 9:47, woody at nfri dot com wrote:
While I don't know for sure, my guess is that it would have something
to do with 32 bit as the magic number, but also...being that this
won't become a problem until
mysql select from_unixtime(2147483647);
+---+
|
i've noticed that, when a thread sending data
an update is first locked then other select is locked
From: xuefer tinys [EMAIL PROTECTED]
To: [EMAIL PROTECTED], [EMAIL PROTECTED]
Subject: RE: 1 query lock all others query
Date: Fri, 08 Aug 2003 02:31:14 +0800
i've once noticed it
it has been 8 but
So does anyone else have any ideas what is going on here? Shall I
report this as a bug?
Did you post how you setup the servers to load the different my.cnf
files? Hopefully you don't have one at a default location.
Otherwise, it sounds like the config information is not properly set --
either
Ahhh...I see now. I'm still in MySQL 3.23.54. Thanks anyways!
-Original Message-
From: Cabanillas Dulanto, Ulises [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 07, 2003 2:52 PM
To: mysql
Subject: RE: order by question
I execute the SELECT and it works!. I have MySQL 4.0.4
* motorpsychkill
Ahhh...I see now. I'm still in MySQL 3.23.54. Thanks anyways!
It should work also in version 3.23.54... actually, it should work since
version 3.20.17:
URL: http://www.mysql.com/doc/en/News-3.20.17.html
--
Roger
--
MySQL General Mailing List
For list archives:
Hellu,
I want to transfer the structure of my InnoDb database to another mysql
server 3.23.
However, I don't seem to get this to work correctly as the tables are not
transfered in the correct order such that I get a bunch a foreign key
constraints.
Even if I use the MysqlPhp admin tool, Mysql
On Thu, Aug 07, 2003 at 10:27:38PM -0700, Steven Roussey wrote:
MyISAM performance is limited right now by a global lock in the key
cache. However, I believe there is work going on to fix that in the
4.1 tree.
Really? I thought it was going to be fixed in the 5.1 tree, which will
be
* motorpsychkill
SELECT * FROM kf_gallery WHERE gallery_id IN ( 3, 1, 2 ) ORDER BY ?
What I'm trying to do is get the results in the order specified
in the IN
clause, i.e. (3, 2, 1). Is this possible? (I'm having trouble searching
the mail archives). Thanks!
Use the FIELD()
Dear Sirs,
I can not start MySQL server.
More specifically, MySQL was running fine all the time since
installation. It stopped working after I used FmPro Migrator to convert
some File Maker databases to MySQL
It looks like mysqld has no access permissions to InnoDB and I do not
know how to
Dear all,
the MySQL Documentation Team is looking for native Arabic speakers on
this list who are interested in reviewing an Arabic translation of the
MySQL reference manual. Reviewers will receive our gratitude, and
will of course be mentioned in the credits section of the manual.
If you're
* Girish Agarwal
Hi All,
I have added the date column ( column name is
dolv ) in mysql as CHAR(10)
Then it is not a 'date column', but s string column... ;)
See the manual for a description of the different column types:
URL: http://www.mysql.com/doc/en/Column_types.html
URL:
PHPMyAdmin uses the LOAD DATA LOCAL INFILE command. Just remove the word
LOCAL and it should work fine.
-Original Message-
From: Mike At Spy [mailto:[EMAIL PROTECTED]
Sent: Friday, August 08, 2003 2:35 PM
To: [EMAIL PROTECTED]
Subject: mysql LOAD DATA INFILE
When I come across this
Hi,
I am a Sun solaris 5.6 user.
I do not have su or any other system permissions
We have PERL5.005 on the box
We do not have DBD::mysql
So I wanted to install that module into my private library.
Mysql server is on a remote unix box
So when I try to install the DBD::mysql module its
Oh and just a note. This solution won't work if you are uploading the file
to the server through the browser. You will need to put the file on the
server and adjust the commands PATH accordingly.
-Original Message-
From: Donald Tyler [mailto:[EMAIL PROTECTED]
Sent: Friday, August 08,
How can I see if a record was deleted from a database?
Jeff
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Ok, I know it WAS there because we have two similar tables that should
contain sister records. One table has a record the other doesn't so it
had to have been deleted. I need to find out WHEN it was deleted.
How do I create a log of record deletes?
If you keep the update log or the
Did you restart the server?
---Original Message-
--From: Robert Morgan [mailto:[EMAIL PROTECTED]
--Sent: Thursday, August 07, 2003 1:19 PM
--To: mysqllist
--Subject: upgrade
--
--Hi I am using mysql 3.23.54 that came bundled with RH9. I have tried
--updating to version 4.0 using the RPM
I am going to have to put MySQL on it's own box, and I am wondering what makes
the biggest difference with hardware.
I am hoping to set max_connections to 1000 at least (and I will probably use
at least 500 several times a day).
There are a few tables that are almost constantly running
Hi, I am running 4.0.14 on a FreeBSD 4.8-STABLE machine (upgraded to CVS
from last week) and I am having a problem. We run a fairly large website
using PHP so there is always many connections to the database. On 4.0.12
the cpu usage never shot to over 20% and ran extremely fast. After
upgrading to
I'm getting a syntaxt error when using
select avg( DISTINCT column) from table.
the code above is from the teach urself sql book.
i have mandrake 9.1 linux. here's exactly what's
happening:
mysql select avg(distinct prod_price) from Products;
ERROR 1064: You have an error in your SQL syntax.
On Thu, Aug 07, 2003 at 07:54:18AM +0100, Andy Smith wrote:
On Wed, Aug 06, 2003 at 07:00:33PM -0700, Steven Roussey wrote:
So does anyone else have any ideas what is going on here? Shall I
report this as a bug?
Did you post how you setup the servers to load the different my.cnf
I have a database of books that was originally created as a flat file.
Each record has a number of fields, including the authors name. I'm
trying to convert the database to something a little more efficient.
I've created a new table (called Authors) of unique authors names and
assigned each one
Nicos,
Actually, MySQL should be installed by an administrator, but it should
be executed by root, which would permit the writing to the tmp dir.
Meaning everytime you kick off MySQL server, you'll need to do so as
root. This is usually how I dow it:
cd /usr/local/mysql
sudo echo
sudo
Morten Gulbrandsen [EMAIL PROTECTED] wrote:
I think something is wrong with my administration,
Basically I get these messages,
ERROR 1005 at line 9: Can't create table '.\company\department.frm'
(errno: 150)
ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password:
YES)
Hi guys gals,
Tried to get an answer through the manual, but couldn't find one. So, is
there a way to do replication w/o stopping the master. The only way I
found up until now was to stop the master (in order to insure there are no
changes to the database), copy the database directory,
27 matches
Mail list logo