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!
-
Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
moving mysql-data files?!
I've moved my database, which is rather large to another machine, which is not on a network but has mysql for win installed. I'm using phpadmin to manage tables and stuff. it shows all table-meta-data, but whenever I try to "browse" through the data of the tables, I get an... -
updating columns by select
I've got 2 tables, table A lists all categories and the second table lists all books (name, category). Now, I'm using the following statement to view the number of books per category:<br> <br> SELECT category, COUNT(category) FROM books GROUP BY category<br> <br> Although this ignores all... -
variables via mysql
the docs say somthing like this works:<br> <br> SELECT @a:=COUNT(bla) FROM table GROUP BY bla<br> <br> but it doesn't, I always get an error, why?<br> <br>
