MySQL Database Forum

I just upgraded to MySQL to 4.1.9 and JDBC mysql-connector-java-3.1.6-bin.jar and now getting the following Exception: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data truncated for column 'usaCard' at row 1 What causes this exception? I've set jdbcCompliantTruncation=false for the time being but would like to understand what...

I have the following line in a php script $queryDeletePosition = mysql_query("DELETE FROM `Position` WHERE `stockID` = '$existStockID' AND `userID`='$userID' AND `groupID`='$groupID' LIMIT 1 ", $connMydb) or die(mysql_error()); It works fine . The entry I want deleted from the database is deleted. However $queryDeletePosition value is 1,...

Assume you have two varchar (or Text) columns named L and U which are identical except that the charset for L is latin1 and the charset for U is utf8. All the records in L and U are identical in terms of content, consisting of only 7 bit ASCII characters. Both columns have indexes of the same type (e.g. assume Unique indexes if you want). ...

Hi, I'm new to databases :) I need help speeding up select queries on my data which are currently taking 4-5 seconds. I set up a single large table of coordinates data with an index on the fields I use most frequently in select queries. The data is about 100MB and index is 80MB. The table has the following structure: CREATE TABLE `ptimes`...

Hiya I'm new to SQL so I hope somebody can help me with the following: Suppose I have two tables. How can I find if the two have "identical rows"; in the sense that they are allowed to have different primary keys but in respect to all the other fields they are the same. Thanks in advance

$sql = 'SELECT `PageTitle` '; $sql .= 'FROM `Pages` '; $sql .= 'WHERE `PageID` = 1 LIMIT 0, 30'; I have run this query in MySQL control panel and it works perfectly. When I try to do it via PHP I get no results. If I select all rows (i.e I don't specify a "WHERE") I get one fewer

Why is a single space truncated in the following example? Leif alter table CURRENCY change column THOUSANDS_SEP THOUSANDS_SEP char(1) binary not null , type=MyISAM UPDATE CURRENCY SET THOUSANDS_SEP = ' ' WHERE NAME = 'SEK'

New to MySql: I can't seem to get a grab on what is a schema and what is a database So I have seen! the 'Mysql' Database and the Test Database I'm runninng the database Administrator and thinking "What I what to do now is create a new one of these to create my own tables in." The HELP seems rather opaque on this! So I'm thinking that perhaps...

Hi, I'm currently learning the ropes with CSS, PHP, MYSQL, Javascript etc... by redesigning my website as a database driven site. Okay, so I'm skilled at perl, data manipulation and data analysis and I've done a fair bit of (non CSS) HTML in the past and know what a relational database is. However, I'm having problems trying to formulate...

Centenas de pessoas já se consultaram com ela!!! - Atende ao publico deste 1960, sempre foi destaque em todas as feiras esotéricas que fez. - Leituras de cartas pelo telefone, R$50,00 reais a consulta (CONFIRMA A ESPIRITUALIDADE E A VIDENCIA E SÓ PAGUE DEPOIS DA CONSULTA). Com muita honestidade em tudo que sempre fez Voce vai se surpreender...

I can't help but think I'm re-inventing the wheel if I have to code my own interface! Isn't there some script, php code, or something (modifiable / customizable) available that lets me select records from two or more related tables and edit them. As mentioned in a previous post, I'm currently selecting a record from table 1; editing it,...

Hello, I had a harddisk crash and i was able to recover large files that would be most likly the MYD files, Is there a way to figure out any of 1. how many fields per record for each file. 2. What most likely to be the record fields. 3. Recover .frm and .myi

What is Your Quality of Life? Are you completely satisfied .... with your job? .... with the money you make and save? .... with your standard of living?

Is it possible to create Dynamic SQL queries in MySQL, like in SQL Server? i.e., the EXECUTE command or sp_executesql stored procedure in SQL Server. TIA

Hi, I need to update 25 * 5000 records, if I do one at the time it takes too long time, do any one have a good proposal ? regards Johnny

Hello, I have a question : Why the "Full Text Search" is not implemented in InnodbMySQL. Thank's Lhoussain.

Greetings, Several months ago my friends were rolling on the floor laughing when I told them I was going to build a profitable Internet business. "Yeah fat chance" they all said since I had absolutely very little computer skills and zero marketing experience! (Hint, I still don't!) You could waste months (and thousands of dollars)

Hi, I have upgraded my MySQL from 3.23 to 4.1.8. First of all I dumped my database with mysqldump. After installing new binary (debian woody) I have created respective database and uploaded my dumped data. Unfortunately what I can see on the webpage is onll ? instead of respective national characters. What should be the procedure to...

does anybody know why inserting ("XX", "test") and then ("XX", "test one") produce a warning? CREATE TABLE state ( country_code CHAR(2) NOT NULL, name VARCHAR(10) NULL, PRIMARY KEY(country_code, name),

My website uses php/mysql/linux and is hosted by a local web-hosting company. I access the db via cpanel/phpmyadmin and currently perform all testing and changes on the live db and website ( not good!). I would like a copy of the db on my own machine at home so I can test locally rather than on the live db. I have successfully installed...

My company is considering acquisition of a packaged application that's based on My SQL. This would be our first use of MySQL and the CEO is worried about using a "no-name" database (he's a Microsoft bigot). His specific concern is that an app written on MySQL will not have the necessary throughput and he's asked me to research MySQL's...

i have a situation to build a large scale app,there are many of client to call insert and select method from a corba object,then the corba object operation on the mysql db,but i am a much newbie for carba,so i need some help and suggestions, thanks you all.

Hello Windows XP sp2, Installed MyODBC 3.51 and the driver. It does not appear in the User/System DSN ODBC control panel. Does not appear in the driver tab Is listed in the ODBCINST.INI and appears in the registry REGEDIT4 Windows Registry Editor Version 5.00

Hello all, can someone advice me some links/infos on how to optimize MySQL server to execute very complex queries ? My configuration is as follows : P4 2.8Ghz/512MB running on Fedora Core 1 with latest updates, 2xHDD 36Gb SCSI 10000rpm (RAID 1), MySQL 4.0.22 configured with my-large.cnf, frontend application written in PHP 4. I need to...

Hi guys Have just decided to start to learn MySQL after many years in MS Access. Have got hold of MySQL 4.0.21 (Windows, as soon as I'm profiicient I'll move to Linux) - not the most recent version but it came with the book I bought (PHP, MySQL and Apache Allin One by Julie C. Meloni pubs Sams) as I wanted a reference to point me in the right...