yes, I got a dump in form of sql-statements. how do I run these (huge) sql-statements to build the new database? mysqlimport doesn't seem to work properly with 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...
It doesn't work well, I'm using MySQL and I tried something easier and similiar to yours, but not even that works:<br>
<br>
SELECT * FROM books WHERE category IN (SELECT * FROM categories)<br>
<br>
Wtf? Any idea?<br>
<br>
Thanks!<br>
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...
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>
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.