So I have this table: I am trying to produce a column that will look like this (containing the computed results) I tried this query by it gives an error SELECT Name, SUM(Amount) AS TAmnt, ProductPrice-SUM(Amount) AS OutB FROM t1…
I have a column of dates written as strings with "am" and "pm" at the end, for example: 1/1/2016 12:00:00.000 AM The type of the column is currently varchar, I want to change the type to datetime format. Attempt 1…
I am new to Codeigniter, Having error in mysql while using IF Statement, Here is my Code $this->db->select('A.city_id, A.`name` AS city_name, B.`name` AS state_name, C.`name` AS country_name, IF(`A.visible`,"Yes","No") AS active'); $this->db->from('abs_city AS A'); $this->db->join('abs_state AS B', 'A.state_id = B.state_id AND…
I cannot find answer on google on that anywhere (because of SEO and nature of english language I cannot ask correct question as I am not native) I'll try to explain as simple as I can: I connected to mysql…
I have two tables which I'm trying to run a query on. If I run the below query in phpmyadmin I get the results I expect, just one result returned with id 9, but when running it on my webpage,…
I want to insert this: INSERT INTO NAVE (nume, clasa, anul_lansarii) values ('Ticonderoga','Ticonderoga',to_date('02/02/1930','mm/dd/yyyy') ); and gives me the error: 1305 - FUNCTION proiect.to_date does not exist
I have a table called users with a couple dozen columns such as height, weight, city, state, country, age, gender etc... The only keys/indices on the table are for the columns id and email. I have a search feature on…
I have a table with titles in Cyrillic alphabet. LIKE seems to ignore certain words in Russian. Collation UTF8_general_ci. I tried execute request from php as well as from PHPMyAdmin. What can be possible reason? SELECT * FROM `table` WHERE…
I need to get best selling product from woocommerce here i have a query that bring me best selling product but there is no data about product images or product URl i need those too. SELECT * FROM wp_posts INNER…
I have two tables for statistics events, and sessions, here is how they look Here Sessions Table Showing rows 0 - 29 (4 730 018 total)) And here is events table Showing rows 0 - 29 (3686 total) Now here…