Copy/Paste text from Ms Word into mysql

I am copy/pasting text from a microsoft word doc into phpmyadmin are there any special tricks to avoid strange characters...most of my text is in Spanish The only thing that seems to work is converting the text to ASCII which ditches all the Spanish formatting :( is there some process to make t

Re: change field names in a query

many thanks :) that was exactly what I needed g On Nov 26, 2004, at 4:27 PM, Rhino wrote: - Original Message - From: "Graham Anderson" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, November 26, 2004 6:28 PM Subject: change field names in a query what is the proper mysql syntax

Re: change field names in a query

- Original Message - From: "Graham Anderson" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, November 26, 2004 6:28 PM Subject: change field names in a query > what is the proper mysql syntax to change field names after the query > is done > > if I have a table with: > id > en

change field names in a query

what is the proper mysql syntax to change field names after the query is done if I have a table with: id englishText spanishText picture And I query the table with: select id, spanishText from myTable limit 30 how do I change the 'spanishText' field name to say 'language' ? many thanks g -- MyS

Re: Date query and date removal

- Original Message - From: "darrell troth" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, November 26, 2004 3:29 PM Subject: Date query and date removal > This will seem an easy question, but I cannot find a sample anywhere: > I have a database of bands appearing at a club. I

Re: Date query and date removal

- Original Message - From: "darrell troth" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, November 26, 2004 3:29 PM Subject: Date query and date removal > This will seem an easy question, but I cannot find a sample anywhere: > I have a database of bands appearing at a club. I

Re: Innodb Corruption with error logs now.

Carlos, - Original Message - From: "Carlos Augusto" <[EMAIL PROTECTED]> Newsgroups: mailing.database.myodbc Sent: Friday, November 26, 2004 8:46 PM Subject: Re: Innodb Corruption with error logs now. Well Heikki i don=B4t have those .frm and i don=B4t know the 'structure' of the corrpute

Date query and date removal

This will seem an easy question, but I cannot find a sample anywhere: I have a database of bands appearing at a club. I want to update the list sorted by date and have the results only show current date and beyond (i.e. - remove band that played last night from results page). This query is drivin

Newbie: How to deal with multiple languages

I have a mysql db that contains tables with multiple language fields for example... Artist_id 'PK' Artist_name Artist_pictLink Artist_purchaseLink Artist_bio_Spanish Artist_bio_English Artist_bio_German I have other tables with a similar layout...Is this needlessly complicated ? track_id 'PK'

RE: Take a normal Table and Make it a Heap table

Can I put a MyISAM table into Ram permanently? Thanks Donny Lairson President http://www.gunmuse.com 469 228 2183 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, November 26, 2004 11:59 AM To: sol beach Cc: Mysql Subject: RE: Take a normal Table and M

RE: Take a normal Table and Make it a Heap table

I ran this and got the following error. Why doesn't heap support autoincrement? Or does it and I need to do something different. CREATE TABLE `xmllinks2` ( `rowID` int(11) NOT NULL auto_increment, `affiliateID` int(11) NOT NULL default '0', `pluginName` varchar(255) NOT NULL default '',

Re: [MySQL] Re: Reversing DESC|ASC

Jigal van Hemert wrote: These are my results on MySQL 4.0.21 using InnoDB tables (it was suitable data for this test, InnoDB was used for other reasons): rpm -qa | grep -i mysql MySQL-server-4.1.7-0 MySQL-devel-4.1.7-0 MySQL-client-4.1.7-0 MySQL-shared-compat-4.1.7-0 MyS

RE: Take a normal Table and Make it a Heap table

I agree and we are rewriting this application ourselves to accomidate these types of issues of making it faster faster faster. But I would like to "patch what I have" at the same time. Call me greedy Thanks Donny Lairson President http://www.gunmuse.com 469 228 2183 -Original Message-

Re: Innodb Corruption with error logs now.

Well Heikki i don´t have those .frm and i don´t know the 'structure' of the corrputed databse. I make a report to my superior telling him that it´s not possible to recover the database without this information. I ´ll ask you just one more thing. Without .frm files or 'informations about the table'

