duanchi3109 2017-06-28 02:40
浏览 46


So I have a database called invoices and I have the user id in there and the date, I would like the user to be able to see all his invoices but not the others. So like my database is setup like

id | userid | amount | date | status

and I want the user to see his own invoices, how would I do that?

  • 写回答

1条回答 默认 最新

  • doubiaokai4998 2017-06-28 02:43

    That can be done with the query:

    SELECT * FROM invoices WHERE userid = [the userid of the user];

    You can also select specific columns of those rows like:

    SELECT amount FROM invoices WHERE userid = [the userid of the user];

    If you want more help, you'll have to explain what specifically you need help with!

    Hope this helps!

    Helpful Source - SQLCOURSE


    Oh I see what you mean!

    When you create a user (using the INSERT command), you can use RETURNING to ask for information from the rows you just created/populated:

    INSERT INTO invoices (userid, amount, date, status) VALUES ([some userid], [some amount], [some date], [some status]) RETURNING id;

    This is assuming id is populated by a serial input. You can also ask for any or all of the other rows you just populated. For example:

    INSERT INTO invoices (id, userid, amount, date, status) VALUES ([some id], [some userid], [some amount], [some date], [some status]) RETURNING *;

    本回答被题主选为最佳回答 , 对您是否有帮助呢?



  • ¥20 Html备忘录页面制作
  • ¥15 黄永刚的晶体塑性子程序中输入的材料参数里的晶体取向参数是什么形式的?
  • ¥20 数学建模来解决我这个问题
  • ¥15 计算机网络ip分片偏移量计算头部是-20还是-40呀
  • ¥15 stc15f2k60s2单片机关于流水灯,时钟,定时器,矩阵键盘等方面的综合问题
  • ¥15 YOLOv8已有一个初步的检测模型,想利用这个模型对新的图片进行自动标注,生成labellmg可以识别的数据,再手动修改。如何操作?
  • ¥30 NIRfast软件使用指导
  • ¥20 matlab仿真问题,求功率谱密度
  • ¥15 求micropython modbus-RTU 从机的代码或库?
  • ¥15 django5安装失败