我该怎么做这个查询？

本文介绍了我该怎么做这个查询？的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

我希望我知道这叫做什么，我本可以做出更明智的 主题。就此而言，我知道它叫什么，我可以用谷歌搜索它！ 无论如何，让我有一张名字，类，等级的桌子。 joe bio a jill chem b john psych b john chem a jill pysch a 我希望将结果显示为 名称bio psych chem joe a - - jill - ab john - ba 有没有办法用sql做到这一点？怎么样用PHP的SQL？ 非常感谢！ Manny - manny @不要发垃圾邮件

I wish I knew what this was called, and I could have made a more sensible subject. For that matter, I knew what it was called, I could have googled it! Anyway, let''s I have a table with name, class, grade. joe bio a jill chem b john psych b john chem a jill pysch a and I want to display the results as name bio psych chem joe a - - jill - a b john - b a Is there a way to do this with sql? How about sql with php? Thanks much! Manny -- manny@don''t spam on me

推荐答案

manny写道： 无论如何，让我来吧有一张名字，班级，等级的桌子。 joe bio a jill chem b john psych b john chem a jill pysch a 我希望将结果显示为 名称生物心理化学 joe a - - jill - ab john - ba 有没有办法用sql做到这一点？如何使用php进行sql？ Anyway, let''s I have a table with name, class, grade. joe bio a jill chem b john psych b john chem a jill pysch a and I want to display the results as name bio psych chem joe a - - jill - a b john - b a Is there a way to do this with sql? How about sql with php?

创建新表（name = key），使用insert 在新表中插入旧数据。 ...选择和一式两份条款，请参阅 http：// dev .mysql / doc / refman / 4.1 / en / insert.html - E. Dronkert

Create new table (name=key), insert old data in new table using "insert .... select" and "on duplicate" clause, see dev.mysql/doc/refman/4.1/en/insert.html -- E. Dronkert

使用PHP和MySQL显示它会相当容易。这是我要使用的 算法： To display it is going to be fairly easy with PHP and MySQL. Here''s the algorithm I''d use:

sql =" SELECT * FROM table_name" ;; sql = "SELECT * FROM table_name";