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 Mike Lewis 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?!
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... -
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... -
Making Required Fields in MySQL
Check the form fields for values using javascript and don't submit the data if there's something missing.<br> <br> -
updating columns by select
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> -
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>
