Afternoon all,
This is an interesting problem that we ran into and have subsequently fixed (well it
fixed
itself, but more on that later).
I posted a question to the list a couple days ago quoting this as a TIMESTAMP(14)
column type
issue, but as I investigated more, that turned out to be
Hello I need help
This Statement does not work. MySql Version is 3.23.47. On Oracle Instance it works.
What can i do ? Whitch Version do i need ? MySql 4.xx ?
MySQL 3.23.47 running on localhost
SELECT A.Kommentar, A.SequenzNr from Aufgabe A
LEFT JOIN Taetigkeiten ON Aufgabe.Kommentar =
Hi Jens,
try to rewrite you query to
SELECT A.Kommentar, A.SequenzNr
FROM Aufgabe A LEFT JOIN Taetigkeiten
ON A.kommentar=Taetigkeiten.Bezeichnung
AND Taetigkeiten.inaktiv = '1'
WHERE isnull(Taetigkeiten.Bezeichnung)
LIMIT 0, 30
--
Regards
Leonardus Setiabudi
IT Project Coordinator
PT Bina
Hi!
On Dec 11, Gerald wrote:
The subject says most of it. I'm moving mysql data from one machine to
another. --quote-names works on tables and columns, but it seems to be
skipping the database names. (`-` is the character throwing the restore
off)
Check the bugdb (bugs.mysql.com)
as far as I
OK I tried this, so '+music +mix +2001' instead of this 'music mix
2001' and the SQL time is the same ~21 sec.
select artists.name , cds.title, tracks.title from artists, tracks, cds
where
MATCH (artists.name) AGAINST ('madonna' IN BOOLEAN MODE)
and MATCH (cds.title) AGAINST ('+music +mix
After I uninstalled 4.1 I removed the /var/db/mysql/ directory so that the
install of 4.0.6 would start fresh and create its defualt users and
databases with no trace of the previous user entries.
Schrodinger wrote:
I have removed all localhost user entries and all users should now be
able
[snip]
After I uninstalled 4.1 I removed the /var/db/mysql/ directory so that
the
install of 4.0.6 would start fresh and create its defualt users and
databases with no trace of the previous user entries.
[/snip]
Are you doing your grants from the command line or from a GUI? Have you
done FLUSH
I created users using webmin and I have done FLUSH PRIVILEGES.
[snip]
After I uninstalled 4.1 I removed the /var/db/mysql/ directory so that
the
install of 4.0.6 would start fresh and create its defualt users and
databases with no trace of the previous user entries.
[/snip]
Are you doing
[snip]
I created users using webmin and I have done FLUSH PRIVILEGES.
[/snip]
Are you granting privileges based on 'localhost', '127.0.0.1', or
somewhere else. Where are users logging in from?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Well that was easy.
After reading your response I went back and used
gcc -fPIC -c xxx.cc
gcc -shared -o xxx.so xxx.o
and all was well again.
Thanks for your help..again.
Ollie
Dan Nelson said:
In the last episode (Dec 11), Ollie Gallardo said:
I'm back with another question. I tried to
The users are being created with the privelages of being able to login
from any host and they are logging in from the command line through their
shell account.
[snip]
I created users using webmin and I have done FLUSH PRIVILEGES.
[/snip]
Are you granting privileges based on 'localhost',
[snip]
The users are being created with the privelages of being able to login
from any host and they are logging in from the command line through
their
shell account.
[/snip]
So they need to be '[EMAIL PROTECTED]' You gave this ...
[snip]
ERROR 1045: Access denied for user: '[EMAIL PROTECTED]'
[EMAIL PROTECTED] wrote:
I'm load a CSV file with five fields into mysql. It loads up fine.
Problem comes in when I try to refresh the data with updates.
I grab this file and convert it to CSV every 12 hours. The data shows
past 24 hours only, so basically I'm trying to make a permanent
Issue has been resolved. Thank you all. I dont know what went wrong but I
think it was becuase when I was connecting as root
I ran :
mysql --user=root
and not mysql --user=root mysql
after I did this I created a user and now that user can connect with a
password.
Thank you all for your help
I am using the command line for grant operations, no flushing though
Why are you using 4.0,6? any special reason? I am using a custom (i
compiled myself) 4.0.16
Here is an example operation:
TRY TO LOG WITHOUT PASS, ERROR
[EMAIL PROTECTED] vmedina]$ mysql
ERROR 1045: Access
This is from the manual. See the 3rd paragraph.
The REPLACE and IGNORE keywords control handling of input records that duplicate
existing records on unique key values.
If you specify REPLACE, input rows replace existing rows (in other words rows that
has the same value for a primary or
.
I'm seeing double with this, and I just KNOW it's got to be simple -
The table images contains columns:
id | reference_number | image | width | height
That's all it contains, nothing else.
id is auto-increment
reference_number is usually set anew by the operator to input new data, but
sometimes
perror 145
145 = Table was marked as crashed and should be repaired.
Run myisamchk on it.
David Rankin wrote:
I can't figure this out. I'm setting privileges for access on a local net to
a user [EMAIL PROTECTED] using grant and all of a sudden mysql is dead. I'm
running 3.23.31 on Mandrake 7.2.
Yes, if you are using v3.23.6 or above, ALTER TABLE on the command line
should accept quoted column names to allow you to change the column names.
Pat...
- Original Message -
From: Brian Duke [EMAIL PROTECTED]
To: 'Patrick Sherrill' [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Thursday,
We are using MySQL 4.1.1 with mysql-connector-java-3.1 JDBC Driver(nightly
snapshot).
The only way we can store and display the Unicode content is by specifying
it in the jdbc connection string(url) like:
jdbc:mysql://localhost/database_name?useUnicode=truecharacterEncoding=UTF-8
AND specifying
Using PHP as the front end I am creating a form with a dropdown box that
displays information from one table to be inserted into another table.
That's PHP and I have gotten that part down with no issue.
However, in the table a person could be listed multiple times and I only
want a user to be
I am running a mysql database and want to perform a hotbackup on linux.
How will this be done since the ibbackup tool is not delivered in the
standard package
Jeff,
The first example worked perfectly, Thanks for the quick response
Jess
-Original Message-
From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]
Sent: Friday, December 12, 2003 10:02 AM
To: Hunter, Jess
Subject: Re: How to keep multiple instances of the same information
from
fatblokeonbike wrote:
.
I'm seeing double with this, and I just KNOW it's got to be simple -
The table images contains columns:
id | reference_number | image | width | height
That's all it contains, nothing else.
id is auto-increment
reference_number is usually set anew by the operator to input
OK. I've made some progress. It looks like just doing --with-openssl
doesn't work. You have to specify both the includes and the libs as
well. So, this is what I'm using now:
./configure --with-openssl
--with-openssl-includes=/usr/local/ssl/include
--with-openssl-libs=/usr/local/ssl/lib
Perhas you want SELECT DISTINCT ?
http://www.mysql.com/doc/en/SELECT.html
Hope that helps,
Ken
- Original Message -
From: Hunter, Jess [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, December 12, 2003 10:47 AM
Subject: How to keep multiple instances of the same information from
One thing that I see is that you are using an alias in your where clause.
From the manual:
It is not allowed to use a column alias in a WHERE clause, because the column value
may not yet be determined when the WHERE clause is executed. See section A.5.4
Problems with alias.
The other
Or you could use a subquery:
SELECT id, image, width, height FROM images
WHERE reference_number=(Select max(id) From images)
ORDER BY image
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi, I'm granting users to use temporary tables as:
GRANT CREATE TEMPORARY TABLES ON db1.* TO user1;
and having grants on many other tables as:
GRANT SELECT,INSERT, UPDATE, DELETEON db1.table1 TO user1;
GRANT SELECT,INSERT, UPDATE, DELETEON db1.table2 TO user1;
but how make this
Don,
I believe I found the bug.
MySQL/InnoDB-4.0.17, December xx, 2003
* Fixed a bug: if you created a column prefix secondary index and updated it
so that the last characters in the column prefix were spaces, InnoDB would
assert in row0upd.c, line 713. The same assertion failed if you updated
Using your exact dataset listed at the bottom, I tried using derived
tables to combine your implementation under Alpha 4.1.1 as a single
statement. I expected a message saying it was to complex or out of some
resource but the server goes to 100 percent cpu and I have to kill it. I
even got it to
Thanks for the reply Gerald.
I took your advise and tried myisamchk with the following results:
[EMAIL PROTECTED] mysql]# myisamchk -r user.*
myisamchk: error: 'user.frm' doesn't have a correct index definition. You
need to recreate it before you can do a repair
-
myisamchk: error:
Gerald,
I spoke too soon. myisamchk seemed to have worked !!! I now have mysql
running again and it seems happy. Now if I can just figure out the
privileges to put into the db table to allow my local users to be able to
connect though their browsers, I'll really have made progress.
Thank
Hi Jess
Have you tried SELECT DISTINCT
not sure if 'select distinct *' will work but if doesn't 'select
distinct userlastname,userfirstname' will
hope this helps
Steve Davies
Hunter, Jess wrote:
Using PHP as the front end I am creating a form with a dropdown box that
displays information
We have 2 tables which are roughly half the size of the entire database
{ ~1.5GB}. These 2 tables are rarely changed {1-2 times a quarter}.
Is there a way in mysqldump to exclude these two tables without
specifically naming all of the tables { 100} we want to include?
You might consider using Grant instead of editing the permissions table manually.
Follow this link for the appropriate section of the manual:
http://www.mysql.com/doc/en/GRANT.html
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Hi guys!
I am facing some problems trying to login user to the data base server
using --any-- client(except the mysql cli) to the server. Users using no
password does not seems to have any problems.
It happens that when a client tries to log into the db server using
passwords the server doesn't
I am using version 3.23.58 and need to do
the following:
select * from a where id not in (select tbl_id from b where tbl=a);
Given that my version does not support sub selects, how
can I re-write the statement to get the desired results?
Thanks.
Dean Hoover
--
MySQL General Mailing List
For list
I'm having sporadic myisam table corruption. This table is constantly being
added to, updated, and deleted from. PHPMyAdmin reports that The table is in
use when I try to access this table after corruption. After I perform this
step in the correct directory everything goes back to normal.
left joins are your key
select * from a
left join b on id = tbl_id and b.tbl = a
where b.tbl_id is null
(not 100% sure on my syntax, but note the join, and the limitation on 'left' result
set is specified within the left join clause)
-Original Message-
From: Dean A. Hoover
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Yayati Kasralikar wrote:
We are using MySQL 4.1.1 with mysql-connector-java-3.1 JDBC Driver(nightly
snapshot).
The only way we can store and display the Unicode content is by specifying
it in the jdbc connection string(url) like:
Change myisam format to something else, like InoDB or BDB
Best Regards!
On Fri, 2003-12-12 at 15:05, James E Hicks III wrote:
I'm having sporadic myisam table corruption. This table is constantly being
added to, updated, and deleted from. PHPMyAdmin reports that The table is in
use when I
Is there a simple way of copying a postgres database to MySQL? I was
hoping that postgres's backup 'pg_dump' utility (which dumps a
database into a text file in such a format that it can be easily
recreated) might be compatible with MySQL's backup and restore
facilities.
Zenzo wrote:
i
Thanks Gerald!
I'm replying to my self for the benefit of anyone else who has the mysql
user.MYD file get corrupted. As root change to the mysql/mysql directory.
run myisamchk -r *.* Ignore the errors. Start mysql. Pray your mysql root
password isn't corrupt and your through. My root password
Hi Heikki,
Thanks so much for taking the time to look into this. No wonder you
have such a great product.
When 4.0.17 comes out, I'll certainly test it.
Thanks again,
Don
Heikki Tuuri wrote:
Don,
I believe I found the bug.
MySQL/InnoDB-4.0.17, December xx, 2003
* Fixed a bug: if you
Hi all,
I am new to mysql and I was wondering if someone could point me in the
right direction on how to store .tar and .tar.gz (bzip2) files inside a
mysql database. I have googled to try and find some help there but most
of the hits come back with binary image files. I have gone thru the mysql
Can I ask why?
Why not define a char(50) (or whatever size) with the relative or complete
path to the .tar file? Storing it in your database would create huge row
sizes.
Joshua Thomas
Network Operations Engineer
PowerOne Media, Inc.
tel: 518-687-6143
[EMAIL PROTECTED]
---
In theory there is no
On Fri, Dec 12, 2003 at 02:54:44PM -0600, [EMAIL PROTECTED] wrote:
I am new to mysql and I was wondering if someone could point me in the
right direction on how to store .tar and .tar.gz (bzip2) files inside a
mysql database. I have googled to try and find some help there but most
I believe the
The scenario we wish to accomplish
SERVER1 - Logging DB1
SERVER2 - Logging DB2
Logging DB3
Replicating DB1 from SERVER1 - Logging DB1
SERVER3 - Replicating DB1 from SERVER2
Replicating DB2 from SERVER2
Replicating DB3 from
I am working with a project on sourceforge http://leopard.sourceforge.net
and this is one of the package management stratagies we are thinking about
trying. As I said I have almost no experience with mysql so I open to any
and all suggestions. Very good points being made about the size of the
Hi there just a lot lot lot of questions. Plz answer as many as you can.
What do u prefer varchar(2) or tiny_text?
What is the biggest size for the varchar? If I want to store a very big article. What
is the biggest size for text that is being support?
What is the difference between
On Fri, Dec 12, 2003 at 02:54:44PM -0600, [EMAIL PROTECTED] wrote:
Hi all,
I am new to mysql and I was wondering if someone could point me in the
right direction on how to store .tar and .tar.gz (bzip2) files inside a
mysql database. I have googled to try and find some help there but most
of
Here is a link to the MySQL manual. Lots of good info here.
http://www.mysql.com/documentation/mysql/bychapter/index.htm l
The max size of a varchar is 255 characters. You will want to use one of the text data
types if you are going to store long articles. I suggest mediumtext. You can find
I keep getting the following error when I try to run an if statement
Warning: 2 is not a valid MySQL-Link resource in then give the filename
Here is what I am trying to do.
if ($bumpnumber4) {
print (display this);
}else {
print (display that);
}
mysql_close ($Link);
Anyone have any idea what I
Hello Mark,
Thanks for your help. I have one more question.
I am using the some tables with utf8 character set and some tables with
latin1 character set. I am using the jdbc connection string from the
properties file with the characterEncoding=UTF-8. I am not changing the jdbc
connection string,
MySQL 4.1.0-alpha-max-nt
MySQL C API interface
Visual C++ 6.0
trying some query when cache is on...
it causes ERROR: Lost connection to MySQL sever during query
MySQL cache memory used for _this_ query ~900Kb
but when cache is off or query result size is less than few Kb, everything is OK.
WHY?
I wonder why even I already sey NOT NULL in Mysql field but Delphi (with
MyODBC 3.51.06) still enable to save to the Table!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
If anyone has any suggestions, they would be greatly appreciated. I've
searched though my resources and online, and perhaps my newbie frustration
is making me overlook something simple.
What I'm trying to do is sort by a column with by pre-set criteria; I've a
political database with events
Brandyn Riffle wrote:
What I'm trying to do is sort by a column with by pre-set criteria; I've
a political database with events with columns for the year, month, day,
and event. I'd like to order by months, (e.g. JAN, FEB, MAR, etc...)
after sorting by year. The sorting by year part was
I have installed MySql on my PC and I was trying to run the program by going to the
command prompt typing:
C:\net start mysql
it says
The MySql service has started successfully.
the problem is that the command prompt doesn't read
mysql
but still reads
C:\
What is the problem here and
At 18:21 -0800 12/12/03, Betta Jazzy Brown wrote:
I have installed MySql on my PC and I was trying to run the program
by going to the command prompt typing:
C:\net start mysql
it says
The MySql service has started successfully.
the problem is that the command prompt doesn't read
mysql
but
At 20:36 -0500 12/12/03, Brandyn Riffle wrote:
If anyone has any suggestions, they would be greatly appreciated.
I've searched though my resources and online, and perhaps my newbie
frustration is making me overlook something simple.
What I'm trying to do is sort by a column with by pre-set
At 14:42 -0400 12/12/03, Victor Medina wrote:
Hi guys!
I am facing some problems trying to login user to the data base server
using --any-- client(except the mysql cli) to the server. Users using no
password does not seems to have any problems.
It happens that when a client tries to log into the
At 14:03 -0500 12/12/03, Dean A. Hoover wrote:
I am using version 3.23.58 and need to do
the following:
select * from a where id not in (select tbl_id from b where tbl=a);
Given that my version does not support sub selects, how
can I re-write the statement to get the desired results?
At 14:42 -0400 12/12/03, Victor Medina wrote:
It happens that when a client tries to log into the db server using
passwords the server doesn't seems to authorize. Even the most recent
MyCC client fails to autorize users using passwords. Do I need to
compile the clients against the new server's
Chuck Gadd wrote:
Brandyn Riffle wrote:
What I'm trying to do is sort by a column with by pre-set criteria;
I've a political database with events with columns for the year,
month, day, and event. I'd like to order by months, (e.g. JAN, FEB,
MAR, etc...) after sorting by year. The sorting by
At 22:47 -0500 12/12/03, Brandyn Riffle wrote:
Years are stored as smallint(4)
Months are stored as tinytext
converting to datetime might have been a good idea earlier, but I've
over 3000 entries, so if I can avoid that I'd like to... I'm not
above creating another column to correlate months to
Hi all!
I've got a few questions that I was hoping some of the fine readers of
this list could help me out with. I'll probably be going into a
development meeting this coming week and will need to have some
information up my sleave to ensure the mighty MySQL is selected as the
database backend
Hi again all,
Given that a transaction looks like this:
BEGIN;
SELECT useless_field FROM useless_table WHERE useless_identifier =
'useless';
SELECT useless_field FROM useless_table WHERE useless_identifier =
'something else';
INSERT INTO useless_table (useless_field, useless_identifier) VALUES
69 matches
Mail list logo
