48
Articles avaible
In the databases
666
Registered Users
On the website
00:00
Loading...
Europe/Brussels

Compter le nombre d'occurence d'un objet d'une table mySQL

Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.

SELECT LENGTH(NomP) as Nombre, NomP, Prenom FROM `personne_contact` ORDER BY Nombre DESC

Permet de compter le nombre de connections effectués par chaque personne de la BDD sur l'extranet
SELECT COUNT(iduser) AS Connection, NomP, Prenom, sigle, nom FROM log_session L JOIN personne_contact PC ON L.iduser=PC.idper JOIN personnel P ON PC.idper=P.id_pers JOIN contact C ON C.idcon=P.id_org WHERE timestamp LIKE "%2014%" AND P.etat=1 GROUP BY NomP ASC WITH ROLLUP

SELECT COUNT(iduser) AS Connection, NomP, Prenom, sigle, nom FROM log_session L JOIN personne_contact PC ON L.iduser=PC.idper JOIN personnel P ON PC.idper=P.id_pers JOIN contact C ON C.idcon=P.id_org WHERE timestamp LIKE "%2014%" AND P.etat=1 GROUP BY NomP ASC WITH ROLLUP

SELECT idper as session, idper, Prenom, NomP FROM `log_session` L JOIN personne_contact PC ON L.iduser=PC.idper WHERE idper IN (SELECT DISTINCT (iduser) FROM `log_session` WHERE timestamp LIKE "%2014-%") AND timestamp LIKE "%2014-%" ORDER BY idper ASC

SELECT u.name name, FROM_UNIXTIME(u.login) AS login, FROM_UNIXTIME(u.access) AS access, FROM_UNIXTIME(u.created) AS created, usv.value value, usi.ip_address ip_address, FROM_UNIXTIME(usi.first_seen_timestamp) AS first_seen_timestamp FROM users u JOIN user_stats_values usv ON u.uid = usv.uid JOIN user_stats_ips usi ON usv.uid = usi.uid WHERE usv.name = 'login_count' AND u.mail ='mail@domain.tld'

SELECT count(u.name) as compteur, u.name name, u.login login, u.access access, u.created created, usv.value value, usi.ip_address ip_address, FROM_UNIXTIME(usi.first_seen_timestamp) first_seen_timestamp FROM users u JOIN user_stats_values usv ON u.uid = usv.uid JOIN user_stats_ips usi ON usv.uid = usi.uid WHERE usv.name = 'login_count' AND u.mail ='mail@domain.tld' ORDER BY `first_seen_timestamp` ASC

SELECT count(u.name) as compteur, u.name name, u.mail email, FROM_UNIXTIME(u.login) login, FROM_UNIXTIME(u.access) access, FROM_UNIXTIME(u.created) created, usv.value value, usi.ip_address ip_address, FROM_UNIXTIME(usi.first_seen_timestamp) first_seen_timestamp FROM users u JOIN user_stats_values usv ON u.uid = usv.uid JOIN user_stats_ips usi ON usv.uid = usi.uid WHERE usv.name = 'login_count' AND u.mail IN (SELECT mail FROM `users` WHERE mail <> '') GROUP BY u.mail ASC WITH ROLLUP

SELECT count(u.name) as compteur, u.name name, u.mail email, FROM_UNIXTIME(u.login) login, FROM_UNIXTIME(u.access) access, FROM_UNIXTIME(u.created) created, usv.value value, usi.ip_address ip_address, FROM_UNIXTIME(usi.first_seen_timestamp) first_seen_timestamp FROM users u JOIN user_stats_values usv ON u.uid = usv.uid JOIN user_stats_ips usi ON usv.uid = usi.uid WHERE usv.name = 'login_count' AND u.mail IN (SELECT mail FROM `users` WHERE mail <> '') GROUP BY u.mail ASC ORDER BY `first_seen_timestamp` ASC

Categorie-s

Readers Location

Highlighting country from Readers
Belgium
42.86%
42.86%
Senegal
28.57%
28.57%
Morocco
14.29%
14.29%
France
9.52%
9.52%

Data update in end of each hour. You can update it manual by pressign update button

Articles

Articles report
Subject Activity
Web Development
85%
Networking
40%
Linux
72%
AngularJS
80%
Virtualization
100%
Microsoft Windows
100%

Articles

Benchmarking Guidelines

Membership

How to do a strategic analysis

Visitors

Visitors (last month)

Website builded by Pipo Bengeloune with the famous Drupal CMS.

Log Out ?

Are you sure you want to log out?

Press No if you want to continue work. Press Yes to logout current user.