写一个查询语句,看你会不会!!!!!! 在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' 一服务器JSP与MYSQL连接问题,实在解决不了,求助! mysql的添加并取出问题 10多万的表为什么查询这么慢呢 执行.sql脚本问题? php+mysql中读取一个表的数据后写入别一个表报字符格式出错 如何执行脚本文件 循环扫描MySQL表 请问,如何把erwin 设计出来的表结构导成mysql可以用的sql脚本?在线等啊(就这些分了) mysql里面没有做过特别设置为什么会产生奇数主键? 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>";
}一个简单示例。