Login / Register

Share Snipplr

Follow @Snipplr

Popular Tags

form regex email curl url http login css mysql database ajax javascript js sql class php header redirect table ie data dropdown sort list object date phone number format svn command resize image file textmate plugin path math actionscript event mail link window debug template Bash java search html post mac error xhtml page google wordpress server rails browser python script replace style array forms backup flash video ruby DOM xml category unix osx download simple c code windows navigation jquery cakephp regexp text function button links filter ie6 linux images htaccess apache free files copy log module query background

Welcome To Snipplr

Everyone's Recent Snippets Tagged mysql

« Prev 1 2 3 4 5 ... 19 Next »

MySQL mysql make access global

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

mysql

0 4089 posted 8 years ago by surentharp

Python MySql workbench add created and modified columns for CAKEPHP

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

mysql

0 4322 posted 8 years ago by acosonic

Java Connect To A MySQL Database

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

mysql

0 4339 posted 9 years ago by syedhussim

MySQL Get Random Record Based on Weight

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...

mysql

0 4463 posted 9 years ago by apphp-snippets

SQL Insert or Update Record if Unique Key Already Exists

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

0 4464 posted 9 years ago by apphp-snippets

MySQL Configuration Mysql 5.7

Some configurations for mysql 5.7

mysql

0 3926 posted 9 years ago by ironcrema

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

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

mysql

0 2499 posted 10 years ago by rm1984

SQL mysql pivot data

mysql

0 2863 posted 10 years ago by ktrout

SQL mysql procedure throw_error

procedure to throw application defined error

mysql

0 2947 posted 10 years ago by ktrout

SQL mysql rank with ties

calculate rank ( with ties ) over points table

mysql

0 2939 posted 10 years ago by ktrout

SQL mysql clone table with structure and indexes

clone table with structure and indexes

mysql

0 3165 posted 10 years ago by ktrout

SQL mysql unroll variable length string list

unroll variable length string list to normalised form.

mysql

0 2932 posted 10 years ago by ktrout

SQL mysql tablename search information schema

search for tables in mysql catalog ( information_schema )

mysql

0 1926 posted 10 years ago by ktrout

SQL mysql batch sql statements

stored procedure for executing batch sql statements

mysql

0 2923 posted 10 years ago by ktrout

SQL mysql calendar table

creates a minimal calendar table

mysql

0 3069 posted 10 years ago by ktrout

SQL mysql sequence generator ( decimal definition )

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

mysql

0 2820 posted 10 years ago by ktrout

PHP php code example

example of php code I worked on

mysql

0 3172 posted 11 years ago by johnschneider

PHP PHP - Doctrine - Left join ON condition AND other condition syntax in Doctrine

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...

mysql

0 5566 posted 11 years ago by satie83

VB.NET VB.NET SQL Example: How to send SMS in VB.NET using SQL database

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 bett...

mysql

0 4909 posted 11 years ago by LoganTurn

PHP Simple PDO Connection and select

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.

mysql

0 3241 posted 11 years ago by snstro

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

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...

mysql

1 3886 posted 11 years ago by Hexahow

Python Scraped item to mysql in scrapy

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. To...

mysql

0 4892 posted 11 years ago by zwidnypublic

MySQL A example option file for mysql in windows

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

mysql

0 4381 posted 11 years ago by jacktan

DOS Batch A windows batch to run Mysql client

**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 *...

mysql

0 4259 posted 11 years ago by jacktan

DOS Batch A windows batch to shutdown Mysql server

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-...

mysql

0 4475 posted 11 years ago by jacktan

DOS Batch A windows batch to run Mysql server

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-...

mysql

0 4404 posted 11 years ago by jacktan

PHP webEdition-Objekt mit php erstellen

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.

mysql

0 2986 posted 11 years ago by ulfinger

Java Map Mysql tables to java beans, by a one class

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.