Did you enable TCP/IP from Configuration manager? By default it is disabled and you need to enable it to connect from a remote client. To enable TCP/IP: 1. run SQL Server Configuration manager 2. select SQL Server Network Configuration 3. select Protocols for ‘instancename’ 4. right click on TCP/IP and select ‘enable’ Do …
Category Archives: MySQL
Mysql connect 3 Tables
SELECT *, (SELECT * FROM tb2 WHERE tb2.tb2_id=tb1.id LIMIT 1) as newname FROM ((tb1 Left Join tb3 ON tb3 = tb3)) WHERE tb1.ok=1 ORDER BY tb1.date DESC
My-sql comma values query
Show values 1,2,22,11 mysql_select_db($database_cdl_cms, $cdl_cms); $query_photos = “SELECT * FROM table WHERE ex_ID IN (1,2,22,11)”; $photos = mysql_query($query_photos, $cdl_cms) or die(mysql_error()); $row_photos = mysql_fetch_assoc($photos); $totalRows_photos = mysql_num_rows($photos); or LIKE ‘%”.$_GET[‘cc_id’].”%’
Mysql ORDER by Random
“SELECT * FROM talbe ORDER BY RAND()”;