Dear ladies and gentlemen,
Upscene Productions is happy to announce a new version of
the database developer tool:
Advanced Data Generator (version 1.6.1)
Version 1.6.1 for MySQL specifically fixes an issue with
reporting the null-ability on columns in MySQL 4 and 4.1
(
http://dev.mysql.com/doc/refman/5.0/en/myodbc-windows-binary-installation.html
I don't know how to use Delphi. But I think Delphi is easy to use ODBC just
like VB or PB.
Run set names utf8 just like a normal SQL statement after connect.
If you don't understand let me know.
regards,
gu lei
I have not been receiving the daily digest for the past 2 days. Just wanted
to check if I am the only one it's the same for others too.
Regards,
Rithish.
Is there any way I can do a content analysis with MySQL?
I need to find text in a database that have similarity.
/Jacob
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Luke Vanderfluit wrote:
Hi.
I've got mysql 4.0.18 installed on a sun X4100 running solaris.
This is just a 32 bit version of mysql.
I've reverted back to this version after trying mysql 5, 4.0.26 and
4.0.18 64bit.
Those versions were all unstable on 64bit, that is, the server would
just go
Hi, everyone!
I have transfer user's database and grants from one mysql server
(4.1.15) to an older one (4.0.26). I don't know user's password and have
only it's hash. How can I convert hashed password stored in
mysql.user.password field to the 4.0 format? Is there something similar
to
Does anyone know the cause of the following error message
Ignoring query to other database
When I log onto the mysql monitor and use any command I get this message.
This is strange because last time I used my copy of mysql it worked just
fine.
I am using MAC OSX and I was wondering if the latest
[snip]
Is there any way I can do a content analysis with MySQL?
I need to find text in a database that have similarity.
[/snip]
http://www.mysql.com/fulltext
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
Luke Vanderfluit [EMAIL PROTECTED] wrote on 03/22/2006 08:29:02
PM:
Hi.
I've got mysql 4.0.18 installed on a sun X4100 running solaris.
This is just a 32 bit version of mysql.
I've reverted back to this version after trying mysql 5, 4.0.26 and
4.0.18 64bit.
Those versions were all
I get the following error while trying to create the following database
mysql mysql zm_create.sql.in
ERROR 1044 (42000): Access denied for user ''@'localhost' to database
'mysql'
I tried to run the following script
/usr/bin/mysql_install_db --user=mysql
It does not create mysql database
Eugene Kosov [EMAIL PROTECTED] wrote on 03/23/2006 07:03:15 AM:
Hi, everyone!
I have transfer user's database and grants from one mysql server
(4.1.15) to an older one (4.0.26). I don't know user's password and have
only it's hash. How can I convert hashed password stored in
Good morning. I am trying to install Free Radius with MySql, but I
either have a login issue or a permissions issue.
I have added Radius and [EMAIL PROTECTED] to database, Fedora local users
and just about everywhere I can think possible. I have added
permissions for radius radius local
Hi,
I have a question about autoincremend id:
If I have an autoincrement id set on my first column field of my table and I
have the
following entries:
1
3
And then I make a INSERT INTO foobar VALUES(''); , the next field would be
automatically 4:
1
3
4
Is there a possibility to take a free ID
Atkins, Dwane P [EMAIL PROTECTED] wrote on 03/23/2006 10:38:57 AM:
Good morning. I am trying to install Free Radius with MySql, but I
either have a login issue or a permissions issue.
I have added Radius and [EMAIL PROTECTED] to database, Fedora local users
and just about everywhere I
[EMAIL PROTECTED] (saf) wrote on 03/23/2006 10:50:10 AM:
Hi,
I have a question about autoincremend id:
If I have an autoincrement id set on my first column field of my
table and I have the
following entries:
1
3
And then I make a INSERT INTO foobar VALUES(''); , the next field
On Thu, Mar 23, 2006 at 11:04:55AM -0500, [EMAIL PROTECTED] wrote:
[EMAIL PROTECTED] (saf) wrote on 03/23/2006 10:50:10 AM:
The short answer is no. The Record #2 already existed. It's current
status is deleted. If you had other tables that linked their data to
record #2 and you created a
[EMAIL PROTECTED] (saf) wrote on 23/03/2006 16:10:04:
On Thu, Mar 23, 2006 at 11:04:55AM -0500, [EMAIL PROTECTED] wrote:
[EMAIL PROTECTED] (saf) wrote on 03/23/2006 10:50:10 AM:
The short answer is no. The Record #2 already existed. It's current
status is deleted. If you had other
On Thu, Mar 23, 2006 at 04:17:44PM +, [EMAIL PROTECTED] wrote:
Lots of ways round this. Instead of deleting records, add a boolean
deleted flag. All selects then need to add and deleted = 0. But you can
find a (random) deleted row with select id from table where deleted = 1
limit 1. If
So I must do a big SELECT and then check my self every time (for each
INSERT),
which IDs are free?
No, you just ignore deleted IDs.
What's the point?
Martijn Tonies
Database Workbench - development tool for MySQL, and more!
Upscene Productions
http://www.upscene.com
My thoughts:
* a) Verify that you have actually GRANTED permission for the
account you are trying to authenticate with
SELECT user, host from mysql.user where user ='radius';
mysql SELECT user, host from mysql.user where user ='radius';
++---+
| user | host |
[EMAIL PROTECTED] (saf) wrote on 03/23/2006 11:10:04 AM:
On Thu, Mar 23, 2006 at 11:04:55AM -0500, [EMAIL PROTECTED] wrote:
[EMAIL PROTECTED] (saf) wrote on 03/23/2006 10:50:10 AM:
The short answer is no. The Record #2 already existed. It's current
status is deleted. If you had other
You could try suggestion B) ;-)
Shawn
Atkins, Dwane P [EMAIL PROTECTED] wrote on 03/23/2006 11:25:24 AM:
* a) Verify that you have actually GRANTED permission for the
account you are trying to authenticate with
SELECT user, host from mysql.user where user ='radius';
mysql
I did do a FLUSH PRIVILEGES and this still resulted in the same error.
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 23, 2006 10:31 AM
To: Atkins, Dwane P
Cc: mysql@lists.mysql.com
Subject: RE: Freeradius and MySql
You could try
OK, make sure you are using the correct password, too. Did you remember
to encrypt the password with PASSWORD() or OLD_PASSWORD() when you create
the account?
SELECT user, host, password
FROM mysql.user
WHERE user='radius';
make sure your password is hashed, if not we can help you fix that
I didn't encrypt and that was going to be my next questions. How do I
do that?
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 23, 2006 10:45 AM
To: Atkins, Dwane P
Cc: mysql@lists.mysql.com
Subject: RE: Freeradius and MySql
OK,
Shawn,
Thanks. That has done the trick. It turns out that I had passwords
hashed for [EMAIL PROTECTED], but not [EMAIL PROTECTED] Resetting the password
and flushing the privilege has really helped. Guess what, you have done
in 20 minutes what myself and other could not do in a week.
Dilipkumar,
Thanks much for the tipit did the job!
Now we query mysql to see if the new mysql database is seen by mysql and it
still only sees test:
[EMAIL PROTECTED]:/usr/bin mysqlshow
+---+
| Databases |
+---+
| test |
+---+
[EMAIL PROTECTED]:/usr/bin
Here is
On Thu, 23 Mar 2006 [EMAIL PROTECTED] wrote:
To: saf [EMAIL PROTECTED]
From: [EMAIL PROTECTED]
Subject: Re: Question about autoincrement ID
One important thing to remember: You should not let UI
design requirements dictate your DB design. Most
developers who design the database just to
Hello everybody,
I have a problem with replication of data from master to slave server.
The problem is, that the master is in a other timezone than the slave
and so inserts with using the now() function creates different values on
master and slave. If I want to update on the master and use
What does line 1189 look like?
-Sheeri
On 3/17/06, Jack Baty [EMAIL PROTECTED] wrote:
I'm trying to restore a database from a dump as part of my
make-sure-this-will-restore-just-in-case process and I get the
following error...
ERROR at line 1189: Unknown command '\''.
The only thing I've
On 3/19/06, shreeseva [EMAIL PROTECTED] wrote:
- Original Message -
From: shreeseva
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Monday, March 20, 2006 01:15 AM
Subject: About Data types
Dear friends,
I am using MySQL 5.0.17 on Win XP Prof. I have created a prototype
MySQL doesn't have anything like that. You can use the wildcard
characters instead of the umlauts if you want, such as
SELECT * from person where name like %bersee
which would get
übersee and uebersee
but also a whole lot more.
But doing something like
SELECT * from person where name like
On 3/23/06, sheeri kritzer [EMAIL PROTECTED] wrote:
What does line 1189 look like?
Good question. Hard to tell, since it's the insert statement for a
rather large table (25 million rows) and I have --extended-insert set,
so it's all on one *really* long line. Seems like there should be a
return
[EMAIL PROTECTED] wrote on 03/23/2006 02:20:00 PM:
On 3/23/06, sheeri kritzer [EMAIL PROTECTED] wrote:
What does line 1189 look like?
Good question. Hard to tell, since it's the insert statement for a
rather large table (25 million rows) and I have --extended-insert set,
so it's all on
Following is the configuraton of mysqld:
- Excerpt from my.cnf -
# The MySQL server
[mysqld]
user= mysql
port= 4406
socket = /tmp/mysql.sock
#socket = /tmp/mysql_4.0.13.sock
Hello,
Anybody here are also familiar with SQL server 2000 Web Assistant Wizard?
The wizard enables you to create queries that run against the SQL server
2000 database to push data to your web site in the form of static pages.
You can choose how often the web client sees the changes in the SQL
On 3/23/06, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
When you generated this dump file, did you remember to use the
--max_allowed_packet parameter to make sure that mysqldump didn't create any
extended insert statements larger than your server wants to handle? It could
be crapping out
kalin mintchev wrote:
hi all...
i can't see the mysql 5 version for freebsd 6.0 on the mysql developer
site?
am i blind or it's on purpose?!?!
curious... and actually need it...
thanks...
/usr/ports/databases/mysql50-server/
/usr/ports/databases/mysql51-server/
I suggest you
Dilipkumar,
Thanks much for the tipit did the job!
Now we query mysql to see if the new mysql database is seen by mysql and it
still only sees test:
[EMAIL PROTECTED]:/usr/bin mysqlshow
+---+
| Databases |
+---+
| test |
+---+
[EMAIL PROTECTED]:/usr/bin
Here is
Can someone illustrate the correct syntax for using auto_increment in
making a table? I've studied the manual and I'm not seeing how it comes
out.
EG:
CREATE TABLE Books (
bookID INT(5) PRIMARY KEY AUTO_INCREMENT...
THEN WHAT?
Thanks.
EB
--
MySQL General Mailing List
For list archives:
On 24/03/2006 11:06 a.m., Eric Beversluis wrote:
Can someone illustrate the correct syntax for using auto_increment in
making a table? I've studied the manual and I'm not seeing how it comes
out.
EG:
CREATE TABLE Books (
bookID INT(5) PRIMARY KEY AUTO_INCREMENT...
THEN WHAT?
Thanks.
EB
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
I realized this also. Martin Schwarz off list suggested to me to use
REGEXP for that purpose. That means that I'm rewriting the user input
übersee behind the scenes to ^(ü|ue)bersee.* which works quote well.
The only gotcha is that the user may
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Ubaidul,
ok, there is nothing in my.cnf that can explain why memory runs out.
What kind of query are you running when the memory runs out? Does 'top' show
that the mysqld process size grows uncontrollably?
If you are using the C client interface, do you use 'mysql_store_result()'
or
44 matches
Mail list logo