database database-queries

thanks for taking the time to read this. Essentially I have 3 tables. Posts, Follows, Artists. What I am trying to do is pull all the 'Posts' from…

I have a plans table: tariff | monthly_cost -------------------------- Lion , 15.00 Lion , 20.00 Cat , 15.00 Cat , 20.00 Cat Extra , 20.00 Cat Extra…

I am a newbie to prepared statements and trying to get something simple to work. This is my DB table: `unblocker_users` ( `uno` bigint(20) NOT NULL…

I am trying to add one more column of output to my result set in MySQL. I can easily get these results by doing two separate queries, but I would…

I'm importing a csv file to a mysql db. Haven't looked into bulk insert yet, but was wondering is it more efficient to construct a massive INSERT…

Given the db design below, if I need to populate BusinessId & UserId when a new Party is created and assigned a PartyType of either B (Business)…

How do I avoid a dup column name error in MySQL when creating a VIEW on two tables that both have the same column name as shown here CREATE VIEW…

Is it possible and if so how would I accomplish an INSERT in a MySQL db utilizing Subtype/Supertype? I asked about the approach here and Catcall…

How do I get the Total value of Yes, No, Other fields of each username? I like to add Total field. SELECT Username, SUM(CASE WHEN type = 'Yes' THEN…

Hi, Our database is currently running and everything seems to fine. I wanted to do some statistics so I did some standard calls. Basically I wanted…

I am trying to create a query where a user can enter: first name, last name, nick name, grade, and gender. However, some of these fields may be…

i have three table member ( memberid ,m_name,statusid,address,DOB,phone) booking ( bookingid , memberid ,sessionid, cost) session( sessionid ,…

How do I comebine multiple queries into one? For example: //Successful Sales: SELECT username, count(*) as TotalSales, sum(point) as Points FROM…

Hi. I am trying to insert into my table, but only if the information doesn't exist already. This works: $sql = //"if not exists ( select `id` from…

Hi. This has annoyed me for a while now. I am trying this query in phpmyadmin. select `id` from `users` where `fb_id` = 507292797 limit 1 This…

Basically what I am trying to do is load my database (romskillDB.db) from my assets folder and then query for the information I want. I have tried…

I opened two command windows to work with my Database (MySQL5). Below is table structure I'm working with (It should be noted that I've turned off…

I have a log for documents that go through my application. The log looks like this: TABLE: log ================================================== |…

Hi folks, Daft SQL question. I have a table like so ('pid' is auto-increment primary col) pid | cost | timestamp | rid…

I have the following two queries and I wonder what's more efficient to do: a) to use a subquery and an inner join or b) to call CONVERT_TZ() several…