Hi there,
When i try to do the following in PHP I get errors. Is this not permitted or
is this due to a setting somewhere? Can i do only one SQL statement per call
to mysql_query?
$sql = CREATE TEMPORARY TABLE tmp
SELECT field1_index, field2_index FROM test_table WHERE field1_index = '1';
Edison Cneeden [EMAIL PROTECTED] wrote:
Hi there,
When i try to do the following in PHP I get errors. Is this not permitted or
is this due to a setting somewhere? Can i do only one SQL statement per call
to mysql_query?
Yes.
$sql = CREATE TEMPORARY TABLE tmp
SELECT field1_index,
As far as I'm aware, in php you can only do one statement per call.
Terry
--Original Message-
Hi there,
When i try to do the following in PHP I get errors. Is this not
permitted or is this due to a setting somewhere? Can i do only one SQL
statement per call to
The a, b, ... is applied to older versions which got a bugfix. E.g. if
the current version would be 3.23.44 and a bug is found in 3.23.33 which
is fixed, then 3.23.33 becomes 3.23.33a and so on.
Please note that normally bugs are only fixed in the latest version, so
you have to upgrade. However
Nick Keeling [EMAIL PROTECTED] wrote:
I am a MySQL newbie with a post installation problem. I have Linux Red
Hat 9 with MySQL 4.0. After installing MySQL, I can not for the life of
me get the mysql daemon to run. My installation directory is
/usr/local/mysql but it wants to open a database
renniw one [EMAIL PROTECTED] wrote:
Hi,
In the mysql documentation, a mysql name is said to consist of 'three
numbers and a suffix'. However, I have come across mysql versions such
3.23.56a, 4.0.12-nt and have read of versions like 3.23.33-log. The
documentation lists -alpha, -beta,
hi there,
I've tried to install mysql-3.23.55.tar.gz but failed. Firstly, I've
created directory /home/users/mysql and add group for mysql. Those are the
command that I've used previously:
shellgroupadd mtsqlid
shellmkdir /home/users
shelluseradd -d /home/users/mysql -s /bin/false -g mysqlid
You could add a column 'is_updated' and set it to 'Y' when it is
updated. But depends very much on what you want to achieve by it
/rudy
-Original Message-
From: Keith Hamilton [mailto:[EMAIL PROTECTED]
Sent: donderdag 10 juli 2003 18:39
To: MySQL
Subject: Pull updated Records without a
I am not sure if I fully understand your problem, but I think you have
to move the IS NULL to the LEFT JOIN condition.
Cheers
/rudy
SELECT distinct
useronline.uname,
penpals_fav.fav_user_id,
penpals_fav.ID,
penpals_privmsgs_block.blocked_id
FROM useronline,
FROM table1
LEFT JOIN table2 ON table1.column = table2.column
LEFT JOIN table3 ON table1.column = table3.column
-Original Message-
From: Krasimir_Slaveykov [mailto:[EMAIL PROTECTED]
Sent: donderdag 10 juli 2003 16:07
To: [EMAIL PROTECTED]
Subject: 2 or more LEFT JOIN?
Hello mysql,
If I
I have a MySQL Server in a Windows Box. How can I connect to the server
from another windows box using ODBC?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I am running Discus Message Board on MYSQL server version 3.23.55 all on
Windows 2K platform. Discus appears to be encrypting the user password
with, I think, Encrypt(password, saltcode) (calling the function in
MYSQL). When I run select encrypt(1); \g it just returns NULL. Any
ideas why and
Hi Rich,
How did the exam go ?
I did the core exam today (passed;-).
I found that the exam is hard (but fair) for beginners.
I can only suggest for anybody thinking about taking the exam to have a look
at some of the below topics:
LEFT and RIGHT JOIN
Converting nested queries /subselects
Case
http://www.mysql.com/products/myodbc/index.html
-Original Message-
From: Azrin Aris [mailto:[EMAIL PROTECTED]
Sent: vrijdag 11 juli 2003 12:15
To: [EMAIL PROTECTED]
Subject: How to connect o remote MySQL Database
I have a MySQL Server in a Windows Box. How can I connect to the server
Encrypt() using a system call to encrypt the string. So if your system
does not support crypt(), you are out of luck. Windows does not support
crypt().
How to get around this? Well, the best way to solve it is to install
linux on your PC. The easier one is to use another encrypting methods,
such
GREEN, Darren [EMAIL PROTECTED] wrote:
[-- text/plain, encoding 7bit, charset: US-ASCII, 48 lines --]
I am running Discus Message Board on MYSQL server version 3.23.55 all on
Windows 2K platform. Discus appears to be encrypting the user password
with, I think, Encrypt(password, saltcode)
Type the command
echo $PATH
You will see a set of semicolon delimited directory path names. Perhaps
something like
/usr/local/bin:/usr/bin:/bin:/usr/local/sbin:/usr/sbin:/sbin:/usr/X11R6/bin
The configure script is looking in each of these locations for an
acceptable C compiler. Either you do
I'm looking for an easy way to use mysql from user (no root, no mysql
system account) space. I don't want the user of my application to have
to use a password to connect to the database. I want to have multiple
databases to differentiate between programs.
Is libmysqld the way to go?
Is a separate
Hi Anton;
Thank you for the english reply. With your permission (I hope) I post it to
the mailing list. I know that there are some marvelous minds arround ;-)
Unfortunately I will not be a big help on this topic.
Best regards
Nils Valentin
Tokyo/Japan
2003 7 11 20:56:
Hi Nils,
I would
Compiling MySQL from the source tarball is not for linux newbies.
Get the RPMs.
root wrote:
hi there,
I've tried to install mysql-3.23.55.tar.gz but failed. Firstly, I've
created directory /home/users/mysql and add group for mysql. Those are the
command that I've used previously:
shellgroupadd
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 10, 2003 10:59 PM
To: C. Reeve; [EMAIL PROTECTED]
Subject: Re: What's up with this GATOR crap?
At 23:43 -0400 7/10/03, C. Reeve wrote:
Hi,
I have noticed recently that every time I go to the
I have the following problem :
I have been asked to redevelop a clients website which is written in PHP and
uses MySQL as the backend. This site is on a remote server so there is only
so much I can do with it.
They want me to move it to a Windows box in our office and convert the pages
to asp
Hi,
I am a new admin and I was recently ran into a problem -
When I execute the show processlist command I see locked( in state locked ) processes
and if I kill one all the other get locked and the db freezes.
When I kill all of them the problem is solved. This problem has been
probably one of the many replys you'll get on this, but
ORDER BY month(start_date)
assuming the column that has the date is start_date
On Thursday 10 July 2003 14:51, Mike At Spy wrote:
I am trying to create an order by in a select statement that takes a
standard 'date' column in a table and
If you cannot get file system access on the webserver, then you will
need to dump the contents of the tables into a text file with the
appropriate dump commands.
If the webserver has something like phpMyAdmin, you can use that to
easily create a text file that you can then import into your mysql
Hi Everyone,
I'm using PHPMyAdmin to set up the database for a website, and I am
trying to set up foreign keys between tables. I know that MySQL doesn't
enforce them, but I want them there as part of the schema anyway. I
tried executing the command to add the foreign key, it ran without any
Hi there. I am a rank amateur at this trying to make sense out of a heap (and growing)
of data.
I have a resultset with this structure:
nodatadate
1uytd1
1klhd2
1oiud3
2kjhd1
2kljhd2
2asdd3
that I wish to convert to this structure.
no
On Sat, Jul 12, 2003 at 01:11:41AM +1000, Phil Evans wrote:
Hi there. I am a rank amateur at this trying to make sense out of a heap (and
growing) of data.
I have a resultset with this structure:
nodatadate
1uytd1
1klhd2
1oiud3
2kjhd1
2kljh
Hi Brian,
You understand that (at present) you will need to use Innodb tables if you
want or already use Foreign key support ?
O.K , just making sure you didn't miss that.
I can give you only advice how to do it in the mysql command line client.
Please login to the mysql command line client
I checked the archives, so I think this is the proper list to post this
on. I'm not altogether sure, though, so if I'm mistaken feel free to, I
don't know, beat me up and throw me into a dark alley.
I recently purchased a virtually hosted account and set up a PHP4 and
MySQL(3.23) site. I had no
I am trying to automate importing fresh data every morning. i execute
mysql -h my-domain.com -P port -u user -ppassword database_to_use
mysql.sql
at a given time, and that appears to be working. The contents of
mysql.sql are
flush tables;
delete from a where id 0;
delete from b where id 0;
Hey all,
I've been experimenting with the best way to store a large (~100GB) of data for
retrieval. Essentially, I'm storing 9 variables for approximately 1,000,000 locations
a day for the last ten years. This can work out at around 4MB a variable a day - but
not all variables are always
We have loaded a very large dataset and received an error message stating that the key
file is full. How do you go about increasing the allowable size of the key file?
I assume by the key file the error message is referring to the .MYI file. Is this
correct?
Thank you for the help.
Carmine
Certainly datetime is the way to go. It takes up 8 bytes per row, as
opposed to 4 bytes for int. But, even if there are 10 million rows
(over 27 years of data), thats only a 4 MB difference.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Thursday, July
The whole point of gator is that the web site owner has no control of
this. There is nothing mysql.com webmaster can do about this. I think
they could sue GatorWare, but to what end. In the future, it's
important to take a innocent until proven guilty approach on this list.
-Original
In the last episode (Jul 11), Nicholas Elliott said:
I've been experimenting with the best way to store a large (~100GB)
of data for retrieval. Essentially, I'm storing 9 variables for
approximately 1,000,000 locations a day for the last ten years. This
can work out at around 4MB a variable a
Im having troubles getting the results I want... can someone suggest which way to go..
mysql 4.0
A
| 1 | |
| 1 | BAD |
| 2 | |
| 3 | BAD |
| 3 | |
| 4 | BAD |
| 5 | |
| 5 | BAD |
| 5 | BAD |
what I want is 5 results. If there is a NULL, then
Yes and think before you type, I may have to consider using another database.
That shows real maturity. First of all if you are really that important of a customer
and have the ability to influence your organizations database useage decisions, and if
this really angered you off that bad, then
My money is on that the person who is getting this gator crap has a a
peice of spyware installed on their machine (gator and/or savenow.exe). This
is an app that launches addware based on your surfing habits. I believe they
are the same people who were serving up the infamous X10 Camera adds.
My
Eva,
Thanx for your help. Still having an issue with this. I forgot to mention I am
running MySQL 4.0.13. Tried both of these statements:
INSERT INTO table2 (id,count,period_count,date) SELECT id as id1, count, (count -
(SELECT count FROM table2 WHERE id=id1 order by timestamp desc
limit
Phil Evans [EMAIL PROTECTED] wrote:
Hi there. I am a rank amateur at this trying to make sense out of a heap (and
growing) of data.
I have a resultset with this structure:
nodatadate
1uytd1
1klhd2
1oiud3
2kjhd1
2kljhd2
2asdd3
I opened mysql.sql in BBEdit and ran the Zap Gremlins command, and
there were 3+ Gremlins in front of every field name on that line. Upon
removal of the gremlins, it reads the file fine. Weird, no?
On Friday, July 11, 2003, at 09:32 AM, Chris McCue wrote:
I am trying to automate importing
Roy Walker [EMAIL PROTECTED] wrote:
Thanx for your help. Still having an issue with this. I forgot to mention I am
running MySQL 4.0.13. Tried both of these statements:
INSERT INTO table2 (id,count,period_count,date) SELECT id as id1, count, (count -
(SELECT count FROM table2 WHERE
That did it -- show table status lists the upper limit as approx 1TB now =].
I'm still curious about the InnoDB issues, but now at least I can avoid it
and work with the original plan!
Thanks,
Nick Elliott
- Original Message -
From: Dan Nelson [EMAIL PROTECTED]
To: Nicholas Elliott
I recently noticed that my MySQL server was getting about 3 connections every 2
seconds. Checking the error log I discovered that a user '[EMAIL PROTECTED]' was
trying to connect to the server over and over and over and failing each time. Curious
as to what this 'user' was trying to do, I
The MySQL manual section that discusses how to run multiple MySQL servers
on a single machine now includes information for Windows.
I'd appreciate it if people who try these instructions would report to
me any problems or things that seem unclear.
The instructions are here:
I disagree, even though I had my own share of problems in compiling 4.0.13.
The clue is in the error message
configure:error: no acceptable C compiler found in $PATH
It is very likely that if he typed
which cc or which gcc
the reply would come back
No cc (gcc) in ... (a list
Sorry about my previous post. I meant that reply for a different message.
Emile State
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I disagree, even though I had my own share of problems in compiling 4.0.13.
The clue is in the error message
configure:error: no acceptable C compiler found in $PATH
It is very likely that if he typed
which cc or which gcc
the reply would come back
No cc (gcc) in ... (a list
mysql-max-3.23.57-pc-linux-i686
I notice that slaves which never went out of sync are now doing so
regularly with the same traffic pattern. Since upgrading to 3.23.57 I've
notice a large increase in CPU utilization with the same configuration
as the previous version in production 3.23.54. Anyone
Hello
I have a following question:
I have a table with thousands of rows which i need to show in a String Grid ( I use
Borland Delphi with MyDac component which implements MySQL interface).
If i make a query
SELECT * FROM tbl WHERE col1=something,
it can cause retreival of 10,000 records
I am using 4.0.13, not 4.0.1. Good to know what was wrong with the
previous statement. How bout this one?
DROP TABLE IF EXISTS table_tmp;
CREATE TABLE table_tmp (
`id` varchar(12) NOT NULL default '0',
`count` mediumint(15) NOT NULL default '0',
`period_count` mediumint(15) NOT NULL
have a table
CREATE TABLE `pics2003` (
`ID` int(11) NOT NULL auto_increment,
`Title` varchar(255) NOT NULL default '',
`ShortDesc` text,
`LongDesc` text,
`Image` varchar(255) default NULL,
PRIMARY KEY (`ID`)
) TYPE=MyISAM;
and after a while someone wanted something that would always
On 11 Jul 2003 at 15:41, Ray wrote:
and after a while someone wanted something that would always be first
in the table when ordered, so i added the entry to it and edited the
id to be -1. now whenever anything is added to the table it gets an
id of 2147483647
how do i fix it so that it
Interesting!
After reading about gator via this email I ran
ad-aware on my laptop and it found gator.
Could it be that one of these emails had it in it?
No more gator on my machine
C U later gator :-)
---Original Message---
From: _Chris McKeever_ [EMAIL PROTECTED]
Sent: 07/11/03
Hello,
Is there a way to specify MyISAM for all tables in a given file rather
than having to specify it at the end of each table declaration. I think
this would make porting databases back and forth to MySQL somewhat easier
since including MyISAM as part of the table declaration is not
Hi,
I have a table PAYMENT which has 3 fields.. PaymentID,InvoiceID,Payment
PaymentID is th eprimary key. For each INvoiceID there can be more than one payment
but less than 6 payments.
PaymentIDInvoiceIDPayment
1123 23
2 123
At 14:17 11-07-2003 -0400, Charles Vos wrote:
After much trial and error I discovered that changing the line
QueryInterval=10 in the my.cnf file to QueryInterval=0 would fix this
problem, and kept the user from trying to log onto the server.
It is the WinMySQLAdmin tool.
--
Regards,
For
Hi MySQL Fans ;-)
I would like to list all courses with have less than lets say 10 participants.
Does anybody know how I would have to modify the code below to get this to
work ?
schedule_id is the course itself
SELECT schedule_id,count(schedule_id) FROM attendance WHERE
On Fri, 2003-07-11 at 13:41, Nils Valentin wrote:
Hi MySQL Fans ;-)
I would like to list all courses with have less than lets say 10 participants.
Does anybody know how I would have to modify the code below to get this to
work ?
schedule_id is the course itself
SELECT
Hi Brian,
thats fine. You can always convert between the different table formats. As
long as you know some rules there will be no data loss.
As mentioned at the present only innodb support foreign keys. That means that
converting a innodb table f.e to another table format should either give
Nils Valentin wrote:
I would like to list all courses with have less than lets say 10 participants.
Does anybody know how I would have to modify the code below to get this to
work ?
schedule_id is the course itself
SELECT schedule_id,count(schedule_id) FROM attendance WHERE
Hi John,
Thank you for the reponse. I tried that (I didnt post it here), but that gives
me the error
mysql SELECT schedule_id,count(schedule_id) AS ct FROM attendance WHERE ct10
GROUP BY schedule_id ;
ERROR 1054: Unknown column 'ct' in 'where clause'
Best regards
Nils Valentin
Tokyo/Japan
On Friday, July 11, 2003, at 05:26 PM, Nestor Florez wrote:
After reading about gator via this email I ran ad-aware on my laptop
and it found gator.
Could it be that one of these emails had it in it?
I got it when my son installed Kazaa. It seems Kazaa makes all their
money by selling
Aahhh Neil,
if you don't specify any table format than MySQL will automatically create the
table in MyISAM format.
Does that answer your question ?
Best regards
Nils Valentin
Tokyo/Japan
2003 7 12 06:41Neil Zanella :
Hello,
Is there a way to specify MyISAM for all tables in a given file
Hi Nestor,
excuse me for my words, but what you write is crap. MySQL does definitely NOT
include any software like Gator etc.
If Gator is on your PC than a person who is using your PC has knowingly or not
installed it. Gator comes very often with some free software, but certainly
not with
2003 7 12 01:30Roy Walker :
Eva,
Thanx for your help. Still having an issue with this. I forgot to mention
I am running MySQL 4.0.13. Tried both of these statements:
INSERT INTO table2 (id,count,period_count,date) SELECT id as id1, count,
(count - (SELECT count FROM table2 WHERE id=id1
Hi Carmine,
Whats the physical size of the .MYI file and which OS version ??
Best regards
Nils Valentin
Tokyo/Japan
2003 7 12 00:23Carmine Smedira :
We have loaded a very large dataset and received an error message stating
that the key file is full. How do you go about increasing the
Hi Nicholas,
How about storing the BLOBS outside of the DB and refering to them ?
Best regards
Nils Valentin
Tokyo/Japan
2003 7 12 00:06Nicholas Elliott :
Hey all,
I've been experimenting with the best way to store a large (~100GB) of data
for retrieval. Essentially, I'm storing 9
2003 7 12 10:55Nils Valentin :
Hi Bruce;
Thank you for the reply.
I passed the core exam but obviously its not enough ;-) Live and learn ;-)
Aeeh thats was supposed to be ... life and learn..
Perhaps somebody knows a good spellchecker for logical mistakes ?? ;-)
That would have immediately
Hi Bruce;
Thank you for the reply.
I passed the core exam but obviously its not enough ;-) Live and learn ;-)
Thank you very much for the reply.
Best regards
Nils Valentin
2003 7 12 10:20Bruce Feist :
Nils Valentin wrote:
I would like to list all courses with have less than lets say 10
Hi Bruce,
Thank you for the reply.
Just for the record the options order must be
SELECT schedule_id,count(schedule_id)
FROM attendance
GROUP BY schedule_id
HAVING count(schedule_id) 10;
(swapped GROUP BY and HAVING)
Best regards
Nils Valentin
Tokyo/Japan
2003 7 12 10:20Bruce Feist :
Nils,
Why don't you chill dude. Go have an Ice cream or a beer.
If you look at my email again, I said
Could it be that one of these emails had it in it?
I WAS JUST ASKING. That is permited, isn't it?
And on top of that Nils, let me tell you that I never said anything about downloading
I must have received via email somehow from someone. I get a lot of jokes from my
Colombian newsgroup.
I do not have any of those tools Kazaa or whatever.
I only use my machines for email and AMP and LAMP copding.
The last thing I installed on my laptop was mozilla the latest release.
I
Sorry Nils sent in hast.
(B
(B-Original Message-
(BFrom: Mike [mailto:[EMAIL PROTECTED]
(BSent: Friday, July 11, 2003 9:08 PM
(BTo: 'Nils Valentin'
(BSubject: RE: What's up with this GATOR crap? - HOWTO Clean it out
(B
(BI think the answers given are valid but I did not see
Hi Nestor,
Sorry I didn't mean to be rude actually. Its saturday morning here in Tokyo
so I guess the Beer is a bit to early for me. But I come back to the idea
later during the day ;-)
Best regards
Nils Valentin
Tokyo/Japan
2003 7 12 13:22Nestor Florez :
Nils,
Why don't you chill
76 matches
Mail list logo