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 ... 11 12 13 14 15 ... 19 Next »

JavaScript JavaScript - MySQL Timestamp

mysql

0 1813 posted 17 years ago by jonniespratley

Bash Dump only data from MySQL database using mysqldump

mysql

0 2172 posted 17 years ago by jturmel

PHP Clean array for Posting / SQL injection protection

Need a function to clean your _POST array before inserting into a database? Just pass $_POST to this function.

mysql

1 3237 posted 17 years ago by the_dev

PHP Turn MySQL results into an array, the proper way!

Here is the correct way to turn your mysql results into an array. Forget the other nonsense of useless code. Why type out this long code: "for($i = 0; $array[$i] = mysqli_fetch_assoc($result); $i++) ;" when you can accomplish the same thing with m...

mysql

1 2106 posted 17 years ago by the_dev

Bash MySQL dump using SSH on Mac Terminal

Handy when web hosts limit database upload size. Create folder in home directory call "mysql_dump", upload and extract mysql file into this directory. Ask web host to enable SSH.

mysql

0 2255 posted 17 years ago by hotdiggity

MySQL The Worst Performing Indexes

This script shows the top 10 worst indexes (in terms of selectivity %) on the whole MySQL server instance. Selectivity is the percentage of distinct values in an indexed field compared to the number of records in the table. Note that this query can...

mysql

1 1775 posted 17 years ago by Eloi

MySQL MySQL Table - list of all country names (in Turkish)

This will create and then populate a MySQL table with a list of the names for countries in existence. Country names are in Turkish language.

mysql

0 2720 posted 17 years ago by sensimevanidus

MySQL How to install a gzipped mysqldump on a local Mamp server

mysql

0 2068 posted 17 years ago by paulbooker

Bash MySQL backup using mysqldump

Will prompt for user password.

mysql

0 1723 posted 17 years ago by alvarezrilla

MySQL mySQL - granting access permissions

granting DB specific and general access priveleges from the CLI

mysql

1 1916 posted 17 years ago by stiobhart

MySQL mySQL - database backup commands

CLI commands for backing up mySQL database

mysql

2 3209 posted 17 years ago by stiobhart

PHP PHP/MySQL - Get Table Data

Use this function to print out all the rows in a table. Specify columns to show using the columnstring parameter: tablulardata(tablename, columnstring); ie: tabluardata("users","username=Username|fname=First Name|lname=Last Name");

mysql

1 1922 posted 17 years ago by kilrizzy

PHP PHP/MySQL - Get Row Data

Use this function to pull all columns from a single database field. getrowdata(tablename,rowid,prefix); You would call this function like: getrowdata("users",$_SESSION['user'],"user_"); The prefix is the prefix you want for the array names,...

mysql

1 2143 posted 17 years ago by kilrizzy

PHP Dynamic Navigation From Database Table Names

This will create a Navigation from a MySQL database table names. It removes the table name "includes" by default so you can see how to remove any certain tables you wish to not use as a site section. Just plug in your MySQL database details and co...

mysql

3 2267 posted 17 years ago by jiggyhat

PHP INSERTAR EN UNA BASE DE DATOS MYSQL CON PHP

Este codigo inserta un registro en una base de datos mysql utilizando PHP

mysql

0 2146 posted 17 years ago by denker

MySQL Create Table Users

Splitting table users in frequently and infrequently accessed attributes

mysql

2 2225 posted 17 years ago by Eloi

MySQL Create Table Sessions

Saving the IP as Int we save a lot of space and permit do beautibul selects

mysql

2 1881 posted 17 years ago by Eloi

MySQL Select between two dates

mysql

2 2241 posted 17 years ago by craig1709

MySQL Add an attribute to existing table

Add an attribute to existing table

mysql

1 1936 posted 17 years ago by marouanomezzine

PHP phpMyAdmin strftime Dump Format

In phpMyAdmin you can define strftime formats for your dumped database sql files. Here you are with two formats, one for sigle table export, one for multi-table export.

mysql

0 1833 posted 17 years ago by dawjdh

PHP Escape String For Like Query

Simple way to escape string for LIKE statements, useful for searches.

mysql

3 1802 posted 17 years ago by robv

MySQL Restore Drupal 4 default input filters

mysql

0 1844 posted 17 years ago by zachharkey

PHP Query into Array

mysql

1 1935 posted 17 years ago by apro2000

PHP MySQL Schema XML Export

Export entire database schema to local xml file.

mysql

1 1858 posted 17 years ago by jonniespratley

MySQL Correcting wrong character encoding in MySQL data

When you forget to "SET NAMES utf8", you'll probably end up with a bunch of latin1 data in your utf8 column. This query fixes that, CONVERTing the existing data to its correct collation.