Notices tagged with sql
-
Found a #SQL query for !gnusocial to remote #UTM #click-tracking: UPDATE `file` SET `url` = SUBSTRING_INDEX(`url`, '?utm_', 1) WHERE `url` LIKE '%?utm_%'
-
@mmn I like #JPA for a good reason, having no #SQL in your program but still be able to do queries (e.g. named queries) with #JPQL (Java Persistence Query Language) which is independent from underlaying database server. Theoretical you can switch from #MySQL to e.g. #PostgreSQL an it *should* work out-of-the-box as long as you don't use native (hard-coded) queries.
-
@theru @nybill I'm not an #SQL guru, but ISTM there should be a way to use 'UPDATE' to replace http with https in #FragDev users' URLs.
I'm sure that @mmn would love it if someone could submit such a script as the basis for a patch.
-
#sql so ..... :-) Persönliche Daten von 49 Millionen türkischen Wählern veröffentlicht - https://gnusocial.no/url/145846
-
For the last 3 (!) days (including today) I tried to fix the problem that while the #JPA is merging (similar to UPDATE #SQL statement) entities, some tables got filled with new rows (search for "eclipselink insert instead update") which leaves orphaned rows behind. I could enable orphanRemoval=true but that only adds another performance penalty. So I decided to switch to #Hibernate instead of remaining with #EclipseLink. cc !java
-
@mcscx database management on the command-line? Sounds nice. I should learn how to interact with dB's with #sql
-
@deavmi and #sql ;-)
-
#TOP10 user list:
SELECT `n`.`profile_id` , `p`.`nickname` , `p`.`profileurl` , COUNT( `n`.`id` ) AS `dents`
FROM `notice` AS `n`
INNER JOIN `profile` AS `p` ON `p`.`id` = `n`.`profile_id`
GROUP BY `n`.`profile_id`
ORDER BY `dents` DESC
LIMIT 10
#SQL
-
#SQL Injection License Plate Hopes to Foil Euro Traffic Cameras: http://qttr.at/h65 #police #security #bug #lol #itnews