LOL, look what I've got after posting
to one of the groups about my problem with
multiple JOIN query...Some kind of robot
reads one of them?
Original Message
From: [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
Precedence: bulk
Subject: Catalog listing
To: [EMAIL
robert_rowe wrote:
Issuing this command:
mysqlSET PASSWORD FOR 'root'@'localhost' = PASSWORD xx
set your password to xx
I'm not so sure. PASSWORD is a function which expects a string. The
correct syntax is
SET PASSWORD FOR 'root'@'localhost' = PASSWORD('new_password')
so I
Bob Terrell wrote:
on 1/2/04 12:59 PM, Adam i Agnieszka Gasiorowski FNORD wrote:
Thanks for the info. Just so I'm sure I know what I should: :)
Thanks for your answer, very helpful!
?
$suma = 0;
For starters, you won't need this line anymore. You'll see why in a minute.
Struggling to get an INSERT to work, can anyone help?
Here's my scenario:
Students[table]
Student_ID [primary key, auto-increment]
Student_name
Student_sex
Extra_Credit[table]
EC_ID [primary key, auto-increment]
Student_ID
Points
First: INSERT INTO
Bob Terrell wrote:
So there you go. Give it a shot and see if it runs any faster. If you need the time,
replace that first test in the WHERE clause with the one mentioned above. If this is
run often (or if it just takes a _really_ long time), put an index on the date
field, if one isn't
Hi,
Firstly, thanks for the reply.
I'm aware that MySQL requires that default values be constants without
reference to expressions that need to be evaluated and the fields in
question will never be updated - it's a set-once thing.
The reason I asked is due to the information in the MySQL manual
Hi,
Then: INSERT INTO Extra_Credit (Student_ID, Points) SELECT MAX(Student_ID)
from Students,
(1) ...VALUE ('25');
or
(2) ... '25' as Points;
I think this is your query:
INSERT INTO Extra_Credit(Student_ID, Points) SELECT MAX(Student_ID), '25' from Students
Take care,
Aleksandar
I have table with 7 fields. First field is id (auto increment). As I
understand the value should start from 0 and next value will auto
increment.
And I shouldn't add insert the value. So the insert
statemens below gives me an error. ERROR 1136:Column count doesn't match
value count at row 1
Hi guys,
I posted a similar question on this the other day but received no answers.
I'm running 5.0 and have a possible security/password problem. If i run from command
line all users work with or without passwords.
If I try and connect to mysql through php,perl,python or odbc with a user that
On 4 Jan 2004, at 15:09, Mike Mapsnac wrote:
I have table with 7 fields. First field is id (auto increment). As I
understand the value should start from 0 and next value will auto
increment.
And I shouldn't add insert the value. So the insert
statemens below gives me an error. ERROR
On Sun, 2004-01-04 at 08:09, Mike Mapsnac wrote:
I have table with 7 fields. First field is id (auto increment). As I
understand the value should start from 0 and next value will auto
increment.
And I shouldn't add insert the value. So the insert
statemens below gives me an error. ERROR
HI all,
I have two tables, let's say AudioTrack and Category
Every AudioTrack record can belong to one or more ( or none )
Categories.
I have created an intermediate table, AudioTracks_ Categories
containing only the IDs of AudioTrack and Category to keep track of the
link.
I can easily find
Thank you very much for the prompt reply.
Yes you were correct, it was the fact that the password had not been
entered at all...I did the
mysql -u root -p
when prompted for the password I just hit enter and was able to get in.
Now I have to figure out why its not accepting the password. I type
Hi Giulio
I think you could do this by repeatedly left-joining the categories
table as in this:
SELECT AudioTrack.*
FROM AudioTrack A
LEFT JOIN AudioTracks_Categories C1 ON A.AudioTrack_id=C1.AudioTrack_id
LEFT JOIN AudioTracks_Categories C2 ON A.AudioTrack_id=C2.AudioTrack_id
LEFT JOIN
I like naming the fields...
insert into product (
NumUsers,DataConnect,Type,NumRouters,NumSwitches,AvgServiceCallsWk ) values
( '456789','t1','new',2,2,10 )
I use php on a large web app that from time to time I have to add a field to
a table. If I use the above syntax instead of w/o field
try...
update user set password=PASSWORD('xx') where user='root' and
host='localhost';
(replacing the x's with the password)
Larry
-Original Message-
From: Don Matlock [mailto:[EMAIL PROTECTED]
Sent: Sunday, January 04, 2004 11:32 AM
To: [EMAIL PROTECTED]
Subject: RE: Help:)
Jamie:
I don't think your problem has anything to do with version 5.0 ... though
there have been some enhancements in security and user privs, the
fundamentals (IMHO) have not changed.
The problem is most likely with the application itself ... it needs to pass
the user ID and password, and the
you need a smeicolon at the end of the line
Don Matlock wrote:
Thank you very much for the prompt reply.
Yes you were correct, it was the fact that the password had not been
entered at all...I did the
mysql -u root -p
when prompted for the password I just hit enter and was able to get in.
Now I
(You forgot to post this to the list.)
Check to make sure you have the ID field set as autoincrement. By the
way, duplicate entry is not the same thing as column count not matching.
Also check to see if you have any other fields set as unique.
On Sun, 2004-01-04 at 09:12, Mike Mapsnac wrote:
I
Forwarded to the list for the benefit of all...
Begin forwarded message:
From: Mike Mapsnac [EMAIL PROTECTED]
Date: 4 January 2004 15:42:33 GMT
To: [EMAIL PROTECTED]
Subject: Re: insert: auto increment field
I use both metods and they works But when I make another insert I
receive a message
I have to disagree based on whats happening but I hope you can prove me
wrong.
(maybe I'm making some simple mistake and you can correct me very quickly
please look below)
For example
if I do - grant all privileges on *.* to [EMAIL PROTECTED]
identified by 'somenewpassword;
Thanks all for the help...thats what it was...the ;
Now I need to tighten up the security on it...I am going to install
phpmyadmin...
Don
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Password security was improved in version 4.1 by widening the password
field (from 16 bytes to over 40). This is documented in the manual
http://www.mysql.com/doc/en/Password_hashing.html. Clients compiled
to work with versions of mysql prior to 4.1 give the behavior you
describe when
Manually editing the user table as Larry describes will work, but is not
the preferred method. In particular, the new password set this way will
not take effect until you either FLUSH PRIVILEGES. Using SET, as Don is
trying to do, or GRANT will set the password and make it take effect
As I understand it, you don't really want the MAX(Student_ID), you want
the actual Student_ID of the last insert. It is important to note that
they are not necessarily the same. If you insert Student 24, then I
insert Student 25, then you check MAX(Student_ID), you will get 25, not
24.
Hi Michael,
Thanks for the reply and link my problem is solved also thanks to all others
who took the time to reply.
I shortened the password column in the user table as recommended by the
mysql doc and I can now connect as usual.
I feel silly for missing this but oh well live and learn I guess.
I've faced the same questions you raise here. Some things which occur
to me:
First, are you certain that 4.0.5a is working perfectly? A lot of
bugs have been fixed since then. Is it possible you just haven't seen them?
I would start by reading the change history in the manual
No-one out there doing step-by-step replay of binary logs ?
On Tue, 30 Dec 2003 17:52, Sam Vilain wrote;
Hi there,
Is there a utility out there to do transaction-at-a-time view and/or
replay with MySQL's binary log ? Primarily for audit / debug
purposes.
I'm only
I have a small single user database into which I wish to insert and extract
images.
From the manual this seems to work to insert the image
insert into images values(LOAD_FILE(/home/richard/scan.tiff));
but how do I get it back again?
I thought this might work but it doesn't
select * into
I'm scheduled to take the MySQL certification exam tomorrow morning,
thus currently intently cramming with the MySQL reference manual and
writing out study notes etc.
I'm not too worried as I've been using MySQL for years (although preping
for this has been a good exercise and I've learned a
Hi!
I am new in using mysql database server. I have installed MySQL Database
server on redhat advance server. But when I try to access the database
server using a the mysql client software for windows it gives an error Host
my IP Address is not allowed to connect to this MySQL Server.. How
I am designing an web based application using MySQL and Perl. Part of
the requirements include a somewhat complex scheduling module, which
must accommodate scheduling multiple human and physical resources across
multiple facilities. For example, medical patients will be scheduled
for one or more
what command are you using to connect to the server?
-Original Message-
From: Cres Justado [mailto:[EMAIL PROTECTED]
Sent: Sunday, January 04, 2004 3:43 PM
To: [EMAIL PROTECTED]
Subject: connecion error
Hi!
I am new in using mysql database server. I have installed MySQL Database
I got version 3.23.56 of mysql with my redhat installation as an rpm
package and now want to upgrade to the latest 4 version. My question is:
how I can upgrade my current installation myself without going through
the rpm package installer?
Thanks,
-Jalil
--
MySQL General Mailing List
For
It sounds like you need to set up your security permissions. See the section of the
manual on grant:
http://www.mysql.com/doc/en/GRANT.html
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I noticed you got a lot of feed back. Another site to take a look at for php
is www.codewalkers.com. They have some excellent tutorials. And as a forum
to ask questions in I would recommend www.phphelp.com. I have been to
sitepoint and it is a good site but I prefer these for my php development.
You need to select into dumpfile instead of outfile. See the section of the manual on
select syntax:
http://www.mysql.com/doc/en/SELECT.html
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
søndag 04. januar 2004, 22:45, skrev [EMAIL PROTECTED]:
I got version 3.23.56 of mysql with my redhat installation as an rpm
package and now want to upgrade to the latest 4 version. My question is:
how I can upgrade my current installation myself without going through
the rpm package
I am on suse 9.0.
using cpan perl module (perl -MCPAN -e shell)
and install DBD::mysql
obtained the following error:
An error occurred while linking the DBD::mysql
driver. The error message seems to indicate that you
dont have a libz.a or a libza.so
Can anybody suggest a possible fix?
I use both metods and they works But when I make another insert I receive a
message
ERROR: 1062 Duplicate entry '2147483647' for key 1.
Why id (primaty , and auto_increment) start from 2147483647 and not from 0
or 1
Thanks
From: Donald Henson [EMAIL PROTECTED]
To: MySQL List [EMAIL
Hi all,
I was able to get mysql up and running and installed phpBB to boot.
Upons reboot I noticed that the mysql daemon was timing out...when I log
into it this is the error I get:
[EMAIL PROTECTED] root]# mysql -u root -p
Enter password:
ERROR 2002: Can't connect to local MySQL server through
The error is just telling you the server isn't there. Is this RH?
If it is run..
#service mysqld restart
and see what messages you get if any and also check /var/log/mysqld.log and
see what messages it is giving. If it shows it started correctly, connect
from the command line before doing
Hello All,
Is there an equivalent to the nvl() function of Oracle available in MySql. I
am currently using version 4.1 alpha and am trying to execute the following
query:
Select count(nvl(col1,1)) as col1 from table1 group by col1;
Also, I tried to create a user defined function as below, but it
Is this a test db? If so go ahead and drop your records so there are none
in there and start entering them and checking their id as you do. After
dropping all records it should start back at 1 and increment forward. I
don't know how the index went up to max for that field. Perhaps something
I delete all records from the table and cannot insert second element to the
table. Auto increment starts with higher number ..
ERROR 1062: Duplicate entry '2147483647' for key 1
From: Larry Brown [EMAIL PROTECTED]
To: Mike Mapsnac [EMAIL PROTECTED],MySQL List
[EMAIL PROTECTED]
Subject: RE:
Larry Brown wrote:
Is this a test db? If so go ahead and drop your records so there are none
in there and start entering them and checking their id as you do. After
dropping all records it should start back at 1 and increment forward. I
don't know how the index went up to max for that field.
Hi,
Thanx for the prompt reply.
What I did is I told X not to start on boot, so I went into
/etc/inittab and told it to run at run level 3...thats when mysql
stopped all together. When I put it back to 5, mysql was running again,
but in the boot up sequence it says it timed out while
I am trying to install the DBI driver for mysql..i got an error which the INSTALL.html
file says can be fixed by:
If this is the case for you, install an RPM archive like libz-devel, libgz-devel,
zlib-devel or gzlib-devel or something similar.
Cam anybody clue me in on what the above
I have an access db with populated fields, some of them are date
fields. One is a created date and another is a updated date. I haven't
tried it yet, so I am not sure what I will get but I assume that if I
am asking MySQL to automatically update these fields rather than
manually have to fill
It solved the problem. But what truncate does? Just deletes the rows?
From: Daniel Kasak [EMAIL PROTECTED]
To: Larry Brown [EMAIL PROTECTED],Mike Mapsnac
[EMAIL PROTECTED], MySQL List [EMAIL PROTECTED]
Subject: Re: insert: auto increment field
Date: Mon, 05 Jan 2004 11:18:08 +1100
Mike Mapsnac wrote:
It solved the problem. But what truncate does? Just deletes the rows?
It's the same as doing:
drop table
create table ( schema from dropped table above )
--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
Matthew Stuart wrote:
I have an access db with populated fields, some of them are date
fields. One is a created date and another is a updated date. I haven't
tried it yet, so I am not sure what I will get but I assume that if I
am asking MySQL to automatically update these fields rather than
If you are using a myisam type which is default that log message isn't a
problem. By switching to run level 5 does it work again? I switch between
run levels on a regular basis so it shouldn't be the runlevel itself. Did
you add or remove any files from the rc3.d folder manually?
-Original
Your right, when I switch back to run level 5 it works...still spews out
an error..but it works and all I did was up2date before it all
started...there was a whole slew of updates that came in.
Don
-Original Message-
From: Larry Brown [mailto:[EMAIL PROTECTED]
Sent: Sunday, January 04,
Thanks.
Just for curiosity. Why truncate was necessary in my case? I just create a
table and try to insert some values.
From: Daniel Kasak [EMAIL PROTECTED]
To: Mike Mapsnac [EMAIL PROTECTED], [EMAIL PROTECTED],
[EMAIL PROTECTED]
Subject: Re: insert: auto increment field
Date: Mon, 05
If your MySQL field is date or datetime then MySQL will store whatever date your put
in the field. If you use a timestamp field then MySQL will set this field to the
current datetime on an insert or update unless you specifically set it to something.
See this section of the manual for more
What does nvl do? Here is a list of the functions from the MySQL manual:
http://www.mysql.com/doc/en/Function_Index.html
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Mike Mapsnac wrote:
Thanks.
Just for curiosity. Why truncate was necessary in my case? I just
create a table and try to insert some values.
Truncate is necessary because MySQL keeps track of autoincrement values
for each table. Simply deleting a record ( or all records ) has no
effect on the
I create two tables. And when I do
desc table_name;
NULL value can be 'Yes' or 'No'. What the difference when NULL value is
'Yes' or 'No
Thanks
_
Worried about inbox overload? Get MSN Extra Storage now!
On Jan 4, 2004, at 7:09 PM, Arun Natarajan wrote:
Is there an equivalent to the nvl() function of Oracle available in
MySql. I
am currently using version 4.1 alpha and am trying to execute the
following
query:
Select count(nvl(col1,1)) as col1 from table1 group by col1;
In MySQL, the function
I create two tables. And when I do
desc table_name;
NULL value can be 'Yes' or 'No'. What the difference when NULL value is 'Yes' or 'No
Not sure what you are asking, but if you have an ENUM column that can be Yes or No and
you do not set the column to NOT NULL then there are three possible
hi,
i have been using mysql-3.23.49a and now i want innodb support for the same
version of the database, can any one tell how should i proceed.
regards
--
Vinay Kumar
Software Engineer
Prologix Software Solutions Pvt. Ltd.
Lucknow-226016.India
Ph: +91(522)2721387. Res: 2702453.
Fax:
Aleksei Wolff wrote:
I am on suse 9.0.
using cpan perl module (perl -MCPAN -e shell)
and install DBD::mysql
obtained the following error:
An error occurred while linking the DBD::mysql
driver. The error message seems to indicate that you
dont have a libz.a or a libza.so
Can anybody suggest a
63 matches
Mail list logo