SQL
SQL stands for structured query language. It uses commands such as "select", "insert", "update", "delete". Some common relational database management systems that use SQL are: Oracle, MySQL, Microsoft SQL Server, PostgreSQL, etc.
Here are 1,134 public repositories matching this topic...
-
Updated
Jun 19, 2020 - PHP
Consolidating discussion from #71, #66, #58, #31 to document the plan for implementing modifications to queries. This applies mainly to SELECT but also other queries.
WIP: This issue will be modified until a clear plan is made.
Currently some methods in Latitude are additive and some are setters. For instance, columns() always changes the column list and join() always adds a new
Hi there! I have one main calendar for work that pulls in a ton of information from a few sources so I can get an idea of the day/week/month at a glance. Is there a way to add the leantime calendar subscription to my existing calendar (that I'm not seeing?) or is this in the works? It would be super useful!
Thanks for everything!!!
Hi, i'm currently using Directus v7. It's the first time I use hooks. There is a way to have different hooks for each project. Because if in my projects I have some collections with the same name. I can't understand how to distinguish them.
Example of my hook:
return [ 'actions' => [ 'item.update.courses' => function (array $data) { //code } ] ];
Expected:
-
Updated
Jun 28, 2020 - PHP
PHP 7.0
->setTable('user')
->setColumns(['userId' => 'user_id', 'username' => 'name', 'email' => 'email']);
echo $builder->write($query);
`
``` [Symfony\Component\Debug\Exception\FatalThrowableError]
Type error: Argument 1 passed to NilPortugues\Sql\QueryBuilder\Builder\GenericBuilder::write() must implement interface NilPo
MySQL 8.0 supports Descending Indexes, export doesn't recognize the optional "DESC" key_part during parsing. DESC option creates invalid export. "DESC" flag is parsed as the column name in output. ADD KEY `entries__ug` (`DESC`);
Index can be created with the follow
When an 'Email' field type is added within addFields(), it is ignored. This might be a problem for other new fields as well but I haven't tested.
// Works
$model->addField('email', ['Email']);
// Doesn't work
$model->addFields([['email', ['Email']]]);
-
Updated
Apr 30, 2020 - PHP
Demo: http://skinwinners.com/history.html
What you'll need:
- The updated version of the website with the history.html and get-history.php page.
- http://www.tippedjs.com for tooltips
Refer to this hastebin for the sections: http://hastebin.com/ohemujidev.coffee
This is incredibly easy.
- Download Tippedjs and put it into your website directory in the /css and /js file. The file paths for Tip
-
Updated
Jun 24, 2020 - PHP
-
Updated
Oct 8, 2019 - PHP
-
Updated
May 19, 2020 - PHP
-
Updated
Jun 3, 2020 - PHP
-
Updated
Mar 5, 2020 - PHP
We already have most of our Directus API 2.x endpoints/params within Paw for testing. We could finish adding all of these and then potentially use their code generators to create SDKs for our secondary languages.
https://paw.cloud/docs/extensions/create-code-generator
We also have a Swagger file for 98% of API 1.1 — so we could update that (and make sure that OpenAPI allows for our filteri