FrenchTech SAAS
33.5K views |
+5 today
 Your new post is loading...
Your new post is loading...
Scoop.it!
There are a lot of occasions for converting one data type to another in MySQL. All of these can be achieved using MySQL's native CONVERT() and CAST() functions. Read on to learn how to use both.
Scoop.it!
Ever since Oracle became the owner of MySQL when it acquired Sun Microsystems in 2010, improvements to the software haven’t been as forthcoming as one might hope. There still doesn’t seem to be anything like groups in MySQL.
Scoop.it!
Rob Gravelle lists his top 10 MySQL best practices for database administrators,architects, developers, and security personnel.
Scoop.it!
About two years ago, we’ve published this post about the 10 most popular DB engines, where we analyzed the data published by Solid IT on their DB Ranking website.
Scoop.it!
In the Importing XML Data into MySQL Tables Using a Stored Procedure article, Rob Gravelle outlined some ways to work around MySQL's restrictions on stored procedures to import XML data into your MySQL database tables.
Scoop.it!
I’m seeing people do this all the time. They want to hammer a date or timestamp constant into their SQL query, and the only function they know is the TO_DATE() or TO_TIMESTAMP() date parsing function: SELECT TO_DATE ('20150801', 'yyyymmdd') FROM...
Scoop.it!
Parfois , certain résultat requiert des requêtes plus au moins complexes. Dans la plupart des cas, pour de petits projets personnels un simple "SELECT" + une jointure
Scoop.it!
Play with our RESTful database interface in this interactive REST tutorial
Scoop.it!
When designing a database schema, it's often important to assign a unique identifier to each record.
Scoop.it!
Toute personne traitant des données à caractère personnel vous le dira. La principale difficulté résultant du droit de la protection des données est le recueil du consentement.
|
Scoop.it!
Oracle a annoncé la disponibilité de MySQL 5.7 qui s’accompagne d’une amélioration des performances, de la sécurité, de l’évolutivité et de l’administration. L’éditeur précise qu’elle intègre des fonctions NoSQL enrichies avec le support de JSON et MySQL Router qui facilite la connexion des applications à plusieurs bases de données MySQL.
Scoop.it!
Rob Gravelle provides an overview of reporting tool types as well as some practical experience in report building using the reporting facilities of the Navicat for MySQL database administration GUI.
Scoop.it!
The result of slavish adherence to 3NF in database design can lead to over-engineering; the evidence of which include inflexible design schemas and cumbersome data retrieval.
Scoop.it!
Il existe plusieurs règles (appelées formes normales) afin de normaliser une base de données. Il en existe 8 au total, dont une est très peu utilisée. Pour ma part, je vais vous présenter les 3 que je considère comme fondamentales et nécessaires à la compréhension de cet article.
Scoop.it!
Capturing data is a critical part of performing a query analysis, or even just to have an idea of what’s going on inside the database.
Scoop.it!
Considering that mySQL is a quite popular database for web applications, you may be surprised that its XML support is quite basic, compared to other databases.
Scoop.it!
When first introduced, a script or application process had to parse XML data and convert it into a valid format for the database and underlying system. Later, databases started to support XML so that no conversion was necessary.
Scoop.it!
DreamFactory is a free, open source software package that provides a complete REST API for mobile, web, and IoT applications.
Scoop.it!
I was positively surprised to see how popular my recent listing about 10 Common Mistakes Java Developers Make when Writing SQL was, both on my own blog and on my syndication partner DZone. The popu...
|