Re: MySQL 4.1.3 Java/UTF8 support question

Hi Gleb, The problem was with the JDBC Connect string, earlier it was; jdbc:mysql://localhost:1/db1?useUnicode=true&characterEncoding=utf8 I changed that to: jdbc:mysql://localhost:1/db1?useUnicode=true&characterEncoding=UTF-8 and it works now. thanks, Ramesh On Fri, 26 Nov 2004 13:53:

"Lost connection to MySQL server during query" after 4.1 upgrade

Hello All! I have had mySQL 3.2 running on my server for about 2 years now without incident. Recently upgraded to 4.1, and suddenly I'm getting the following message from queries: "Lost connection to MySQL server during query" This is in response to a PHP script issuing a query to the mySQL ser

Take a normal Table and Make it a Heap table

I have to pull in 200 search rows and store them temporarily in a Table called xmllinks  This is so I can track the click on the one link of the 200 I bring down.  Nothing is permanently stored in this table   This is just a normal table in a db right now but during peak traffic times it bog

Re: Foreign Key Preventing Publishing to Web?

Please disregard my last post. I found another workaround - I saved the database table on my computer in an unzipped format, and I was able to export it to my website. It looks good! http://www.geoworld.org/north_america/usa/az/counties/index.php Thanks. ___

Re: binary column type

At 2:52 -0800 11/26/04, Chenri J wrote: What is 'binary' in column type stand for? is it describe how the data is stored (in biner value)? what do we want use it for? - encryption ? - space efficiency ? - fast index ? - or ? I've searched the mysql manual but didn't find any clue about it thank

Re: MySQL 4.1 and PHP5 with old client

In the last episode (Nov 26), Andre Matos said: > I have installed MySQL 4.1.7-nt + Apache 2 + PHP 5.0.2 + PHPMyAdmin > 2.6.0-pl1 on my Windows XP Pro SP2. I am trying to solve the problem with > MySQL PHP Old Clients using OLD_PASSWORD instead of just PASSWORD. > > How can I set on "my.ini" to st

Re: MySQL 4.1 and PHP5 with old client

At 11:21 -0500 11/26/04, Andre Matos wrote: Hi, I have installed MySQL 4.1.7-nt + Apache 2 + PHP 5.0.2 + PHPMyAdmin 2.6.0-pl1 on my Windows XP Pro SP2. I am trying to solve the problem with MySQL PHP Old Clients using OLD_PASSWORD instead of just PASSWORD. How can I set on "my.ini" to start MySQL u

Re: How to retrieve constraints and links from MySQL tables?

Hello, > You can use: > > show create table employee; > > or > > show table status like 'employee'; > in the column "comment" you have the information you are looking for. I don't think "comment" works properly - it's too small if you have multiple foreign key constraints. With regards, Martijn

MySQL 4.1 and PHP5 with old client

Hi, I have installed MySQL 4.1.7-nt + Apache 2 + PHP 5.0.2 + PHPMyAdmin 2.6.0-pl1 on my Windows XP Pro SP2. I am trying to solve the problem with MySQL PHP Old Clients using OLD_PASSWORD instead of just PASSWORD. How can I set on "my.ini" to start MySQL using as a default the OLD_PASSWORD? I tr

Re: Foreign Key Preventing Publishing to Web?

--- [EMAIL PROTECTED] wrote: > hi, > > in the script you have > " CONSTRAINT `0_132` FOREIGN KEY ( `SCode` ) > REFERENCES > `statesarticles` ( `SCode` ) ON UPDATE CASCADE " > and this code it's a definition of the foreign key. > run the script without this part of the code. * * * * * * * * * *

Re: Innodb Corruption with error logs now.

Carlos, ok, this makes sense. InnoDB: 2 transaction(s) which must be rolled back or cleaned up InnoDB: in total 2 row operations to undo InnoDB: Trx id counter is 0 44866816 041126 13:59:13 InnoDB: Error: page 0 log sequence number 1 3814617350 InnoDB: is in the future! Current system log sequence

