Snipplr

(MySQL) mysql make access global - surentharp

Thu, 21 Jun 2018 20:02:49 UTC

This commands are useful in creating a username in mysql and it can be used to access the mysql globally with this username.

(Python) MySql workbench add created and modified columns for CAKEPHP - acosonic

Thu, 12 Oct 2017 23:23:19 UTC

Name this script whatever you want, and run it via Workbench Scripting shell

(Java) Connect To A MySQL Database - syedhussim

Tue, 27 Jun 2017 18:42:28 UTC

This code snippet shows how to connect to a MySQL database using Connector/J.

(MySQL) Get Random Record Based on Weight - apphp-snippets

Wed, 14 Jun 2017 06:22:21 UTC

This snippet allows you to get random record from given table by weight. To run it, it must have a field named "weight". The more "weight" is assigned, the more often the record is selected. The value of "weight" should be an integer between 1 and 10 (or anything else).

(SQL) Insert or Update Record if Unique Key Already Exists - apphp-snippets

Wed, 14 Jun 2017 06:21:25 UTC

This snippet allows you to insert new record into table. In case a unique key already exists - it updates appropriate fields only, leaving other fields untouched.

(MySQL) Configuration Mysql 5.7 - ironcrema

Sat, 27 May 2017 02:31:41 UTC

Some configurations for mysql 5.7

(MySQL) Show the output of a query in a more readable vertical format - rm1984

Thu, 30 Jun 2016 18:33:28 UTC

Show the output of a query in a more readable vertical format

(SQL) mysql pivot data - ktrout

Sun, 10 Jan 2016 16:52:37 UTC

pivot data. input source query in the form : +--------+-----------+-------------+-------------+ | name | pivot_fid | pivot_fname | pivot_value | +--------+-----------+-------------+-------------+ | apple | 1 | is red | 1 | | apple | 2 | is blue | 0 | | orange | 1 | is red | 1 | | orange | 2 | is blue | 0 | +--------+-----------+-------------+-------------+ and fields to pivot around ( eg. name ), outputs : +--------+--------+---------+ | name | is red | is blue | +--------+--------+---------+ | apple | 1 | 0 | | orange | 1 | 0 | +--------+--------+---------+

(SQL) mysql procedure throw_error - ktrout

Sun, 03 Jan 2016 20:43:30 UTC

procedure to throw application defined error

(SQL) mysql rank with ties - ktrout

Sun, 03 Jan 2016 14:10:07 UTC

calculate rank ( with ties ) over points table

(SQL) mysql clone table with structure and indexes - ktrout

Sun, 03 Jan 2016 13:52:46 UTC

clone table with structure and indexes

(SQL) mysql unroll variable length string list - ktrout

Sun, 03 Jan 2016 13:43:52 UTC

unroll variable length string list to normalised form.

(SQL) mysql tablename search information schema - ktrout

Sun, 03 Jan 2016 13:32:34 UTC

search for tables in mysql catalog ( information_schema )

(SQL) mysql batch sql statements - ktrout

Sun, 03 Jan 2016 13:26:43 UTC

stored procedure for executing batch sql statements

(SQL) mysql calendar table - ktrout

Sun, 03 Jan 2016 13:15:46 UTC

creates a minimal calendar table

(SQL) mysql sequence generator ( decimal definition ) - ktrout

Sun, 03 Jan 2016 13:09:01 UTC

one cross join for each ai in definition of decimal number as sum(ai*10^i)

(PHP) php code example - johnschneider

Sun, 12 Apr 2015 01:40:13 UTC

example of php code I worked on

(PHP) PHP - Doctrine - Left join ON condition AND other condition syntax in Doctrine - satie83

Fri, 20 Mar 2015 00:36:12 UTC

In SQL I can get this by adding AND to the join LEFT JOIN installations i ON a.id = i.app AND i.page = :page This way I get the installation info for an app that has an installation on the page, but I get null values on the columns for app's that have installations on other pages or not at all. Is there a way to do this in Doctrine or am I better off just getting all the installations for each application and then checking against the found page with php? ########################################################################## See function leftJoin in doc: http://docs.doctrine-project.org/projects/doctrine-orm/en/latest/reference/query-builder.html#high-level-api-methods

(VB.NET) VB.NET SQL Example: How to send SMS in VB.NET using SQL database - LoganTurn

Mon, 16 Mar 2015 17:18:43 UTC

