Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. DonQuichote

    Query in loop becomes really slow

    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...
  2. DonQuichote

    Reinstallation Issues

    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 +++...
  3. DonQuichote

    Effective programming

    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...
  4. DonQuichote

    Almost Identical Selects; Vastly Different Results

    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...
  5. DonQuichote

    use a variable's value from another page?

    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...
  6. DonQuichote

    How do I allow foreign characters through php to the database

    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...
  7. DonQuichote

    challenges and non technical managers

    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)
  8. DonQuichote

    Calculating Winning and Losing Streaks?

    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)
  9. DonQuichote

    Rotate Records to Update

    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)
  10. DonQuichote

    Problem with LOAD_FILE

    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)
  11. DonQuichote

    MySQL - Query Hanging

    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...
  12. DonQuichote

    Facebook Jobs Board--Please, Zuckerberg, Don't Do This!

    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)
  13. DonQuichote

    how to place inch symbol in table?

    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...
  14. DonQuichote

    How to get general and slow query logs functional?

    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...
  15. DonQuichote

    MySQL on windows XP

    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...
  16. DonQuichote

    Restoring 25gb File into MySQL

    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...
  17. DonQuichote

    Primary Key begins at 5180 and not '1' - why ???

    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...
  18. DonQuichote

    Portable MySql Databases

    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)
  19. DonQuichote

    Running scripts batch

    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)
  20. DonQuichote

    MySQL Collation

    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)

Part and Inventory Search

Back
Top