latin1/utf-8 problem

I have a strange, irritating problem that I think is to do with MySQL. I have a table on a live (shared hosting) system that, when I use it on my local system, seems to wind up in utf-8 rather than latin1. Here's the set-up: Live system - MySQL 3.2.3.56, PHP 4.1.2, Apache 1.3.27. MySQL is config

Re: Which MySQL software is useful for the clients?

At 14:46 +0100 11/26/04, Gunter Götz wrote: Hello, At a linux server with Red Hat I have installed "MySQL-server-4.0.22-0.i386.rpm". That's the server RPM. There is also a client RPM, which is what you need to install for the mysql and mysqladmin programs. See: http://dev.mysql.com/doc/mysql/en/L

Re: Innodb Corruption with error logs now.

Well look what i did: I changed innodb_log_file_size as you asked me for 5M and then i tryed to start mysqld again then i it doesnt run. And the output at err.log was this one: I will remember that ibdata1 is my old corrputed data. And iblogile1 is a new iblog because the iblogfile corresponding

Re: Foreign Key Preventing Publishing to Web?

hi, in the script you have " CONSTRAINT `0_132` FOREIGN KEY ( `SCode` ) REFERENCES `statesarticles` ( `SCode` ) ON UPDATE CASCADE " and this code it's a definition of the foreign key. run the script without this part of the code. Citando David Blomstrom <[EMAIL PROTECTED]>: > When I was first

Re: Which MySQL software is useful for the clients?

Gunter Götz wrote: > At a linux server with Red Hat I have installed > "MySQL-server-4.0.22-0.i386.rpm". > This software does not maintain a shell like the tool "mysql" and > "mysqladmin". I want to use that > tools So download and install the mysql client -- why is this challenging? Note: if you

Foreign Key Preventing Publishing to Web?

When I was first learning to work with MySQL, I discovered that I couldn't publish my databases to the Internet if they had foreign keys. So I stripped out all the foreign keys and got them online. I'm not trying to publish a table I haven't worked with in a while, but I just get error messages. T

Re: [SOLVED]Insert statement problem

--- [EMAIL PROTECTED] wrote: > I think you need an UPDATE statement > UPDATE MyTable set EndDate=DATE_ADD(InitOn, INTERVAL > LenChoice DAY) WHERE > RecordID = ; > > Insert *always* creates new records if successful > and cannot be used to > modify them. > Update *always* updates recirds in pos

Re: Insert statement problem

Stuart Felenstein <[EMAIL PROTECTED]> wrote on 26/11/2004 13:54:31: > I'm trying to build an insert query that will add a > value into a field , after the first insert query adds > the record. > > Relevant table information: > > +-+-++--+ > | RecordID

Insert statement problem

I'm trying to build an insert query that will add a value into a field , after the first insert query adds the record. Relevant table information: +-+-++--+ | RecordID| InitOn | LenChoice | EndDate | + [PrimID,AutoInc]| [Date] | [int]|

Re: MySQL 4.1.3 Java/UTF8 support question

Hello. What output produced show variables like '%char%'; show variables like '%colla%'; You should also set utf8 as server character set. See: http://dev.mysql.com/doc/mysql/en/Charset-defaults.html Ramesh Vadlapatla <[EMAIL PROTECTED]> wrote: > Hi, > > In my.cnf, I have: > [my

Re: I want cluster, can I use MySQL?

Hello. MySQL cluster can be configured with a range of fail-over and load-balancing options. And it is really ready enough for commercial usage. Complete information about licensing you can request at [EMAIL PROTECTED] Koon Yue Lam <[EMAIL PROTECTED]> wrote: > Hi list ! > I want a hi

Which MySQL software is useful for the clients?

Hello, At a linux server with Red Hat I have installed "MySQL-server-4.0.22-0.i386.rpm". On the client (Win 2000) I have installed the MySQL Administrator "mysql-administrator-1.0.14-win.msi" and the MySQL Query Browser "mysql-query-browser-1.1.1-gamma-win.msi". All software is downloaded from h

