Database

PIEBALDconsult wrote:

pass a class or struct

Mycroft Holmes wrote:

How did you get that from the OP.

SELECT

CASE WHEN NUM1 = 10 THEN 1 ELSE 0 END + 
CASE WHEN NUM2 = 10 THEN 1 ELSE 0 END + 
CASE WHEN NUM3 = 10 THEN 1 ELSE 0 END +
CASE WHEN NUM4 = 10 THEN 1 ELSE 0 END +
CASE WHEN NUM5 = 10 THEN 1 ELSE 0 END +
CASE WHEN NUM6 = 10 THEN 1 ELSE 0 END
AS TOTAL

FROM MYTABLE

SELECT num1,count(*) FROM NumaraBilgileri
GROUP BY num1

SELECT A.NUM, SUM(A.TOTAL) AS TOTAL FROM (
SELECT num1 AS NUM,count(*) AS TOTAL FROM NumaraBilgileri
GROUP BY num1
UNION ALL
SELECT num2 AS NUM,count(*) AS TOTAL  FROM NumaraBilgileri
GROUP BY num2
) AS A
GROUP BY A.NUM

Alireza Loghmani wrote:

Which way is better to save these content (long HTML with several pictures)?

I are Troll

Alireza Loghmani wrote:

Save them in db or save them on disk?

select sum(activation_number)+1 from mytable

I are Troll :suss:

CREATE TABLE animals 
(
     id BIGINT NOT NULL AUTO_INCREMENT,
     name CHAR(30) NOT NULL,
     PRIMARY KEY (id)
) ENGINE=MyISAM;

I are Troll