Mysql corrupting characters

I am trying to retrieve text from the my mysql database using ajax code witten in php. Somewhere its getting twisted. All the text is retrieved and displayed correctly except the Swedish characters used in some of the words that are stored in my mysql phpmyadmin database. These are displayed seriously incorrectly. Each character deletes the following 2 characters. S=E5 "p=E5skvecka" becmes p*vecka where * is an upright diamond with a question mark in it. This offending character can not be copied into this newsgroup posting, it just wont take it. Everything else on the page is cor

Select Query Help

I'm struggling - with my limited knowledge of SQL - to write a query that does what I want it to, and I was hoping that someone here may be able to help out. I have a table with two columns, user1 and user2, which store user ID's. For example: user1 | user2 ----------------------------- 1 | 4 1 | 2 1 | 3 3 | 2 3 | 1 5 | 1 What I want to do is select all the rows for which, say, user2 is 1, but where user1 is such that there isn't a reverse combination. So above, the only row that should come back is 5/1 as for the row 3/1 there is also a row 1/3. I know tha

Best way to export one Excel column for import into MySQL?

I have an Excel (2007) workbook with 5 worksheets. Each sheet has a list of word in column A. The other columns vary from sheet to sheet. What's the best way to export these 5 columns so they can be imported into MySQL?

ROWS INTO COLUMN HEADERS...

Hi all, I could group on id and year wise to get the below table. id year num amount | 01525 | 2007-2008 | 141 |1039962.00 | | 01525 | 2008-2009 | 74 | 352810.00 | | 01525 | 2009-2010 | 63 | 548181.00 | | 01988 | 2007-2008 | 140 |1301708.00 | | 01988 | 2008-2009 | 51 | 438070.00 | | 01988 | 2009-2010 | 57 | 304886.00 | I want the same in the following format. Please help me! 2007-2008 2008-2009 2009-2010 id num amount num amount num amount 01525

load data infile query doesn't work because data files were moved

I load this file every day, using mysql query browser with this LOAD infile query : LOAD DATA INFILE '08262010 item_extraction.txt' INTO TABLE myTable IGNORE 1 LINES; Then the server was out of space so an admin moved the data tables to the F drive: F:\Folder SQL\data\cart_order This is the path on the F drive. Now my load data infile script doesn't work anymore. I moved the upload file to the F: drive folder. I'm getting weird error messages like: The query could not be executed. Table 'bugracker.myTable' doesn't exist. Is it the space in the file path?:

How to query to get records of 3 consecutive months of data in the last 6 months

Hi, I am trying to find all rows that has 3 consecutive months of data in the last 6 months. Assume there is a month column. I can get data for the last 6 months. but within this 6 months I need all records that has any 3 consecutive months of data. Any help is appreciated. Thanks.

Self-join query or else... need advice

Hello I'm not sure how to do the following in a query, i believe, maybe, a self-join query, but i have no idea how to I have a table (album) that contains albums: albumid, albumname, ... ------------------ 1, 'Forever' 2, 'The Last Song' 3, 'Maybe' 4, 'This is not' 5, 'Hello' 6, 'Goodbye' I have another table (single) that repreents the singles that have been released for a specific album: albumid, singleid --------------- 1, 3 1, 5 1, 2 4, 3 The singleid is, basically, the albumid that is in the table album. I want to be able to pick all the singles from an albu

compare and join three tables....

Hi, I have three tables of sales for year 2007-08, 2008-09, 2009-10 like follwing. I need a short query to join all the tables on dist.code grouped. 2007-08 dist.code number amount 1234 5 100.00 1234 6 200.00 3456 3 400.00 3456 8 200.00 2008-09 dist.code number amount 1234 15 200.00 1234 16 300.00 3456 32 500.00 3456 68 300.00 2009-10 dist.code number amount 1234

start and end range from multiple entries

Hi, I would like to know if there is a good way of creating ranges from start and end rows. Like this: "select start, end, cluster from table" returns: 1 48 340857 1 50 340857 1 54 340857 5 62 340857 34 107 340857 34 107 340857 53 107 340857 121 194 340857 141 215 340857 169 219 340857 and I would like to create the ranges from those entries, lile: 1-107 121-219 Thanks in advance, Cheers, Albert.