I thought I share this code snippet because I find this way of SMS sending an easy solution. I believe that even beginners can implement this VB.NET SQL SMS application, but I think some extent of perfection in the SMS technology is required for better understanding. Okay, letâ€™s jump right in the middle of the project that allows you to send and receive SMS through database tables by using your own VB.NET application. Project information: â€¢ Language: VB.NET â€¢ Level: Intermediate â€¢ IDE: Microsoft Visual Studio â€¢ Database server: MS SQL, MS SQL Express, MySQL, Access, Oracle, etc. I used MySQL (http://www.mysql.com/). â€¢ Special prerequisites: .NET Framework (http://www.microsoft.com/hu-hu/download/details.aspx?id=17851), SMS Gateway (in order to let your PC to send/receive SMS transmissions to/from a telecommunications network). I used Ozeki NG (www.ozekisms.com). Project description: First of all, you need to create the necessary database tables: one for the outgoing messages, and another one for the incoming messages. The snippet shows my MySQL commands, but it can be changed of course depending on the database server you use. In order to be able to use your database you need to connect it to your SMS gateway, then you can insert an SMS into the table of the outgoing messages by using an SQL INSERT command. To execute this command, you need to connect to the database by using the myConnection.Open() method. Thereafter insert the message into the database ( mySqlCommand.ExecuteNonQuery() ), then close the database connection ( myConnection.Close() ). That's all there is to it! It wasn't that black magic, was it?

(PHP) Simple PDO Connection and select - snstro

Fri, 06 Mar 2015 02:32:03 UTC

This is the basic code that you need to know to connect and list data with PDO. Don't use de old method (mysql_connect and mysqli_connect) to connect and interact with databases.

(PHP) IP Address (IPv6) Lookup in Bulk Using PHP and MySQL Database - Hexahow

Fri, 16 Jan 2015 13:45:15 UTC

The code below can be used to lookup IP address in bulk in return of geolocation information using PHP programming languages and MySQL database. In this tutorial, we use the IP2Location LITE database to lookup country of origin from the visitor's IP address. Free databases are available for download at IP2Location LITE database.

(Python) Scraped item to mysql in scrapy - zwidnypublic

Tue, 25 Nov 2014 13:30:21 UTC

To store you item into mysql database. 1. I say you have been have mysql database and the table what field is the same in item class that you wang to be stored 2. I just ensure you item insert into mysql, do not ensure the performance 3. Todo Abstract pipeline class

(MySQL) A example option file for mysql in windows - jacktan

Thu, 30 Oct 2014 01:52:11 UTC

`mysql-dev.ini` can be used in a developing environment and put it in the Mysql Home dir

(DOS Batch) A windows batch to run Mysql client - jacktan

Thu, 30 Oct 2014 01:43:22 UTC

**Vars** to to specify + ${EnvSet_Bash} **Demo** vars specified like + ${EnvSet_Bash}=[set-mysqlRT-Env](http://www.snipplr.com/view/80407/an-example-bash-file-for-set-temporary-path/ "set-mysqlRT-Env.bat") pluss other bash commond **Demo** @echo off call set-mysqlRT-Env mysql --defaults-file=%mysqlConf% --print-defaults pause mysql --defaults-file=%mysqlConf% pause

(DOS Batch) A windows batch to shutdown Mysql server - jacktan

Thu, 30 Oct 2014 01:21:38 UTC

Run `mysqladmin` to shutdown msyql server with a specified option file. **Vars** to to specify + ${EnvSet_Bash} **Demo** vars specified like + ${EnvSet_Bash}=[set-mysqlRT-Env](http://www.snipplr.com/view/80407/an-example-bash-file-for-set-temporary-path/ "set-mysqlRT-Env.bat") pluss other bash commond @echo off call set-mysqlRT-Env mysqladmin --defaults-file=%mysqlConf% --print-defaults pause mysqladmin --defaults-file=%mysqlConf% shutdown pause Click the bat file to run it .

(DOS Batch) A windows batch to run Mysql server - jacktan

Thu, 30 Oct 2014 01:10:54 UTC

Run a Mysql server using command line with a specified option file. **Vars** to to specify + ${EnvSet_Bash} **Demo** vars specified like + ${EnvSet_Bash}=[set-mysqlRT-Env](http://www.snipplr.com/view/80407/an-example-bash-file-for-set-temporary-path/ "set-mysqlRT-Env.bat") pluss other bash commond @echo off call set-mysqlRT-Env mysqld --defaults-file=%mysqlConf% --print-defaults pause mysqld --defaults-file=%mysqlConf% --console pause Click the bat file to run it .

(PHP) webEdition-Objekt mit php erstellen - ulfinger

Wed, 01 Oct 2014 01:02:31 UTC

WE-Objekte ohne Umwege direkt aus php erstellen. Das ist vor allem dann sinnvoll, denn die Eingaben vorher geprÃ¼ft und verarbeitet werden sollen oder wenn ein Eingabeformular Ã¼ber mehrere Seiten geht.

(Java) Map Mysql tables to java beans, by a one class - prgrmmraben

Tue, 16 Sep 2014 01:08:11 UTC

DBHelper can retrieve Mysql tables into java objects, without any external libraries or a mapping configuration file. note: please test before use, then use at your own risk.

(MySQL) Mysql find duplicate values in field - flatearthcomms

Tue, 09 Sep 2014 05:57:04 UTC

Mysql find duplicate values in field

(SQL) A light implementation of Session table in Mysql 5.6 using memory engine - prgrmmraben

Sat, 06 Sep 2014 07:35:01 UTC

caching session variables in Mysql using memory engine for fast client response. note: please test before use, then use at your own risk.

(MySQL) Delete from table with limit (mySQL) - Kcko

Wed, 23 Jul 2014 23:04:12 UTC

Delete from table with limit (mySQL)

(MySQL) consulta mysql count having - ironcrema

Fri, 04 Jul 2014 10:23:40 UTC

query with count having

(MySQL) Extract the column names of a table (so you can select many columns but exclude some) - imbraz

Tue, 24 Jun 2014 18:28:33 UTC

This will get the names of all the columns as one long string ready to use in a select statement. N.B. There is a list of column names to exclude (In this case '???COLUMNS_TO_EXCLUDE???')

(Java) Advanced Java mysql,oracle,... connect, full functions - supupoff

Sun, 25 May 2014 06:11:29 UTC

use This Class to conenct to any database mysql oracle access and postgresql and use functions to select update insert or update data from database --

(MySQL) Project Management Database Setup Script - JordanRowles

Sat, 12 Apr 2014 01:57:30 UTC

Sets up the database for my project management software (in development - C#)

(PHP) mySQL datetime to formatted PHP date - flatearthcomms

Wed, 02 Apr 2014 11:47:45 UTC

Format a mysql datetime into a PHP date

(MySQL) Add current date to date field that is null - jlmarks

Sun, 30 Mar 2014 17:41:12 UTC

(MySQL) get list of all values in a field MySQL - jlmarks

Sun, 30 Mar 2014 08:41:04 UTC

(SQL) Adding Linked Server to MSSQL - kidmizere

Fri, 28 Feb 2014 06:52:55 UTC

Adding a linked server to MSSQL account - particularly a MYSQL server

(MySQL) Find and Replace with MySQL - apphp-snippets

Tue, 04 Feb 2014 21:22:39 UTC

MySQL has a handy and simple string function REPLACE() that allows table data with the matching string to be replaced by new string. This is useful if there is need to search and replace a text string which affects many records or rows, such as change of address, company name, URL or spelling mistake.

(MySQL) Create a Database and Assign a User - apphp-snippets

Tue, 04 Feb 2014 21:21:36 UTC

This is a very simple snippet about how to create a database 1st, a user and then assign some privileges to the user to allow him/her to perform some specific actions like insert, create, update, select etc.

(MySQL) MySQL Event scheduler - kp32

Wed, 29 Jan 2014 02:11:57 UTC

This post will explain you the use of Event scheduler in MySQL.

(MySQL) MySQL Duplicate Rows With Updates - donkeykong

Tue, 21 Jan 2014 04:23:59 UTC

I found this script and tried it. It worked. I thought it was useful for a variety of situations and is easy to follow. Often times I need nearly duplicated data and don't want to manually cut and paste.

(PHP) Implementing Full-Text search in Laravel 4 - CreativePunch

Tue, 31 Dec 2013 05:42:37 UTC

In this tutorial I will go over implementing Full-Text search in Laravel 4 . Those who have used Laravel 3 in the past may remember that there used to be support for FULLTEXT indexes. This functionality has been removed in Laravel 4 but can still easily be implemented.

(PHP) How to reorder rows changinga position field - ginoplusio

Fri, 20 Dec 2013 09:57:23 UTC

This PHP function lets you reorder records on a table when you have a field used for save the position. If you have a field with position when you are editing records you probably want, for example, to move a record from position 5 to position 2, but if you already have a record in position 2 problems could raise, so how can you reorder all the records without losing informations and preserving the right order of the other elements? See how to use in the above link.

(PHP) Pinnacle Cart PDO MySQL : Product Class - crypticsoft

Wed, 04 Dec 2013 22:51:18 UTC

While the Pinnacle Cart API can handle some of this, I found it easier to query the database directly. This PCProduct class was developed for integrating Pinnacle Cart with WordPress with the following methods: - get_product($id) - get_product_by_product_id($id) - get_product_box($row) - get_top($cid,$cnt,$side) - get_products_by_category($cid) - get_categories($parent,$order,$level) - get_recent($limit) You will need to edit the following methods to match your cart paths / database settings: - cart_path() - cart_uri() - get_connection() -- This is the PDO connection, fill in the host, dbname, user, password - getProductUrl() -- Check the SEO settings, I'm using the 3.7 custom URL: %CategoryName%/%ProductTitle%/

(MySQL) Agregar LLave ForÃ¡nea MySql - ironcrema

Thu, 14 Nov 2013 07:50:32 UTC

Convierte un campo de una tabla a llave forÃ¡nea

(MySQL) Modify Column for Table Of Mysql - lyroge

Thu, 24 Oct 2013 19:38:58 UTC

Modify Column for Table Of Mysql

(MySQL) Drop and Add Column for Table of Mysql - lyroge

Thu, 24 Oct 2013 19:24:41 UTC

Drop and Add Column for Table of Mysql

(MySQL) Drop and Add Index for Table of Mysql - lyroge

Thu, 24 Oct 2013 19:14:36 UTC

Drop and Add Index for Table of Mysql