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 »

MySQL mySQL 5 Import / Export bei einem 1und1 Homepage Server

mysql

0 836 posted 15 years ago by humanoid

PHP PHP updateFromVals

Here is a small function that I use to update records in a database. It coincides with the insertFromPost function that I have posted earlier. The element names in the form need to have the same name as in the DB and the field names should all...

mysql

1 847 posted 15 years ago by brownrl

JavaScript JavaScript - MySQL Timestamp

mysql

0 898 posted 15 years ago by jonniespratley

Bash Dump only data from MySQL database using mysqldump

mysql

0 959 posted 15 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 1106 posted 15 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 1021 posted 15 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 978 posted 15 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 752 posted 15 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 1224 posted 15 years ago by sensimevanidus

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

mysql

0 833 posted 15 years ago by paulbooker

Bash MySQL backup using mysqldump

Will prompt for user password.

mysql

0 684 posted 15 years ago by alvarezrilla

MySQL mySQL - granting access permissions

granting DB specific and general access priveleges from the CLI

mysql

1 844 posted 15 years ago by stiobhart

MySQL mySQL - database backup commands

CLI commands for backing up mySQL database

mysql

2 1013 posted 15 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 746 posted 15 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 869 posted 15 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 862 posted 15 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 987 posted 15 years ago by denker

MySQL Create Table Users

Splitting table users in frequently and infrequently accessed attributes

mysql

2 1175 posted 15 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 786 posted 15 years ago by Eloi

MySQL Select between two dates

mysql

2 858 posted 15 years ago by craig1709

MySQL Add an attribute to existing table

Add an attribute to existing table

mysql

1 898 posted 15 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 844 posted 15 years ago by dawjdh

PHP Escape String For Like Query

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

mysql

3 739 posted 15 years ago by robv

MySQL Restore Drupal 4 default input filters

mysql

0 760 posted 15 years ago by zachharkey

PHP Query into Array

mysql

1 832 posted 15 years ago by apro2000

PHP MySQL Schema XML Export

Export entire database schema to local xml file.

mysql

1 852 posted 15 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.