RE: Random Select Statement??

* David V. Edelstein I'm trying to create a select statement that will go into a table find the number of rows in the table then select a single random row and return it. I am using Java/mySQL with the mm.mysql JDBC drivers. I've been playing around with the following statement but it

Subselect/set query..pardon my SQL

Hi- I know this is wrong because it doesn't work: select name from table1 where id=03 and not in (select id from table1 where (id 10) AND (id 20) AND (id 37) table1 name id a 03 a 11 a 12 a 13I want a returned because it has a 03 and not a 10, a 20, OR 37 b

privil table

hi i want to know, about after i make new user in mysql , i try to check in user tables and i get it but if i look for in another table ( like : db, host, columns_priv, tables_priv) why ?? thx for all Yuyun Kusuma

RE: money datatype

Use decimal(10,2) for fields that will contain monetary values. If you use a float it will round the values, while decimal won't. Matthew Walker Ecommerce Project Manager Mountain Top Herbs -Original Message- From: Keith W [mailto:[EMAIL PROTECTED]] Sent: Monday, January 07, 2002 3:07

Re: Auto_Increment and the DELETE Statement

At 16:52 -0600 1/7/02, Rick Emery wrote: I don't know if this is a bug or a feature. Just an observation concerning creating MYISAM tables with auto_increment. CREATE TABLE mytable (myval int auto_increment unique ) AUTO_INCREMENT=9000; INSERT INTO mytable VALUES(NULL); INSERT INTO mytable

Query Behaviour

My situation is to access a remote MySQL server, and of course I do care about traffic. Suppose In a script there's a query: $result = mysql_query (select * from employ where age45) or die (Invalid query); I am just wondering that if MySQL server would return all the query result in total,

mySQL security

Hi all, I have set up mySQL database server on my web server running on RH Linux7.2. There are 2 user accounts, root and dummy who can access to databases. I'm wondering how to restrict the accesss to mysql (the db which stores user id, password, etc...). Right now, both users can run select,

Re: mySQL security

Dear - -: I would revoke all permissions for dummy, then create new permissions for users on a database-by-database basis. If you look at the syntax for GRANT in the manual, you can stipulate which databases a user would have access to. A word of caution: don't use root. Create a user for

MySQL authentication using PAM

We have been using LDAP for our user database for some years. We are now getting into MySQL, and I would like to be able to grant or deny access within MySQL based on LDAP user information, rather than having to maintain a separate database of users within MySQL. I understand that there is

INSERT value from another table

Hi, I was wondering how I would insert a value which is present in another table, specifically, this is a member_id field from a main members table which acts as a foreign key in this table (Although I know this not truly possible in MySQL). I think this attempted, although non functional, insert

Re: MySQL Book

Ok. So majority is towards Paul DuBois. I went to the http://www.newriders.com/ to see about this book and found that this book was published in Dec 1999. Is new edition out. Is it good enough for new version of MySQL 3.23.39 / MySQL 4.0.x. I do not want to buy a book that is outdated or going

What kind of crashes with GCC 2.96?

On the MySQL download page, there is a warning for GCC 2.96/x86/Linux that reads thus: Several of our users have reported random crashes and table corruption with MySQL binaries compiled with gcc 2.96 on the x86 Linux platform. I was wondering what kind of crashes users had experienced.

MySQL version numbers

I wondering how to know a MySQL version is stable or development. I knew 3.23.* are stable, 4.0 and 4.0.1 are development. But what's the future MySQL versions? Is there a regular habits like the version number of Linux Kernel? Thanks in advance! -- Zu Zhihui [EMAIL PROTECTED]

Re: MySQL Book

suitable for 3.22.x 3.23.x, but not enough good for 4.x -- Zu Zhihui [EMAIL PROTECTED] - Original Message - From: D Bamud [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, January 08, 2002 1:51 PM Subject: Re: MySQL Book Ok. So majority is towards Paul DuBois. I went to the

Server configuration denies access to data source

I installed MySQL in my local dir (~) (RH Linux7.2). Created database successfully. Can operate on this database at mysql prompt. I am trying to access the same database from my Java application THAT WAS working fine with the RMP installation of MySQL. When I run the program it gives SQLException

Syncronization between two databases

Hi! I need to syncronize two indentical MySQL databases. The A database is on a server permanently connected to the Internet trough an ADSL connection, while the B database is on a server equipped with an ISDN connection. How can I keep the two databases identical? Thanx Marco Frazzoli PS:

Re: MySQL Book

--- D Bamud [EMAIL PROTECTED] wrote: version of MySQL 3.23.39 / MySQL 4.0.x. I do not want to buy a book that is outdated or going to be outdated. Please comment. Yes, but good books are good books. This is a good book. I use SuSE 7.3, but get a lot of information from 2 books I favor

Newbie Question about working with datetime column

I’m using the NOW() function to store the date and time in my database table that a person fills out my form. But I noticed that it’s 2002-01-07 11:51pm but the time shows up as 2002-01-08 01:51:18. It appears to be two hours off. How can I adjust the time to match my time zone? Always an

replication :Slave thread: error connecting to master..urgent

Hai While setting up the replication environment i am getting the following error in the master ..what might be the problem 020108 13:20:00 Slave thread: error connecting to master: Can't connect to MySQL server on '' (10049) (0), retry in 60 sec I followed all the steps correctly given in the

<    1   2