Alter table not working under win7 wamp5

For this discussion, foob is my database parts is my database. I tried this as both the user who has full priviledges on foob and also as the superuser and got errors both times. The command I tried to execute and the associated error message are: mysql> ALTER TABLE `foob.parts' ADD `avail_intl_flag' char(1) not null set default (`Y'); ERROR 1103 (42000): Incorrect table name 'hawke.articles' ADD ' mysql> I am running WAMP5 1.7.3. I am running this software on a Win7 32 bit version machine. I am running command line MySQL under a DOS window with only the MySQL s

Possible to add "ON DELETE CASCADE" after the fact?

Hi, I'm using MySQL 5.0 with InnoDB tables. I have a foreign key constraint set up, but I would like to expand the foreign key constraint to add the "ON DELETE CASCADE" clause to it. Do I have to drop and create the foreign key or is there a way I can modify it? Thanks for your help, - Dave

update with subquery

Hi guys I have these three tables: table1: id subcategory head_category headcategory: id name subcategory: id name head-category insert into headcategory values(1, 'songs'); insert into headcategory values(2, 'movies'); insert into subcategory values(1, 'bad romance', 1); insert into subcategory values(2, 'stan', 1); insert into subcategory values(3, 'godfather', 2); At the beginning the table table1 didnt contain the field head_category. I added this field after a huge import of data, so all of them are set to NULL (Yes, I realized that head_category was a

Errcode: 28 (out of space, apparently)

I've a client application which has experienced this error. Fixing it required expanding the available tmp space. Unfortunately, the client application is not one we've authored or one over which we've any control. And it doesn't seem to do a good job of error reporting in most case. But this error is one detected by the MySQL server, no? Yet nothing was logged by the server that experienced this error. Am I wrong about this being a server-side issue? Or, is there some way to get the server to log events like this so as to make them easier to detect? I've started

Cant get "grant execute on procedure" to work.

ERROR 1370 (42000): execute command denied to user 'wwwrun'@'%' for routine 'GasCheck.CreateTid' To get here I've got the following setup on ubuntu 10.04 using mysql 5.1.41-3ubuntu12.6 : mysql> select user(), current_user(); +------------------+----------------+ | user() | current_user() | +------------------+----------------+ | wwwrun@localhost | wwwrun@% | +------------------+----------------+ select * from mysql.procs_priv; +------+----------+--------+--------------+-------------- +-----------------+-----------+---------------------+ | Host | Db |

concatenate data from multiple fields into one

From what I have been reading it is possible to copy data from one field into another by doing something similar to this: UPDATE table SET field2 = field1; what I am looking to do is take the the information from several fields and create one new field ie: all of the info from field1 + first character of field2 + first character of field3 + first charcter of field4 is used to create the information in field5 for this I could do something like: UPDATE table SET field5 = CONCAT(field1, ',' ,field2, ',' ,field3, ',' ,field4); but how do i get it to only use the first characte

INSERT INTO one field doesn't get input

I am not getting the username input into this database, only the ip address it is inserting a blank? I echoed the values from the post and I get both ip and uname values. What can I look for? /They are both text fields. One gets input and the other doesn't. The form looks okay, thanks, if ($_POST['submit']){updatePrinter($ip,$uname) ;}//call insert function function updatePrinter($ip,$uname){ $link = mysql_connect("XXX.XXX.XXX.XXX","usr","pwd"); mysql_select_db("cart_order",$link); $sql="INSERT INTO `cart_order`.printer (ip,uname) "; $sql.="VALUES('$ip','$uname') "; $result

Ideas to improve DB design

I have the current tables: CREATE TABLE joint ( joint_id int(10) unsigned NOT NULL auto_increment, joint_name varchar(50) NOT NULL, PRIMARY KEY (joint_id) ) ENGINE=InnoDB; CREATE TABLE company ( company_id int(10) unsigned NOT NULL auto_increment, company_name varchar(50) NOT NULL, joint_id int(10) unsigned default NULL, direct_company_id int(10) unsigned default NULL, matrix_company_id int(10) unsigned default NULL, PRIMARY KEY (company_id), CONSTRAINT company_fk1 FOREIGN KEY (joint_id) REFERENCES joint (joint_id), CONSTRAINT company_fk2 FOREIGN KEY (direct_comp

Selecting from MySql an Oracle data source

Hello, I would like to select while in a MySql database a table in an Oracle data source. For example, I have a the latest version of MySql 5.x and want to select from a 9i Oracle database. what can I do here. Is there a MySql Solution or FREE add-on, not a 3rd Party solution? Ideally it would be something like or analogous to an Oracle Database Link where I setup the database link to talk to a schema in Oracle and all I need to do is select using the link. Thanks Much! Devdewboy

C access: accessing ints

Hi All, I have written my first program to access a database from C. However, my manual, "MySQL" by Paul DeBois, only explains how to access varchars and blobs, it doesn't explain how to access, say ints or floats or doubles. My code looks like this (mostly copied straight out of the book): .... if (mysql_query(conn, "select BowlerFirstName, BowlerLastName, BowlerCity" " from Bowlers")) { u_reportError(conn, "mysql_query() failed"); } res_set = mysql_store_result(conn); if (!res_set) { u_reportError(conn, "mysql_store_result()

Newbie: "error in your SQL syntax"

Can anyone help me, going nuts with this error which defies logic (the stuff I thought computing was based on'. My full sql statement is $sql = "UPDATE tblNames SET (lastname='$lastname',firstname='$firstname',title='$title',country='$country', isfemale=$tf,nationality='$nationality',tels='$tels',email='$email',DNI='$DNI',usernotes='$usernotes', employment='$employment',address='$address',zip='$zip',DOB='$DOB',username='$username',adminnotes='$adminnotes', modified=NOW(),ULX=$UULX) WHERE ID=".$selid; and I get a "You have an error in your SQL syntax; check the manual that corres

select one field and related ones

Hi people: id, name colors: id, color, person insert into people (1, 'Mark'); insert into colors (1, 'red', 1); insert into colors (2, 'blue', 1); This means that Mark likes the colors red and blue. Actually, its much more than this, but to simpify I just took the two relevant tables. Im going to select fields from a couple of tables where there is mark's id. Among the tables there is the "people"-table. So long no problems. But now, for each of the fetched row I need to retrieve the colors that Mark likes. I would like to avoid looping through each row and select

help with sql statement please...

I have a table: +---------------------------------------------+ | ImageID | ImageType | ImageSize | | a | bmp | 100 | | b | jpg | 25 | | c | bmp | 100 | | d | bmp | 50 | +---------------------------------------------+ I need to get back a list like: bmp 100 50 jpg 25 select unique ImageType, ImageSize Is that correct sql?

MySQL JDBC replication driver not using all slaves

We have a setup with 1 master and 3 slaves. The JDBC connection string is jdbc:mysql:replication://master,slave1,slave2,slave3/idbname? zeroDateTimeBehavior=convertToNull&autoReconnect=true&roundRobinLoadBalance=true However, the traffic only goes to master for writes and slave1 for reads. Slave 2 and 3 just sit there. Is there something obvious I am missing? I looked around but could not find any solution to this problem. Using mysql-connector-java 5.1.10. Thanks for your help! -cheers, Manish

comparing rows in same table

Hi there, Quick question. I have a product stock/price history table, what kind of query can i execute to show products that have a price change? Table has productid, stock, price, and createddate columns. Dataset example: | PID | Stock | Price | CreatedDate | | 1 | 755 | 15.50 | 2010-07-22 18:31:12 | | 1 | 755 | 15.50 | 2010-07-21 15:19:52 | | 1 | 755 | 15.50 | 2010-07-20 23:35:23 | | 1 | 797 | 14.50 | 2010-07-19 23:35:18 | | 2 | 1000 | 14.50 | 2010-07-22 18:31:13 | | 2 | 1000 | 14.50 | 2010-07-21 15:19:52 | | 2 | 1000 | 14.50 | 2010-07-20 23:35:24 | | 2 | 1000 |

SQL Searching in 2 Tables

Hello, i have the following SQL Problem with MySQL: I have 3 Tables, one with adresses, one with items and another with the relations what AdressID has bought what ItemID. I want to ask for a list of adresses, that didn't buy any item so far. How should the SQL-query look like for that? Thanks for any help, Martin Nadoll