写一个查询语句,看你会不会!!!!!! 在PG中用查询B1表中的某个元素,并输出该元素的所在行的全部元素及其对应的字段?大哥帮帮忙 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 mysql> select * from user;+--------+-----------+| userid | username |+--------+-----------+| 2 | 螟ァ譏ッ荳ェ || 3 | 譏ッ蠕キ蝗ス || 4 | || 5 | 莠懶ス難ス・ || 6 | 螢ォ螟ァ螟ォ || 7 | d || 8 | 螳俶婿 || 9 | ? |+--------+-----------+8 rows in set (0.00 sec)mysql> select user.* from user where userid=7;+--------+----------+| userid | username |+--------+----------+| 7 | d |+--------+----------+1 row in set (0.02 sec)你的意思是通过userid找到user表所有的字段? 比如有个表:table1+------+----------+---------+| ID | NAME | CARD |+------+----------+---------+| 1 | HA | 01 || 2 | AD | 02 || 3 | RE | 03 |+------+----------+---------+如果CARD=02 时输出:+------+----------+---------+| ID | NAME | CARD |+------+----------+---------+| 2 | AD | 02 |+------+----------+---------+要怎写?这样应该够详细了吧 select * from table1 where CARD=02? select * from table1 where CARD='02'; 呵呵,select * from table1 where CARD='02';这样就行了嘛 和PHP想结合呢?又怎么写?????????????? $conn = mysql_connect("host","username","password");mysql_select_db("database_name");$sql = "select * from table1 where CARD='02'";$result = mysql_query($sql,$conn);while($row = mysql_fetch_array($result)){ echo "ID=".$row["ID"]." NAME=".$row["NAME"]." CARD=".$row["CARD"]."<br>";}一个简单示例。 select * from table1 where CARD='02' 为什么我的Mysql修改不了管理员密码 问个概念性的问题,关于自增字段,没查到相关资料 mysql中文乱码 我快疯了,求教这是什么错误 请教:MYSQL数据查询问题~ 请教:mysql 小问题!请一定帮忙的! 关于auto_increment字段 mysql服务无法启动 error:1067 求助 我产品数据库有65万数据,查询起来很慢很慢。 求高手帮忙解决 SQL语句中FREETEXTTABLE在mysql怎么实现 新手提问一个比较简单的MYSQL语句 求一SQL语句,只保留一个字段中后面几个字符。
+--------+-----------+
| userid | username |
+--------+-----------+
| 2 | 螟ァ譏ッ荳ェ |
| 3 | 譏ッ蠕キ蝗ス |
| 4 | |
| 5 | 莠懶ス難ス・ |
| 6 | 螢ォ螟ァ螟ォ |
| 7 | d |
| 8 | 螳俶婿 |
| 9 | ? |
+--------+-----------+
8 rows in set (0.00 sec)mysql> select user.* from user where userid=7;
+--------+----------+
| userid | username |
+--------+----------+
| 7 | d |
+--------+----------+
1 row in set (0.02 sec)
你的意思是通过userid找到user表所有的字段?
比如有个表:table1
+------+----------+---------+
| ID | NAME | CARD |
+------+----------+---------+
| 1 | HA | 01 |
| 2 | AD | 02 |
| 3 | RE | 03 |
+------+----------+---------+
如果CARD=02 时输出:
+------+----------+---------+
| ID | NAME | CARD |
+------+----------+---------+
| 2 | AD | 02 |
+------+----------+---------+要怎写?这样应该够详细了吧
select * from table1 where CARD=02
?
select * from table1 where CARD='02';
这样就行了嘛
$conn = mysql_connect("host","username","password");
mysql_select_db("database_name");
$sql = "select * from table1 where CARD='02'";
$result = mysql_query($sql,$conn);
while($row = mysql_fetch_array($result)){
echo "ID=".$row["ID"]." NAME=".$row["NAME"]." CARD=".$row["CARD"]."<br>";
}一个简单示例。