MySQL_Community (@MySQL_Community@fosstodon.org)
#MySQL Enterprise and MySQL HeatWave in #OracleCloud support using JavaScript to create stored functions and procedures.
Check out this post that shows how to create a stored function using #JavaScript that allows us to search the values of a #JSON array.
https://blogs.oracle.com/mysql/post/using-javascript-to-search-json-arrays-in-mysql
Show Original Post
dandb (@dandb@mas.to)
If I had a dollar for every time I think "why you gotta be this way" about #MySQL I'd be a very wealthy person.
Anyways, I guess I have to look up the ids for these upserts ffs
Show Original Post
lefred (@lefred@fosstodon.org)
Some #MySQL goodies are already available for the #GroningenPHP Meetup #MySQLCommunity … and I’ve heard that there might be some Sakila too 🐬
Show Original Post
lefred (@lefred@fosstodon.org)
On my way to Groningen 🇳🇱 for #groningenPHP Meetup on #MySQL
Show Original Post
askubuntu (@askubuntu@ubuntu.social)
Ubuntu Server 20.04 Java mysql-connector-j-8.0.33.jar in PATH to connect to mysql database from java app main #2004 #java #mysql
https://askubuntu.com/q/1512413/612
Show Original Post
MySQL_Community (@MySQL_Community@fosstodon.org)
Final reminder for the meetup tomorrow in Groningen with Frederic Descamps!! Last seats available!
https://www.meetup.com/groningenphp/events/299898250/
Show Original Post
pwaring (@pwaring@fosstodon.org)
TIL: If you try to manually INSERT a row into a MySQL table and set an AUTO_INCREMENT column to 0, MySQL ignores the provided value and assumes you want the next increment amount.
Found this whilst migrating a legacy database to a new structure, where the legacy database had foreign keys (not actually defined as constraints) with 0 values.
You can control this with NO_AUTO_VALUE_ON_ZERO in sql_mode (it's on by default I think).
Show Original Post
lefred (@lefred@fosstodon.org)
#MySQL 8.4 LTS – new production-ready defaults for InnoDB 🐬 8️⃣ .4️⃣ https://lefred.be/content/mysql-8-4-lts-new-production-ready-defaults-for-innodb/
Show Original Post
lefred (@lefred@fosstodon.org)
MySQL 8.4 LTS – new production-ready defaults for InnoDB
Yesterday, MySQL 8.4, the very first LTS version of MySQL was released.
A lot of deprecations have finally been removed, and several InnoDB variable default values have been modified to match current workloads and hardware specifications.
The default value of 20 InnoDB variables has been modified!
Let's have a look
https://lefred.be/content/mysql-8-4-lts-new-production-ready-defaults-for-innodb/
#84 #InnoDB #LTS #MySQL
Show Original Post
audricd (@audricd@tkz.one)
Me pueden recomendar / aconsejar para #websencilla ?
Si quiero sacar contenido de un #mysql , cual es el mejor método? #php ? #django ? #java ? Otros?
@maestrapaladin
@fanta
Show Original Post
habr (@habr@zhub.link)
Большая иерархия в SQL запросе + PostgreSQL
Сначала запрос адаптирован для работы в PostgreSQL 15.6. Затем работа запроса проверена на достаточно объемной иерархии - в качестве источника данных использована структура архива jdk-master.zip из OpenJDK 22
https://habr.com/ru/articles/811523/
#MySQL #SQL #common_table_expression #cte #with_recursive #Иерархические_структуры_в_SQL #Обобщенные_табличные_выражения #sqlite #sqlite3 #postgresql
Show Original Post
guiadeti (@guiadeti@flipboard.social)
Curso de Programação em PHP, Robótica E Mais Opções Gratuitas
#css #cursosgratuitos #empreendedorismo #html #informatica #javascript #mysql #php #programacao #redesdecomputadores #robotica #tecnologia
https://guiadeti.com.br/curso-de-programacao-em-php-robotica-gratuitos/?feed_id=4604&_unique_id=66312308ae3f6
Show Original Post