pastebin - pastes related to mysql

Advertising

advertising

related pastes to tag 'mysql'

2073831 - Nick: sql mysql

INSERT INTO person (person_id, first_name, last_name, address, phone, email, photo)   
VALUES
(NULL, 'Bob', 'Bobbison', '32 The Main Street', 4564587, 'bob@bobby.com', NULL),
(NULL, 'Nick', 'Little', '21 Eglinton Road', 4554515, 'nick@flat21.co.nz', NULL),
(NULL, 'Jasmine', 'Smith', '58 Brandon Street', 4487324, 'j_smith@windowslive.com','NULL'),
(NULL, 'Josh', 'Wight', '342 Ferris Road', 4483257, 'wight_01@hotmail.com','NULL'),
(NULL, 'Angus', 'Young', '984 The Glen Road', 4563465, 'ayoung@xtra.co.nz','NULL'),
(NULL, 'Freddy', 'Mercury', '324 The Side Road', 4564415, 'f_m_r@xtra.co.nz','NULL'),
 

1986310 - Untitled: mysql index collation

SET names utf8;
SELECT version();
USE test
DROP TABLE IF EXISTS t1;
CREATE /* First, we use utf8_unicode_ci, from which our custom collation is derived. The returned rows are what we expect, but not what we want. */ TABLE t1 (
    id int UNSIGNED PRIMARY KEY AUTO_INCREMENT,
    t varchar(64) charset utf8 collate utf8_unicode_ci,
    INDEX t_idx (t)
 

1986293 - Mine: mysql index collation

Welcome TO the MySQL monitor.  Commands end WITH ; OR \g.
Your MySQL connection id IS 186
Server version: 5.0.51a-24+lenny4 (Debian)
 
Type 'help;' OR '\h' FOR help. Type '\c' TO clear the buffer.
 
(nick@localhost) [(none)]> SET names utf8;
Query OK, 0 rows affected (0.00 sec)
 

1955503 - Display all MySQL databases modi: linux mysql sed find uniq

#!/bin/sh
# This script will find all MySQL databases modified within the last 90 days
 
export SEARCHPERIOD="90"
export DBPATH="/var/lib/mysql/"
 
find $DBPATH -mtime -$SEARCHPERIOD -type f -exec dirname {} \; | replace $DBPATH "" | uniq

1584100 - automysqlhotcopy: mysql backup

<?php
 
/* CONFIGURE THESE VARIABLES */
 
// Database connection
$mysql_user = 'YOUR-DB-USER';
$mysql_pass = 'YOUR-DB-PASSWORD';
$mysql_db = array('YOUR-DB1', 'YOUR-DB2');      // Array of all databases you want to backup
 

1584090 - mysqlbackupall: mysql backup

#!/usr/bin/perl -w
 
use DBI;
use Getopt::Long;
 
#
 
=head1 NAME

1396445 - php mysql_query result problem: php mysql query resource result

my generalized DB connection function:
 
  function dbopen($mode='read') ## {{{
  {
    require('./localinfo.php') ;
    switch ( $mode )
    {
      case 'read' :     ## {{{
 

1343616 - Wordpres Mysql cheat-sheet: mysql tag wordpress post category

/* All posts of category 'recipes' */
SELECT id,post_title
    FROM wp_term_taxonomy
        JOIN wp_terms
            ON wp_term_taxonomy.term_id = wp_terms.term_id
        JOIN wp_term_relationships
            ON wp_term_taxonomy.term_taxonomy_id
                = wp_term_relationships.term_taxonomy_id
 

1237816 - MySQL vs. PostgreSQL: mysql postgresql db

11 -!- dammit [~midom@84-80-6-088.static.zebra.lt] has joined #rapidxen
11 < dammit> hi!
11 -!- dammit is now known as domas
11 < Diablo-D3> hi domas
11 < Diablo-D3> this makes it easier :P
11  * werdnus sits back.
11 < Diablo-D3> <Diablo-D3> I answered why google uses mysql... its only on small projects that haven't been moved to the big db... they have projects using all sorts of different dbs, but they all
                   eventually get moved to the big db if they become google products
 

1182850 - MySQL export/import over SSH: mysql sync ssh secure tunnel

#!/bin/bash
 
#Sync the database from local to remote, using a secure tunnel.
 
auth_timeout=15
 
# ssh will take a little time to authenticate
ssh -C -N -L 6603:gallery.db:3306 me@remote &

1047304 - Something: ubuntu mysql postfix

Got the following message in the postfix logs while trying to set-up a mail server based on postfix and mysql on a ubuntu 7.10 system:
 
warning: connect to mysql server localhost: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'
 
In the /etc/postfix/mysql*.cf files I had tried two values for the hosts parameter that caused this error:
  hosts        = unix:/var/run/mysqld/mysqld.sock
and
  hosts        = localhost
 

979281 - SQL highlight: mysql parse lexer

<?php
/** 
 * Tokenizes text that looks something like SQL.
 */
function tokenizeSQL( $SQL )
{
        $functions = array ( 'concat', 'if' );
        $token = '\\(|\\)|[\']|"|\140|[*]|,|&lt;|>|&lt;>|=|[+]';
 

976632 - 4.1.22 Illegal mix of collations: mysql bug

-- SETUP
CREATE TABLE `t` (`str` varchar(100) collate latin1_general_ci NOT NULL) 
ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
INSERT INTO `t` (`str`) VALUES('foo');
 
-- FAILS:
SELECT u FROM t RIGHT JOIN (SELECT 'foobar' AS u) u2 ON u REGEXP str GROUP BY u HAVING count(str) > 0;
 
 

963956 - aush0k + a0: c mysql ddos hax aush0k a0 oven

aush0k + a0 
 
 
andrew says:
rifk
andrew says:
come on
andrew says:
 

921957 - Xwiki log outputs - cannot login: mysql xwiki tomcat

I've posted a more detailed problem description here for your perusal. 
 
Problem:
It's impossible to login or create new users. The superadmin account does not work. Logging in with superadmin does not give any "wrong password/wrong username" messages, but the log-in still fails, since the log-in link remains in the upper -right corner. Clearing cookies at the browser does not help.
 
I tried using postgresql instead, with identical results.

914147 - mysql.stripschema.sql: mysql schema backup

#
#---- Strip database schema from bzipped mysqladministrator created backup file
#
#---- Usage: mysql.stripschema.sh backup_file schema_file
#
bzcat $1|grep -v "^ ("|\
         grep -v "^INSERT"|\
         grep -v "^-- Dumping"|\
 

912199 - Xwiki log outputs - cannot login: mysql xwiki tomcat

I've posted a more detailed problem description here for your perusal. 
 
Problem:
It's impossible to login or create new users. The superadmin account does not work. Logging in with superadmin does not give any "wrong password/wrong username" messages, but the log-in still fails, since the log-in link remains in the upper -right corner. Clearing cookies at the browser does not help.
 
I tried using postgresql instead, with identical results.

910487 - Uruviel: sql mysql

SELECT answers.answer, 
       answers.return_value, 
       dependencies.targetid AS target 
FROM  answers 
      JOIN response_options 
           ON answers.id = response_options.answerid
      LEFT JOIN dependencies 
           ON answers.answerid = dependencies.answerid 
 

910010 - Uruviel: sql mysql

SELECT answers.answer, answers.return_value, dependencies.targetid AS target FROM (SELECT * FROM  answers, response_options WHERE answers.id = response_options.answerid AND response_options.questionid = 1) AS answers LEFT JOIN dependencies ON answers.answerid = dependencies.answerid AND dependencies.questionid = 1

908868 - AndersHH php mysql rss timestamp

preview unavailable

908159 - inventory duplication: mysql krisbfunk inventory duplication

ckrinke>        Nebadon. The user 'Charles Krinkeb" on OSGrid has duplicate folders for Trash, My Inventory, Lost And Found, Objects, Body Parts, Notecards and Scripts. What is the most straightforward way to deal with things like this?
        <nebadon>       ah this is a bit tricky
        <nebadon>       what i do
        <nebadon>       have done i should say
        <nebadon>       is upload a file and name it something very unique
        <nebadon>       this way you can deteremine what your root folders UUID truly is
        <nebadon>       even though you have multiple sets in the database, only 1 is being used
        <nebadon>       when you look at the inventoryfolders table
 

902931 - utf8 hawtness mysql utf8 charset collation

preview unavailable

896609 - Xwiki log outputs - cannot login: mysql xwiki tomcat

I've posted a more detailed problem description here for your perusal. 
 
Problem:
It's impossible to login or create new users. The superadmin account does not work. Logging in with superadmin does not give any "wrong password/wrong username" messages, but the log-in still fails, since the log-in link remains in the upper -right corner. Clearing cookies at the browser does not help.
 
I tried using postgresql instead, with identical results.

885296 - sam_mysql: mysql apt-get

Starting MySQL database server: mysqld.
/etc/init.d/mysql: line 100: /etc/mysql/debian-start: No such file or directory
invoke-rc.d: initscript mysql, action "start" failed.
 
/etc/mysql/debian-start:
 
#!/bin/bash
#
 

879434 - cannonball: mysql replication triggers 5.0.22

Master-Master replication setup, mysql-5.0.22 (CentOS 5.1 revision number 5.0.22-2.1.0.1)
 
Does anybody see anything in the following description that is:
a) improper mysqldump commandline
b) known problem with 5.0.22
c) known problem with replication
d) known problem with replication of triggers
e) known problem with mysqldump
 

