[MySQL PASSWORD() for encryption]

Good idea how?

 

To resolve any issues relating to encryption functions that might contain arbitrary byte values.

[last_update_id/max() don't work through PHP]

Like Paul stated - the first insert query is setting the id to NULL and as a result is also setting the last insert id to null to, there is no need to explicitly assign an auto increment value through the insert statement, the id value will be generated automatically... remove the first NULL from the first set of inserted values and use last_insert_id() in the last set.

[Connection Error]

The error suggests a credentials issue, try swapping login for root.

[need a query for removing dupes]

?

I mean, according the query I have written there It removes all the records except the first occurrence of each unique ip .As each ip has a unique id and rank so it will keep the records of unique (id, rating, ip) combination.

webosb original post does not mention that each ip has a unique id - but does mention that the ids range from 1 - 1000 and rating range from 1 - 10.

[Not indexing all table rows?]

Though this has nothing to do, directly, with your actual question, SA - would adding an additional indexed enum column named `range` with values such as 0-5, 5-10, 10-5 (depending on application) improve your query performance?

[need a query for removing dupes]

Obviously it results those records only as long as each ip has unique rank and id.

?

[[SOLVED] Query Query :S]

Consider a query that will collate all the information in the following format:

 

Movie | Date | Session Times

 

... and display the results in an order fashion using PHP.

 

Use GROUP_CONCAT for the session times, depending on how the session times are stored.

[[SOLVED] MySQL Authentication]

Try...

 

date_format(date_purchased, '%Y-%m-%d') = CURRENT_DATE

[distinct first column... the rest not]

Grab all the records on the condition of the 'certain day' ordered by the date and limit 1.

[[SOLVED] MySQL Authentication]

What is this: 'CURRENT_DATE():00:00:00'

[[SOLVED] MySQL Authentication]

$sql1 = "SELECT customers_email_address, date_purchased, order_total FROM orders WHERE customers_email_address = '$_POST[myemail]'";

 

The MySQL query starts at the end of $sql1 = " and ends at "; - everything between the quotes is the MySQL query

[LEFT JOIN is locking up mysql]

Slight change:

 

SELECT crn.id, person.fname
FROM crn
     LEFT JOIN instructor_crn ON crn.id = instructor_crn.cid 
     LEFT JOIN person ON person.id = instructor_crn.person
WHERE crn.id = '6'

 

Should be fine... change the LEFT JOIN to INNER JOIN if a matching record must exist.

[[SOLVED] MySQL Authentication]

The PHP processor does not understand MySQL functions.

 

The PHP forum may be more appropriate for PHP related issues.

[[SOLVED] MySQL Table for postcodes... what is best?]

SELECT * FROM postcodes WHERE start = 'SW1';

 

is much faster than

 

SELECT * FROM postcodes WHERE postcode LIKE 'SW1%'

 

I suggest you stick with the original system.

[GROUP BY and ORDER BY together]

This has nothing to do with the error, but what does the paranthesis wrapping the first join mean?

 

Might be missing the .user_id on the GROUP BY

 

GROUP BY moch_dueno.user_id

[[SOLVED] MySQL Authentication]

At a glance: Wrap if conditions in paranthesis and add a variable identifier to order_title and date_purchased, and I do not think CURDAT is anything in PHP

[need a query for removing dupes]

webosb wanted a unique (id, rating, ip) combination.

[MySQL PASSWORD() for encryption]

Is the following a good idea, fenway:

 

ALTER TABLE account MODIFY password VARBINARY(100) not null default 'password' comment 'account password';

[Mysql Server Crash]

No kidding... have you check the mysql bugs list to see if this is mentioned?

 

nope, I am lazy like that - and have moved on in code since discovering the error... also, binindex confirmed that later versions are fine.

[Select articles from within a month of todays date?]

oh yeah... but take a look at this...

 

SET @date_created = '2007-06-01';

SELECT benchmark(10000000, month(@date_created) = month(CURRENT_DATE));
# ~ 2719ms

SELECT benchmark(10000000, @date_created BETWEEN last_day(CURRENT_DATE - interval 1 month) AND last_day(CURRENT_DATE));
# - 297ms

 

I must have previously not run the SET line... *slaps head*

[MySQL PASSWORD() for encryption]

I have never had a problem using a varchar column for encrypted data, besides BLOB holds a variable amount of data anyway or use VARBINARY instead.

[MySQL PASSWORD() for encryption]

md5() should be used instead of password() to encrypt data, from mysql documentation:

 

Note: The PASSWORD() function is used by the authentication system in MySQL Server; you should not use it in your own applications. For that purpose, use MD5() or SHA1() instead. Also see RFC 2195 for more information about handling passwords and authentication securely in your applications.

[[SOLVED] return data from part word search?]

SELECT * FROM repository WHERE name LIKE '%steph%'

 

% = wildcard

 

http://dev.mysql.com/doc/refman/4.1/en/string-comparison-functions.html

[[SOLVED] Combining (nesting?) multiple queries into one]

Still looks like joins to me.

 

Um, yeah. Which is exactly why I said his statement about there not being a common element between the tables was false. I think the OP was thinking there had to be "the same" common element between all the tables, and that is not the case.

 

Please excuse me, my comment was meant for the original poster and meant no offense.

[[SOLVED] Combining (nesting?) multiple queries into one]

Still looks like joins to me.