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 gkittelson 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. simplyroberto

    UTC_TIMESTAMP()

    Hello, When I insert a new record in the database and I need to record a time, I usually do this: INSERT INTO table1 (field1, time) VALUES ('string', NOW()) The problem with NOW() is that it returns the local time of the server, whereas I want the GMT I understand that with MySQL5 you can...
  2. simplyroberto

    Index doesn't work with < or >

    I've noticed that MYSQL is not using indexes when the operators "<" or ">" are used in the SELECT query; For example: SELECT firstname FROM users WHERE birthyear < 1969 Now, birthyear is of type "int" and is indexed. However the EXPLAIN statement shows that all rows are examined! Can anyone...
  3. simplyroberto

    Is it possible to delete the last page in the browser history?

    Does anybody know if there is a way of preventing the browser from adding the current page to its history? I explain: I have a page that keeps loading itself every time the user make changes to it (like deleting a record displayed on the page). Now the user could potentially make several...
  4. simplyroberto

    How do you delete the last URL in the browser history?

    Thanks
  5. simplyroberto

    How do you delete the last URL in the browser history?

    Does anybody know if there is a way of preventing the browser from adding the current page to its history? I explain: I have a page that keeps loading itself every time the user make changes to it (like deleting a record displayed on the page). Now the user could potentially make several...

Part and Inventory Search

Back
Top