RE: How to retrieve constraints and links from MySQL tables?

You can use: show create table employee; or show table status like 'employee'; in the column "comment" you have the information you are looking for. Marc. -Message d'origine- De : Varakorn Ungvichian [mailto:[EMAIL PROTECTED] Envoyé : vendredi 26 novembre 2004 09:32 À : [EMAIL PROTECT

Re: How to retrieve constraints and links from MySQL tables?

> So, I'm running a MySQL database (version: 4.0.21) for > a personal project of mine, and I would like to learn > how to retrieve constraints and links from the table > after it's been created. The create statements read > thusly: > When I run "show columns from employees", there is no > indicat

How to retrieve constraints and links from MySQL tables?

So, I'm running a MySQL database (version: 4.0.21) for a personal project of mine, and I would like to learn how to retrieve constraints and links from the table after it's been created. The create statements read thusly: CREATE TABLE positions ( position_id tinyint(4) DEFAULT '0' NOT NULL AUTO_

Re: binary column type

> What is 'binary' in column type stand for? > is it describe how the data is stored (in biner value)? > what do we want use it for? > - encryption ? > - space efficiency ? > - fast index ? > - or ? AFAIK it's used for determining the behaviour while comparing values (operators, sorting, etc.)

Re: binary column type

Chenri J <[EMAIL PROTECTED]> wrote on 26/11/2004 10:52:51: > What is 'binary' in column type stand for? > is it describe how the data is stored (in biner value)? > what do we want use it for? > - encryption ? > - space efficiency ? > - fast index ? > - or ? > > > I've searched the mysql manu

Using mysql and mysqladmin

Hello, I have installed "MySQL-server-4.0.22-0.i386.rpm" as server at a linux computer and at the PC (windows 2000) as client was installed "mysql-administrator-1.0.14-win.msi" and "mysql-query-browser-1.1.1-gamma-win.msi". Now I have two questions: Although the installtion at the server was suc

binary column type

What is 'binary' in column type stand for? is it describe how the data is stored (in biner value)? what do we want use it for? - encryption ? - space efficiency ? - fast index ? - or ? I've searched the mysql manual but didn't find any clue about it thanks for your help before.

Re: [MySQL] Re: Reversing DESC|ASC

From: "Ashley M. Kirchner" > Jigal van Hemert wrote: > > >You can cheat a bit and use a UNION of one SELECT: > > > >(SELECT field1,field2,field3 FROM table ORDER BY field3 ASC LIMIT 2) ORDER > >BY field3 DESC; > > > This didn't work as expected. Very odd! These are my results on MySQL 4.0.21

Re: [MySQL] Re: Reversing DESC|ASC

Jigal van Hemert wrote: You can cheat a bit and use a UNION of one SELECT: (SELECT field1,field2,field3 FROM table ORDER BY field3 ASC LIMIT 2) ORDER BY field3 DESC; This didn't work as expected. First, I need DESC sorting instead of ASC to get what I need: SELECT field1,field2,field3 FROM

Re: Socket Error While Starting MySQL

Hello Mukund, Remove the /etc/my.cnf file and start the mysqld daemon again. It will work Thanks, Mathan - Original Message - From: "Mukund N Rathi" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, November 26, 2004 11:31 AM Subject: Socket Error While Starting MySQL > Hi

Re: Reversing DESC|ASC

- Original Message - From: "Ashley M. Kirchner" <[EMAIL PROTECTED]> > > > SELECT field1,field2,field3 FROM table ORDER BY field3 DESC LIMIT 5; > My problem is, I need the last two in that list, in the order > they're listed there. If I reverse the order (by using ASC), I will get:

Reversing DESC|ASC

I'm currently running a query on a db that looks as follows: > SELECT field1,field2,field3 FROM table ORDER BY field3 DESC LIMIT 5; This produces: ++-++ | field1 | field2 | field3 | ++-++ | 1 | Title 1 | 2004-09-