mysql

Character Encoding Problem

Hi, I need to save this onto database(mysql) and show it back. (my database is utf_general_ci) I αм iиvisibłє łiкє αiя--- I αм αs iмρøяŧαиŧ αs øxygєи--- I αм łiviиg iи ŧЋє wøяłd øƒ мy dяєαмz I αм αłwαys ŧЋєяє ŧø Ћєłρ øŧЋєяz--- I αм busy buŧ иєvєя igиøяє αиy øиє I αм ŧЋє øиє wЋø cαяєz--- I łøvє ŧø sєє øŧЋєя łαugЋiиg I αм ŧЋє øиє wЋø bøя...

Rewriting mysql subqueries with LEFT JOIN

Hello I have a table with such structure: uid sid all integers. This table simulates friendship between two user. All I want to do is to find such records that exist only in one direction. For example: I want to find number of records that have t1.u_id = 15, when there is no records that have t2.s_id = 15 and t2.u_id = t1.s_id. ...

Is there any application for checking 'what's loading onto the website right now' kindof ?

I am developing a website and sometimes the browsers keeps loading, and I would like to know exactly what's making it load for so long. It gets stuck kindof. So I wonder if there is any application or way to check what is getting loaded onto the page, so I can see what element or object it gets stuck on? The website uses php/javascript...

Books or resources for high-loaded sites.

Currently I'm developing high-loaded financial portal(we use LAMP to run our project). There are great number of incoming data to be processed and stored. So optimization tasks become very important for us. Could you suggest books, articles or resources, that discover optimization questions (especially bboks). NOTE: At the moment I'm ...

Formatting Date on Java

Hi there. I have a String with the following format: january_2005 (MMMMMMM_yyyy) and i want to convert it to a mysql acceptable date value to insert it on the database. I need to do it on Java. Does anyone knows how to do it? Thanks ...

MySQL UTF8 Database migration

Hi everyone, I'm having problems to migrate an utf8 database to another server... Each source and destination table has a "DEFAULT CHARSET=utf8". I use mysqldump to dump data and mysql < file.sql to import but when in the source table i have "España", in the destination i get "España". I read some guides, i used --default-character-...

Why is it necessary to assign atleast one column in a table (in MySQL) as PRIMARY KEY for the table to accept UPDATE and INSERT statements via JDBC?

Also; can I add a negative INT inside a PRIMARY KEY column inside a table via JDBC? ...

Error Loading Mysql using PHPmyadmin

Trying to load the following into a database: SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0; SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0; SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL'; use es; -- ----------------------------------------------------- -- Table `events` -- ----------------------...

Delete Multiple Row Challenge - MySQL & PHP with Checkbox Control

I want to build a feature that enables the user to moderate questions and is similar to wordpress comment or typical email moderation that uses a checkbox to approve/delete many questions at once. How would I modify the following code to check which the questions are checked and react to the delete buttons when pressed? You may notice f...

mySQL Stored Procedure for splitting strings by delimiter

Hi all, I'm into writing a stored procedure which explodes a passed string by a passed delimiter and returns the n-th element of the result. n is passed too. So this is what I came up with: CREATE PROCEDURE SPLIT(IN strToSplit text, IN strDelimiter varchar(1), IN nPartToGet int,OUT strSlice varchar(255)) BEGIN SET strSlice = repla...

Many MySQL databases - problem?

Hello guys I'd like to know if it is any kind of issue having 200+ MySQL databases on the same server. None of them are probably going to be very used, I'm just wondering if there is any issue having so much databases. Thanks in advance ...

Streaming live video to a web site

Hi, I've received a request asking if it's possible to stream live video to a web site. The person requesting this has a notebook running MacOS, a professional camera that can be connected up using Firewire and a web site with PHP/MySQL. What solutions exist to stream the video out on the Internet and, if practical, what would be neces...

Google Map with php mysql

hi my problem is i want to show my registered site user on to google map but dont know how to locate the user, means i dont know the latitude and longitude of every user . I am a newbie in google map so plz help Thanks a ton ...

MySQL select highest rated

I have 2 columns, one called rating_average and one called rating_count. I need to select the 3 rows with the highest rating with the rating count factored into the equation as well. ...

MySQL how to set a column to reference columns from another table

I want to define the value of columnA in tableA to have the count of all rows in tableB where tableB.columnB I have two tables: articles table columns: articleId,numComments comments table columns: articleId,content I want numComments column in table "articles" to contain a count of all rows in table comments where articles.articleId...

How to parse file in php and generate insert statements for mysql?

In case of csv file we have fgetcsv in php to parse and get the output but in my case file is .dat and I need to parse it and store it into MySQL Database and so do we have any built in function in php like fgetcsv that can work in similar fashion on .dat file ? Here is the sample value, it has headers DF_PARTY_ID;DF_PARTY_CODE;DF_CONNE...

Select columns of specific type in MySQL 4.1

Hi, I need to find all smallint (specifically smallint(5)) columns in a MySQL 4.1 database. It seems that INFORMATION_SCHEMA is only available in MySQL 5+. Is there an alternative? Thanks ...

Optimize SQL Query on calculated value?

I have a query that requires a where statement on a calculated value: select * from table where date( timestamp ) = ? An explain on this query yields the expected ALL select type, which is not ideal. Using MySQL, what's the best way to optimize this? ...

Getting row data of inserted row (Mysql, PHP, mysqli)

I need to get back the postid (auto-incrementing PK) of a row when i insert it. I am currently using this to get it //get postid to return if($result = $db -> query('SELECT postid FROM posts WHERE title = \''.$title.'\' LIMIT 1')){ $row = $result->fetch_assoc(); $json['postid'] = $row['postid']; $result->free(); where $title ...

Is there a tool to generate a full database DDL for SQL Server? What about Postgres and MySQL?

Using Toad for Oracle, I can generate full DDL files describing all tables, views, source code (procedures, functions, packages), sequences, and grants of an Oracle schema. A great feature is that it separates each DDL declaration into different files (a file for each object, be it a table, a procedure, a view, etc.) so I can write code...