Hi MARUN,

As I see there are some discrepancies in your queries here. First you say that you want to limit the entrants to 20 but then in the second one you say you want to limit the enquiries to...

Firstly is there any criteria as to on which you could separate the data ?
Say for example if there is any auto_increment field you could certainly use this to tuncate only those rows with id <=...

Suits me if the whining is about correct things, Which if you follow the thread you will come to know, but alas...you opted not to.

Yeah why would newbies like you like to take any pains preparing your food, when it is thrown ready made at you, what you say is pretty obvious for your kinds.

And FYI the "referring to manuals"...

It is unclear what you exactly want to achieve. Bot hof your queries are identical.

Whats code got to do with it ? And what the hell is the css doing there in a question related to MySQL ? And how are you going to use regex Mr. ? If you don't know the answer don't post there's no...

www.mysql.com should be where you should be looking for all materials. Reading about, working with and trying out different things is what would be the best possible approach for gathering knowledge....

The only useful thing you have suggested in here was already suggested in my post (see above) but you did not read it or, more appropriately, did not want to read it, otherwise how would have your...

create view john_doe_rentals as
select b.bid
from sailor s, boat b, rental r
where s.sid = r.sid and ( = 'John Doe') and r.date > "5/5/09" and rbid = b.bid;


Here I guess you have forgotten to...

Where do you think you should look for them ? Not certainly on the portals of MS-SQL, Oracle or DB-2 systems.

http://dev.mysql.com/downloads/connector/

If your select queries work but deletes and inserts take time it should have been a problem of locking. Basically it could have been a case where one of the previous operations put a lock on the...

Same passwords would not cause the root privileges to be given to the user. As privileges are given to user accounts and not to passwords.



You can give the user account a password at the time...

Read the previous posts, a poster has already been adviced about this. And tell me how is he going to do this activity on a daily basis ?
Open the GUI program daily and do it ?

The previous...

MySQL monitor - this is the command shell of MySQL that you are talking about isn't it ? Just to make sure we are on the same wavelength here.

Also have you already created the users or are you...

How do you enter the MySQL shell/monitor ?
If you type just mysql and fire the command it will assume the default settings in the my.cnf (GNU Linux)/ my.ini (Windows) configuration file.

If...

The notice shows two warnings, and not errors as such. One, that your PHP Mysql library version is an older version than that used by MySQL server.

For this I suggest that you copy the...

@karthik1983 : Read what the OP wants and try to understand it before posting stuff and


avoid this nonsense, if you have something to share, share it with all. It's just one of those forum's...

Instead of taking the lengthy route of a backup through a script, you could just as well use the 'SELECT...INTO OUTFILE' query to backup the data to a CSV file. You could put this command into a file...

Doh.. exactly I forgot to mention this which dickersonka correctly points out a name will do fine as well, as long as the DNS can resolve it.

specify the IP address of the server in the place of localhost.

Select resortname from table2 where resortid = (select MAX(resortid) from table1)


Try this.

start a new thread probably this one's already more than 3 years old.

Okay so in your sense learning means giving away the wrong thing and trying to tell people to correct it ?

You could have just described what you wanted to tell him and left the writing of the...

@webman07 & newbie_mysql:
Firstly webman07, trudge isn't wrong, let alone being arrogant. He just pointed you in the right direction. When posting on a forum its always good to know what the the...

Hmm.. It's quite easy, I guess, to just retaliate with the first possible means than admitting your mistake. And however difficult it might seem to you, I like to suggest a few good things to people...

@manojjena1982 : Giving away readymade stuff like that wihtout attempting to make the OP learn isn't considered a good habit here, try to correct yourself in the future.

Then such people aren't worthy of telling anything at all. Because this community attempts to nurture an environment that makes people learn while helping them. Giving away readymade answers just...

@almostbob : Rather than posting the exact queries as answer, why not just mention that MySQL contains something like 'LIKE' and then maybe point him towards the documentation page for the same and...

What is the definition of relevant ? If you use the LIKE clause, you will get only those records in which the filed contains the content of the LIKE clause. So if you have all records containing the...

The DBMS will take care of that, you do not have to worry for that.

If that solves the query mark the thread as solved so that people are aware of the fact and do not post anymore on this thread. Else we do have a lot of old threads revived unnecessarily.

well if the query has been solved mark the thread so.

You could write a MySQL query for this like:

SELECT Name FROM tablename where type = '<type>' and price <= '<price>'


Once you have the result for this, you could show it using PHP.

For a custom search, what you can do is, have multiple queries written each for a different search that can be done on your database and select the appropiate one to fire, dynamically, based on the...

@naveen : Good point there about the keywords, but I guess he has framed his question wrong.

@OP : Would you be able to define a custom search in more detail or reframe your question, cause...

You check the mysql binary log, so as to know what the server was doing at the time of the crash.

Latitudes and Longitudes would help you in almost zeroing in on any place. When detailed right down to seconds you can pin point any place on the globe. But do you always want such pin pointed...

You can assign only access privilege to the standard set of records (I assume they are in a separate table) to the group. So that they can certainly generate other records using values from the...

@nav33n : I chose not to give him the exact query but describe what it should be like and let him do the work.

Use a query that groups users by status and in the second column put their count. Try to form a query for this.