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 1348 posted 16 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 1511 posted 16 years ago by brownrl

JavaScript JavaScript - MySQL Timestamp

mysql

0 1280 posted 16 years ago by jonniespratley

Bash Dump only data from MySQL database using mysqldump

mysql

0 1527 posted 16 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 2578 posted 16 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 1505 posted 16 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 1522 posted 16 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 1179 posted 16 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 1940 posted 16 years ago by sensimevanidus

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

mysql

0 1391 posted 16 years ago by paulbooker

Bash MySQL backup using mysqldump

Will prompt for user password.

mysql

0 1159 posted 16 years ago by alvarezrilla

MySQL mySQL - granting access permissions

granting DB specific and general access priveleges from the CLI

mysql

1 1290 posted 16 years ago by stiobhart

MySQL mySQL - database backup commands

CLI commands for backing up mySQL database

mysql

2 2506 posted 16 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 1372 posted 16 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 1538 posted 16 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 1604 posted 16 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 1503 posted 16 years ago by denker

MySQL Create Table Users

Splitting table users in frequently and infrequently accessed attributes

mysql

2 1609 posted 16 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 1297 posted 16 years ago by Eloi

MySQL Select between two dates

mysql

2 1626 posted 16 years ago by craig1709

MySQL Add an attribute to existing table

Add an attribute to existing table

mysql

1 1359 posted 16 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 1256 posted 16 years ago by dawjdh

PHP Escape String For Like Query

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

mysql

3 1186 posted 16 years ago by robv

MySQL Restore Drupal 4 default input filters

mysql

0 1229 posted 16 years ago by zachharkey

PHP Query into Array

mysql

1 1290 posted 16 years ago by apro2000

PHP MySQL Schema XML Export

Export entire database schema to local xml file.

mysql

1 1334 posted 16 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.