So I have a beautiful installation of mySQL. I now need to open the
pipe to my 3306 port to the outside world directly. When I have people
ping my IP, they get a restricted bounce error message. I assume there
is a configuration file that needs to be backed off, but I can't seem
to find
I have to do an insert and need to nest a select inside. I have tons of
documentation on a very simple version of this, however my requirements
are one step beyond that. Here is what I'd like to do in MySQL:
insert into
table1
(column1, column2)
values
(select column1a from table2 where
I need to do a join with a count...but for some reason I can¹t figure out
how to do it using MySQL. I¹m hoping that this pseudo code can help you give
me an answer:
select
f.count(*),
s.name
from
first f, second s
where
f.id = s.id
How do I get a sql result like:
Is there a nifty way to select just that last 100 records with MySQL? In
Oracle I use Maxrows and date to accomplish this. Can¹t seem to figure this
out with MySQL.
Please advise! Thank you!
Mark