hay guyz
im a bit stuck
first i couldnt get any user but root to log into mysql
on command prompt and myadmin
now i can ,et my user to log in through command prompt but i get this weired
error for myadmin
Error
MySQL said:
Access denied for user: '[EMAIL PROTECTED]' (Using password:
YES)
za
To test for NULL, you use the IS NULL comparison operator.
SELECT * FROM table_name WHERE col_name IS NULL;
See http://www.mysql.com/doc/en/Comparison_Operators.html in the manual
for more.
Michael
Miguel Ernesto wrote:
Now that I listen to you Michael, you must probably know how MySQL
refers
My first thought would be to create an empty table call it new_table set it
up like you want.
then
INSERT INTO new_table
SELECT n.*,a.data FROM normal n LEFT JOIN another a ON o.id=a.id
ORDER BY (n.id)
and then verify it got there, and drop the other tables and rename the
new_table to
normal tab
Bruce Dembecki wrote:
Hi! I'm struggling to understand how to fix the mysqld_safe script for an
OSX machine. If I run "mysql.server stop" then the mysqld process is killed
and mysqld_safe promptly starts it again. I know mysqld_safe is supposed to
start mysqld if it stops but I also know there are
Matt,
Thank you for the help and you are correct the index can't be utilized when using !=.
I will try
your hack/work around.
Thanks again.
sql,query
>Hi Heath,
>
>MySQL cannot use the trans_team query because you're using !=, for which
>an index is never used (currently anyway). Do you think
I have a table let's call it (old) containing items of interest
index field (id)
another field (data)
I want the data colum to move to a normalized table (normal) that
uses id as part of a multifield primary key. So I created a data
column in the normalized table. How can I now
ELEGANT
Hello,
I've searched the manuals and any websites I can find but am still at a loss
on how to calculate what I thought was going to be an easy 'Average' of Call
Times.
Situation. Have a table which is updated daily for users metrics and have
configured one column as TIME which should have the
Hi all:
There is a question:
Two tables:
table_out: ( fields ) product_name,out_count , out_date
table_in: ( fields ) product_name,in_count , in_date
I want to create a table that show the remain of product.
Can you help me??
thanks in advance!
--
MySQL G
Hi Heath,
MySQL cannot use the trans_team query because you're using !=, for which
an index is never used (currently anyway). Do you think that trans_team
is the best index that will find the least rows and produce the fastest
result? If so, you can try using the following, which can be optimized,
You cant have subqueries (select from where) in the where clause.
On Wed, 2003-10-08 at 15:00, Mark Wilson wrote:
> BTW, I tested the SELECT(MAX) part of this separately, and discovered that MySQL
> doesn't like the single quotes around the table name, so I took them out.
> Now THIS query works:
>
I have imported 1000s of records into a table and even spent some time
cleaning up characters which I messed up as I imported them (not the
fault of the DB layer, but the result of bringing things into a text
editor), but now I have the following problem.
I have a whole series of author and boo
Now that I listen to you Michael, you must probably know how MySQL
refers to NULL values on a logical sentence, e.g. If(something=NULL...)
How do I get TRUE on a logical sentence if I want to refer to it as If
it is NULL do...?
Thanks on advance,
Miguel Ernesto
-Mensaje original-
De: Mic
Try the following:
SELECT a.*
FROM artifacts a left join artifacts higher
on a.product_id = higher.product_id
and higher.plan_submission_number > a.plan_submission_number
WHERE a.product_id = '1'
AND higher.product_id is null;
For anyone following this, I'm using some sample code,
The query optimizer will not recognize an index on an innodb table. tranfer_logs is an
innodb
table, auth_user is not. As demonstrated below, trans_team is not even recognized as
a possible
key when EXPLAIN SELECT is used. (my apologies for the extra wide message). I am not
sure if this
is an i
I have installed Mysql 2.23.56 in Linux (Cobalt), but when it is started shows the
next messages in the ../var/*.err file:
mysqld started
/home/mysql/libexec/mysqld: File './dns1-bin.1' not found (Errcode: 13)
031008 15:18:16 Could not use dns1-bin for logging (error 13)
031008 15:18:16 /home/
Let's say I have the following table (t1):
++--++
| id | c1 | c2 |
++--++
| 1 | NULL | 1 |
| 2 | a| 1 |
| 3 | NULL | 2 |
| 4 | b| 2 |
| 5 | NULL | 3 |
| 6 | c| 3 |
| 7 | NULL | 4 |
++--++
I would like to delete all rows that c1 = NULL
I'm under the impression that your over thinking the problem.
LOOK-UP the functions DATE_SUB / INTERVAL / TIME_TO_SEC / TO_DAYS and
the arithmetic should be easy.
- Dathan Vance Pattishall
- Sr. Programmer and mySQL DBA for FriendFinder Inc.
- http://friendfinder.com/go/p40688
-->-Or
I have been using ODBC v3.51 to access MySQL DB's hosted by a RH v7.2 Linux VM for
select purposes from within an application script. They are normally imported in the
early morning.
I now have a need to Insert into a table from an application script. The insert works
when submitted through php
Hi all. I am needing to do a backup of two smalldatabases, both live on
the same server and under the same Mysql binary installation...
I would like to back them up, dump them into a file(s), make my move,
install the same database, and then restore/load this dumped
information
back into the new d
I installed 4.1.0 alpha from the RPMS on Redhat 9. I had to use
--force (or is it --nodeps, I can never remember) because MySQL wants
libcrypto and libssl 0.9.6 and Redhat 9 has 0.9.7. First question
(coming from that other world) why aren't these dependencies 0.9.6,
or
greater, instead of being
At 18:22 + 10/8/03, Croniser Brian Contr AFRL/IFGB wrote:
Here is the script that creates the database.
create table object_attrib (obj_record_id INTEGER(7) AUTO_INCREMENT NOT
NULL,
PRIMARY KEY (obj_record_id),
INDEX (rel_obj_int_id),
FOREIGN KEY (rel_obj_int_id)
REFERENC
Here is the script that creates the database.
create table object_attrib (obj_record_id INTEGER(7) AUTO_INCREMENT NOT
NULL,
PRIMARY KEY (obj_record_id),
INDEX (rel_obj_int_id),
FOREIGN KEY (rel_obj_int_id)
REFERENCES obj_id_internals (obj_int_id)
ON DELETE RESTRICT ON UP
We have a script that deletes records from a database that are over then
a certain date. We had no problem running the delete on 3.x, but on
4.0.14, we are having a problem.
Here is the command that does the delete:
$EXECPATH/mysql --host=hostname --user=blah --password=blah --execute="delete fr
I am learning the DBA ropes on a MySQL 4.0.14 database. I am working on
a backup strategy and I have a few questions. But first, a bit about the
database: we are collecting "messages" from a customer, storing them in
a table, then pushing the data to a master database. The messages are
inserts into
At 10:45 -0700 10/8/03, Bruce Dembecki wrote:
Hi! I'm struggling to understand how to fix the mysqld_safe script for an
OSX machine. If I run "mysql.server stop" then the mysqld process is killed
and mysqld_safe promptly starts it again. I know mysqld_safe is supposed to
start mysqld if it stops bu
Hi! I'm struggling to understand how to fix the mysqld_safe script for an
OSX machine. If I run "mysql.server stop" then the mysqld process is killed
and mysqld_safe promptly starts it again. I know mysqld_safe is supposed to
start mysqld if it stops but I also know there are times I need to work o
* [EMAIL PROTECTED]
> it seems that "time" gives the hour, minutes, seconds.
> is there a way to get tenths and hundreths?
> how about without hours?
Not as a data type, but see the DATE_FORMAT() function:
http://www.mysql.com/doc/en/Date_and_time_functions.html#IDX1333 >
> basically, i'm wantin
What machines are you working with at each end? Internal network?
-Original Message-
From: Nitin [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 08, 2003 10:19 AM
To: Andy Eastham; Mysql List
Subject: Re: how to export data from multiple tables
any idea, how to export data to a file
it seems that "time" gives the hour, minutes, seconds.
is there a way to get tenths and hundreths?
how about without hours?
basically, i'm wanting to store lap times for racing.
Steve
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.m
Subqueries don't show up until v4.1 which I have running on one of my servers. Runs
great and I have it into production.
--ja
On Wed, 8 Oct 2003, Rory McKinley wrote:
> Problem 1 : Your query contains a subquery :
> SELECT MAX( plan_submission_number )
> > FROM 'artifacts'
> > WHERE product_
any idea, how to export data to a file on the remote machine?
thanx for the help anyway
Nitin
- Original Message -
From: "Andy Eastham" <[EMAIL PROTECTED]>
To: "Mysql List" <[EMAIL PROTECTED]>
Sent: Tuesday, October 07, 2003 9:49 PM
Subject: RE: how to export data from multiple tables
Hi list,
I have the following problem and here is the message that displays the
console when I try to connect
"Warning: Can't create a new thread (errno 11). If you are not out of
available memory, you can consult the manual for a possible OS-dependent"
I'm using linux, Red Hat 7.3 Linux version 2
I think exp(number, number) will do the job.
Check the manual for the correct syntax.
Thanks
Emery
- Original Message -
From: "Bob Brands" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, October 08, 2003 11:16
Subject: Exponentiation operator
> What is the correct syntax f
Problem 1 : Your query contains a subquery :
SELECT MAX( plan_submission_number )
> FROM 'artifacts'
> WHERE product_id = '1' )
subqueries are (AFAIK) not supported in the latest production version of
MySQL (4.0.15) but are coming soon...might already be in a beta ver
Two possible solutions -
Michael Stassen wrote:
Cal Evans wrote:
or '' (empty string). You can change this behavior by building your own
mysql from source with the -DDONT_USE_DEFAULT_FIELDS compile option.
Thanks, I'm off to recompile my development server.
you should be able to define a field as NOT NULL without a de
On Wed, 2003-10-08 at 15:06, Mark Wilson wrote:
> Er, I _used_ a "basic SQL tutorial", which specifically said that this should
> work. The problem seems to be a limitation of MySQL, not general SQL operation.
> That being said, are there any clever one-query options (using JOINs, etc?) or
> is th
Er, I _used_ a "basic SQL tutorial", which specifically said that should work.
The problem seems to be a limitation of MySQL, not general SQL operation.
That being said, are there any clever one-query options (using JOINs, etc?) or
is this basically a 2-step process in MySQL?
--
Mark Wilson, Compu
Check out sqlyog. (www.sqlyog.com) It has a structure sync tool. After
making the first change, you could generate a script to make the change
to the next database and then take that script and parameterize it so
that a PHP script could use it to update all of your database.
HOWEVER,
A better
"Director General: NEFACOMP" <[EMAIL PROTECTED]> wrote:
> I use 4.0.14 and 4.1.0-Alpha
Hmm .. I have comp-err.exe in 4.0.14, but it's absent in 4.1.0.
>
>
> Thanks
> Emery
> - Original Message -
> From: "Egor Egorov" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Tuesday, October
I am running PHP/MySQL for a program that I am writing. We will have
100's or 1000's of databases that will be duplicates in structure. The
problem is when I make a change to the database, I have to go to every
database manually and make the change. All of the databases start with
"a_" and
BTW, I tested the SELECT(MAX) part of this separately, and discovered that MySQL
doesn't like the single quotes around the table name, so I took them out.
Now THIS query works:
SELECT MAX( plan_submission_number )
FROM artifacts
WHERE product_id = '1'
-- (returns '2')
But this one still doesn't:
) In MySQL we don't have subselect. this is not valid:
SELECT article, dealer, price
FROM shop s1
WHERE price=(SELECT MAX(s2.price)
FROM shop s2
WHERE s1.article = s2.article);
instead of this, in MySQL we can write:
CREATE TEMPORARY TABLE tmp (
"Arthur Maloney" <[EMAIL PROTECTED]> wrote:
>
> I have recently reformatted my hard disk and done
> a clean install of 4.0.15 on Win 2k Pro SP4.
>
> I used C:\> C:\mysql\bin\ mysqld --install
>
> This created a mySQL service and it works ok.
> I happened look at a log in the data folder
> and n
I have an app for which people can submit plans.
Each plan relates to a particular product.
A new plan can be submitted for the same product, so each plan has its own
submission number. (1,2,3...)
Each plan is composed of artifacts.
The (artifacts) table looks like this:
artifact_id INT
product_id
* Ciprian Trofin
> I have 2 tables: currencies and quotes
>
> currencies
> ==
> id currency
> -
>
> quotes
> ==
> id date id_currency value
> ---
> Index (date, id_currency - UNIQUE)
>
>
> In order to find the most recent value for a
I attached the output from "show slave status".
/Søren
-Original Message-
From: Dicky 'Mas Saint' [mailto:[EMAIL PROTECTED]
Sent: 8. oktober 2003 15:28
To: [EMAIL PROTECTED]
Subject: Re: Sudden error when replicationg - please help
Pada Wed, 8 Oct 2003 15:13:00 +0200
Søren Neigaard <[
No its Redhat, and i have made absolutly no updates :(
-Original Message-
From: Ben Edwards [mailto:[EMAIL PROTECTED]
Sent: 8. oktober 2003 15:23
To: Søren Neigaard
Cc: '[EMAIL PROTECTED]'
Subject: Re: Sudden error when replicationg - please help
you are not using Debian testing by any
Pada Wed, 8 Oct 2003 15:13:00 +0200
Søren Neigaard <[EMAIL PROTECTED]> menulis:
what was the "show slave status" output ?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
you are not using Debian testing by any chance? If so last time I did
an apt-get upgrade it broke mysql and I fixed it by doing a reinstall.
On Wed, 2003-10-08 at 14:13, Søren Neigaard wrote:
> I have a slave that has been running for a long time without any problems,
> but now its not replicatin
I have a slave that has been running for a long time without any problems,
but now its not replicating any more. So I tried to do a "LOAD DATA MASTER;"
which always gives me this error now:
Version: '4.0.15-standard-log' socket: '/var/lib/mysql/mysql.sock' port:
3306
031008 15:07:59 Slave I/O t
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
MySQL Connector/J 3.0.9, a new version of the Type-IV all-Java JDBC
driver for MySQL has been released.
It is now available in source and binary form from the Connector/J
download pages at http://www.mysql.com/downloads/api-jdbc-stable.html
and m
I'd hardly call it a war, more of a skirmish, if that. perhaps at best
it should be considered a Terrorist action, don't think it even gets up to
an "Act of Terror" which is good, because I don't want the American Jack
Boot of Opression on my back, thank you very much.
- Original Mess
One of the best things is to listen from diffrent opinions from different
people who have different backgrounds. :-)
cheers,
feng
- Original Message -
From: "DeBug" <[EMAIL PROTECTED]>
To: "Wang Feng" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Wednesday, October 08, 2003 9:42 PM
>> 1.) If you want to have an "easy way tool" for creating your reports -
>> use MS Access
Yep if you know Access
WF> -- Tools are for dummy users, Clever users create tools. --
Clever users select the best way they can do things for themselves
What is best depends on user knowledge and objective
Sorry about that, those were jokes to entertain you experts. I know you guys
work hard everyday, so just made some funs.
Now Stop! :-)
cheers,
feng
- Original Message -
From: "Andy Eastham" <[EMAIL PROTECTED]>
To: "Mysql List" <[EMAIL PROTECTED]>
Sent: Wednesday, October 08, 2003 9:29
Please take this flame war off list.
> -Original Message-
> From: Wang Feng [mailto:[EMAIL PROTECTED]
> Sent: 08 October 2003 11:31
> To: Michael Haunzwickl; 'Director General: NEFACOMP';
> [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Subject: Re: printing reports
> Importance: Low
>
>
> > So li
Add LIMIT x,y (x is first row and y the number of rows 1.e. 1,1 for
first row) at the end of the SQL and order the SQL. Not sure if this
helps, just initial thoughts.
On Wed, 2003-10-08 at 13:04, Ciprian Trofin wrote:
> I have 2 tables: currencies and quotes
>
> currencies
> ==
> id cu
On Wed, 2003-10-08 at 09:52, shaun thornburgh wrote:
> Hi,
>
> I have a table called Bookings which has two important columns;
> Booking_Start_Date and Booking_End_Date. These columns are both of type
> DATETIME. The following query calculates how many hours are available
> between the hours of 09
I have 2 tables: currencies and quotes
currencies
==
id currency
-
quotes
==
id date id_currency value
---
Index (date, id_currency - UNIQUE)
In order to find the most recent value for a currency I use the following
logic:
1. SELECT m
Access is not a Database, its a kiddies toy.
You can just as easlily make your reports using crystal reports or any thing
else like that if you really want to, or PHP/ASP
Now, please, for suggesting there is any use what so ever in the world for
access, please take your self out back and
> So listen guy, this is a big miss understanding:
NO
> 1.) If you want to have an "easy way tool" for creating your reports -
> use MS Access
Hey, man, inserting a record is also ealier in Access. => You suggest me to
do everything in Access. You'r bad bad man!!!
-- Tools are for dummy u
> So listen guy, this is a big miss understanding:
NO
> 1.) If you want to have an "easy way tool" for creating your reports -
> use MS Access
Hey, man, inserting a record is also ealier in Access. => You suggest me to
do everything in Access. You'r bad bad man!!!
-- Tools are for dummy u
Paul
How about
select FIRST_NAME, count(*)
from a table
group by FIRSTNAME
having count(FIRST_NAME) > 1
Mike
--
Live Life in Broadband
www.telewest.co.uk
The information transmitted is intended only for the person
So listen guy, this is a big miss understanding:
What i wanted to say, and what i did say was:
1.) If you want to have an "easy way tool" for creating your reports -
use MS Access
2.) All this things do not have anything to do with the "base" of your
datas (either you use Oracle, MySQL, Access or
Michael,
Couldn't help myself to read your words again, and I have to say you r so
stupid and annoying, at least today (i'm in a bad temper today).
Although I don't use Access often, I don't say Access is for "dummy users".
In my opinion, every programming language and any tool has its own depth.
On Wed, Oct 08, 2003 at 11:16:03AM +0200, Bob Brands wrote:
> What is the correct syntax for using a Exponentiation operator in MySQL?
>
It's not an operator but a function. Look at EXP and POW in the docs:
http://www.mysql.com/doc/en/Mathematical_functions.html
Regards,
Fred.
--
Fred van E
What is the correct syntax for using a Exponentiation operator in MySQL?
BTW is this even posible?
bye, Bob
http://www.beheervisie.nl/disclaimer.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi,
I have a table called Bookings which has two important columns;
Booking_Start_Date and Booking_End_Date. These columns are both of type
DATETIME. The following query calculates how many hours are available
between the hours of 09.00 and 17.30 so a user can see at a glance how many
hours they h
thanks for your nice advice. *dummy users* --- let's see.
- Original Message -
From: "Michael Haunzwickl" <[EMAIL PROTECTED]>
To: "'Director General: NEFACOMP'" <[EMAIL PROTECTED]>; "'Wang Feng'"
<[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, October 08, 20
> Unfortunately, they have not implemented a reporting tool in that client.
that's the problem, as I was trying to find some sql commands to edit the
report, such as report titles.
>Do you know some programming language? Like Visual Basic, C, C++, Java,
PHP,
i know them, but as I mentioned ear
So Ken Menzel says:
> Hi Jacco,
> Perhaps the manual needs to be enhanced, but it is only a guide,
> perhaps the language should be softened or 'error 136' modified that
> it could be either problem. Either way I hope this fixes you problem,
> my guess would be you have very large rows of data
Well, it seems to me, that he is looking for some replacement of "oracle
reports" ... Which is ... As far as i know ... Something like "MS
Access-Report-Wizard" where you can say: Take this table, this field,
link it to this field in the second table, show me all records which
have date = TODAY and
Some are free, others are commercial.
But, note that most of these are mainly for administration purposes.
For example phpMyAdmin is a free PHP based client.
Do you know some programming language? Like Visual Basic, C, C++, Java, PHP,
...
You said that you are able to run queries, ...
How do you
I use 4.0.14 and 4.1.0-Alpha
Thanks
Emery
- Original Message -
From: "Egor Egorov" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, October 07, 2003 16:45
Subject: Re: error messages in different languages
> "Director General: NEFACOMP" <[EMAIL PROTECTED]> wrote:
> >>
> >> Yup
74 matches
Mail list logo