716234 - multiple select results in one p: php mysql select

        $sqlSumCentres = "select count(VoteId) from pasokvotes";
        $sqlSumCandidateA = "select count(CandidateA) from pasokvotes";
        
        $SumCentres = mysql_query($sqlSumCentres,$connection);
        $SumCentresRow = mysql_fetch_row($SumCentres);
        echo('<p>');
        echo('centres sum: '.$SumCentresRow[0]);
        echo('</p>');
 

651793 - performance problem: mysql

table scheme:
----------------
CREATE TABLE `content` (
  `pid` int(11) NOT NULL default '0',
  `date` date NOT NULL default '0000-00-00',
  `page` varchar(250) NOT NULL default '',
  `hits` int(11) NOT NULL default '0',
  PRIMARY KEY  (`pid`,`date`,`page`),
 

625194 - Almight_Henaro: mysql 1075

 CREATE TABLE `users` (
`user_id` TINYINT( 5 ) UNSIGNED NOT NULL AUTO_INCREMENT ,
`group` TINYINT( 5 ) NOT NULL DEFAULT '0',
`nick` VARCHAR( 25 ) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL ,
`email` VARCHAR( 75 ) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL ,
`ip` VARCHAR( 30 ) NOT NULL ,
`loggedin` TINYINT( 1 ) UNSIGNED NOT NULL DEFAULT '0',
`lastseen` TIMESTAMP( 14 ) NOT NULL DEFAULT CURRENT_TIMESTAMP ,
 

604210 - gewe: mysql monodevelop

prefix=${pcfiledir}/../..
exec_prefix=${pcfiledir}/../..
libdir=${prefix}/lib
includedir=${prefix}/include
 
Name: MySql.Data
Description: MySql database client
Version: 5.0.7.0
 

594299 - Get position of a record in a se: sql mysql position ordering

SELECT proposal_id, AVG(total_score) AS avg_score FROM (SELECT r.proposal_id, SUM(rs.value) AS total_score FROM opas_review r INNER JOIN opas_review_score rs USING (review_id) GROUP BY r.review_id) AS t1 GROUP BY proposal_id ORDER BY avg_score;

591387 - garotosopa: mysql wrong order join straight_join view

EXPLAIN SELECT *
        FROM
                pergunta AS p
                JOIN pergunta_texto AS ptx ON p.pergunta_id = ptx.pergunta_id
                JOIN categoria AS c ON p.categoria_id = c.categoria_id
                JOIN usuario AS u ON p.usuario_id = u.usuario_id
        ORDER BY p.pergunta_id DESC
        LIMIT 0, 10;
 

591386 - garotosopa: mysql wrong order join straight_join view

EXPLAIN SELECT *
        FROM
                pergunta AS p
                JOIN pergunta_texto AS ptx ON p.pergunta_id = ptx.pergunta_id
                JOIN categoria AS c ON p.categoria_id = c.categoria_id
                JOIN usuario AS u ON p.usuario_id = u.usuario_id
        ORDER BY p.pergunta_id DESC
        LIMIT 0, 10;
 

worth-right

pastebin - pastes related to mysql

Stuff to Do

Information

Quick Search

Recent Posts

Advertising

advertising

related pastes to tag 'mysql'