Search results for query: *

I see that you want the data to be in some format, but allow other formats to be used and therefore use the functions. It would probably make a large difference if you could just apply the format one for every record of the table. If you do not want to loose the current entries, you could do...

Does the error log say something? The funny names seem like error situations to me. Anyway, renaming and repairing should fix this. Off course, it is good to run ANALYZE TABLE on them first and run the backup. +++ Despite being wrong in every important aspect, that is a very good analogy +++...

Opening and closing a MySQL connection is pretty fast, and a connection also acts like a session (for example, SQL variables live as long as the connection lasts). So unless opening and closing a connection really gets in the way, be nice and use a connection per request or session. Using...

I think the EXPLAIN results explain everything. In Each case, there are two fields to filter upon, and one of the possible indexes to help is chosen. That means that the other filter has to be done in a temporary table or file (are you sure the EXPLAIN command does not tell you that?). Given...

If you did not write that game page, you are just breaking in. What you ask is essentially the same as "My friend serves delicious cookies when you visit him. How can I take a picture of his house and eat the cookie?". If you did write that page, you can write a page that returns just the data...

This will require the browser to read the file first, then hack the encoding out of it, and re-encode it. Putting the encoding in the encoded file is like keeping the key to a safe inside it. A better way is to use an http header (before any output is sent): header('Content-Type: text/html...

Tell the manager that programming and system maintenance are crafts, not surveyor-belt types of work. And that, off course, they should be managed as such. +++ Despite being wrong in every important aspect, that is a very good analogy +++ Hex (in Darwin's Watch)

If you want that answer from that database server and not from code, I think your best option is to write stored procedures or functions. +++ Despite being wrong in every important aspect, that is a very good analogy +++ Hex (in Darwin's Watch)

Look in the documentation for the INSERT ... ON DUPLICATE KEY statement. +++ Despite being wrong in every important aspect, that is a very good analogy +++ Hex (in Darwin's Watch)

This is an Ubuntu issue. For security reasons, AppArmour does not allow the database server to access just any files. So you will have to dive into AppArmour to enable this on Ubuntu. +++ Despite being wrong in every important aspect, that is a very good analogy +++ Hex (in Darwin's Watch)

I assume that you have one database server and different clients that connect to it. If that is not the case, and different machines have their own local databases, it might be the name of the table ("user"), which is also a keyword. But in that case, the SQL mode setting is different on the...

If you are on facebook, don't whine about your data being public. That is the whole idea of facebook, isn't it? +++ Despite being wrong in every important aspect, that is a very good analogy +++ Hex (in Darwin's Watch)

You don't even need to escape them. Standard string quotes in SQL are single quotes. That means that even MySQL will parse double quotes as identifiers if you put in in standard-abiding mode. To be independent of the server mode, always use single quotes for strings and backtics for identifiers...

From my own settings file: log="C:/Program Files/MySQL/MySQL Server 5.1/log/allqueries.sql" #log-bin="C:/Program Files/MySQL/MySQL Server 5.1/log/allqueries.bin" #log-bin-trust-function-creators=1 log_slow_queries="C:/Program Files/MySQL/MySQL Server 5.1/log/slowqueries.sql" Make sure that the...

Once you installed MySQL on Windows, do not forget to set: lower_case_table_names=2 In my.ini. This way, MySQL does not cripple the table names to lower case, but acts in a case-insensitive manner. +++ Despite being wrong in every important aspect, that is a very good analogy +++ Hex (in...

There are a few tips: An allocation is a part of the character encoding settings. I assume you are trying to set an allocation that is unknown to MySQL in a CREATE DATBASE statement or something like that. Use the command-line client. It executes the file without trying to load the whole thing...

A primary key is not "just a unique number". It is good to see it as an address. In any case, it should never have a meaning as data. Never. Like, your address in real life should also not depend on your hair colour or even change when you paint your hair. Can you imagine the mess when everybody...

There is something like Embedded MySQL, but there is no way to embed the server process in a PHP page as far as I know. As jpadie suggested, SQLite is fit for these purposes. +++ Despite being wrong in every important aspect, that is a very good analogy +++ Hex (in Darwin's Watch)

I use a separate php or python script to do the includes. See: http://www.howtoforge.com/node/4833 Hope this helps. +++ Despite being wrong in every important aspect, that is a very good analogy +++ Hex (in Darwin's Watch)

No. Only if you create the database itself with that collation. The connection collation has no influence on this. +++ Despite being wrong in every important aspect, that is a very good analogy +++ Hex (in Darwin's Watch)