auto_increment problem

Anybody know if there's a way to change a primary key field that is not auto-incremented, turning on auto-increment but preserving the values that are currently in it? TIA, Paul W -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Synchronising SQL Server and MySQL

I need to synchronise an SQL Server 2000 back end with a MYSQL database on a different box (windows). Can anyone point me in the right direction. I have found a number of resources on synchronising 2 sql server databases but I cant find anything on SQLServer and MySQL. Thanks in Advance --

issue with 'count'

hi to all, and thank for your valuable help my problem SELECT c.id, count(cug2.id_curso) as num_profe_curso FROM nuke_elearning_curso as c, LEFT JOIN nuke_elearning_curso_usuario_grupo as cug2 ON c.id = cug2.id_curso WHERE num_profe_curso > 0 group by c.id esta sentencia sql busca la canti

import from MySQL into MySQL

I have the following problem : I have been asked to redevelop a clients website which is written in PHP and uses MySQL as the backend. This site is on a remote server so there is only so much I can do with it. They want me to move it to a Windows box in our office and convert the pages to asp but

Certifications

Hi! I just passed the Mysql Core Certification ... (Applause!!!)... Thank you! ;) I was wondering if there is a shorcut for MySQL certified? Something like BSc, MSc. PhD... You got the idea. Thanks, Paul -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe

Re: MySQL Order by 2 date fields

ify date is more important (if exists) than creation > > date? > > What about an ORDER BY with a CASE statement that uses > the CreationDate if ModifyDate = 0 and ModifyDate if it's <> 0. > > With regards, Or use: ORDER BY if(ModifyDate = 0,1, ModifyDate), CreationDate

Problem with large UNION query in MySQL 4.0.4-beta

? Regards, paul - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe,

Re: Problem with large UNION query in MySQL 4.0.4-beta

I should also mention that this error is only happening using the mysql C API ( mysql_query() ). If i use mysql client and paste the exact same query, i get the proper result everything. thanks, paul > hello, > > When I perform a large union query with 11 tables I often get t

Re: Problem with large UNION query in MySQL 4.0.4-beta

Ignore this query folks, my damn signal timer was causing the problem, why I was accessing mysql from a signal interrupt, i'll never know. sorry for wasting anyones time. thanks, paul > I should also mention that this error is only happening using the mysql C > API ( mysql_query()

4.1.12 rpm's

Can anyone tell me where I can get 4.0.12 server and client rpm's? TIA, Paul -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: 4.1.12 rpm's

This may indicate incredible ignorance but all I can find there are tar.gz files which untar into the complete distribution but no rpm's are present. Thomas Spahni wrote: On Wed, 26 Mar 2003, Paul wrote: Can anyone tell me where I can get 4.0.12 server and client rpm's? www

Re: 4.0.12 rpm's

Thank you, Jim. I clearly just didn't scroll down far enough! Jim Winstead wrote: On Wed, Mar 26, 2003 at 10:30:32AM -0800, Paul wrote: This may indicate incredible ignorance but all I can find there are tar.gz files which untar into the complete distribution but no rpm's are pres

Dropped database

Hello mysql, I dropped an entire database but I have the frm, myd and myi files in a backup. What are the complete steps to restoring this database? Thank you for the help. -- Best regards, Paul mailto:[EMAIL PROTECTED

MySQL 3.23.46 corrupts MYD and MYI files frequently

-1 mysqlmysql9090 Jan 15 09:19 OURTABLE.frm Regards, Paul - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request th

Re: How to mirror MySQL database on two servers?

Scott, Try the following perl script to copy the contents of one mysql table from a mysql database and insert it's contents into another mysql database on a different host/server/computer under the same table name. Essentially a mirrored copy. Can be useful in a cron or a shedule as it wont outpu

ALTER TABLE not replicated in MySQL v 3.23.48

TER TABLE works correctly (in this respect) in version 4.0.1 >Submitter-Id: Paul van Diepen >Originator:Paul van Diepen >Organization: VMS-Keytrade >MySQL support: none >Synopsis: Replication of ALTER TABLE does not work in v3.23 >Severity: serious >Priority:

How to automate bin-log clean-up with replicated MySQL servers?

iles is another way? Thank you for your suggestions, Paul van Diepen VMS-Keytrade sa/nv Bld du Souverain 100 B-1170 Brussels - Belgium Phone: +32-(0)2-679.90.00 Fax: +32-(0)2-679.90.01 - Before posting, please check: http:

column restrict:fraction < 10 ???

.) Please respond to [EMAIL PROTECTED] and/or [EMAIL PROTECTED] if this mailing doesn't list [EMAIL PROTECTED] as a possible REPLY-TO: address. Thank you again, and please remember I am not privy to the list directly. Paul __ Do You Yahoo!?

Re: Select records from remote machine.

You can do this by normal execution but with the -h parameter specfying the host mysql -u mysql -p -h - Original Message - From: Charitha To: [EMAIL PROTECTED] Sent: Monday, April 29, 2002 3:47 PM Subject: Select records from remote machine. Hello all, In mysql how can i select or

Re: Maximum number of rows in the table

Our MySQL table currently has 2.5million rows, but I have seen this go upto at least 17 million rows without a single problem. sql, query - Original Message - From: Remco Oosten To: [EMAIL PROTECTED] ; [EMAIL PROTECTED] Sent: Tuesday, May 07, 2002 5:08 PM Subject: Re: Maximum number of ro

Re: Newbie Question

Try this... mysqladmin -u root -p password 'abc123' When you get the password prompt hit enter (dont type anything) Your new root password is now abc123. The default root password is blank, thats why u just hit enter - Original Message - From: Kevin Queen To: MySQL List (E-mail) Sent: M

can mysql do this sql ?

us is DEAD . The records containing DEAD will occur in the bottom block. Then further ordering will occur in these blocks.Can this be acheived using 1 SQL query ? Many thanks Paul - Before posting, please check: http://www.mys

how do you form this SQL?

us is DEAD . The records containing DEAD will occur in the bottom block. Then further ordering will occur in these blocks.Can this be acheived using 1 SQL query ? Many thanks Paul - Before posting, please check: http:

Re: can mysql do this sql ?

thank for all your help ORDER BY status = 'DEAD', '$sess_quotes_search_by' ... was the correct modification paul - Original Message - From: "Svensson, B.A.T. (HKG)" <[EMAIL PROTECTED]> To: "Harald Fuchs" <[EMAIL PROTECTED]> Cc: &l

Re: Date Problem

> > Hi All > I have a column in my MySql database with datetime column.i want to get only date > part of that column .is any easy way to do that. > Thanks a Lot > Paul > > > - Before pos

Re: Crash & Incorrect Database

Stavros, As an absolute last resort try the following... Shutdown mysql first. copy your database backups to a safe place before doing this. Removed all tables first off. Then move the .MYD and .MYI and .frm files for each database. Run mysqladmin and re-create all of the tables again. and leave

can't start mysql.server

Best regards, Paul - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscr

Gemini Problems

-- gemini-recovery=FULL set-variable= gemini_buffer_cache=128M set-variable= gemini_io_threads=4 set-variable= gemini_connection_limit=200 Any help or pointers greatly appreciated :) Paul http://dbforums.com ---

where is setup.exe

e' program. Unfortunately I didnt find a file with name setup.exe within the downloaded file mysql-3.23.43.tar.gz. Could you help me further? Many thanx Paul - Before posting, please check: http://www.mysql.com/manual.ph

Re: Is there any mySQL forums ?

s, including web access to most database related usenet groups. Paul - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request t

Cascade deletes?

Does MySQL support cascaded deletes? If so is it only with InnoDB? Thanks Paul - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To

Newbie question: Storing text

store it? Text or long varchar (something like varchar(1000)? Which field supports full text search? Hob about if I want to store the description that is html formatted? Would that choice differ (TEXT/VARCHAR)? Thank you, Paul

Any limits on the number of fields ?

fields, i havn't pinned down exactly where the threshold of creatabilty is but it is around the 100 mark. All the tables have field of type varchar(20) and i am currently using version 3.23.35 beta Any thoughts or insights would be kindly received Kind Regards Paul [EMAIL PROTECTED]

RE: MySQL 3 to 5 upgrade

important, your MySQL host should really provide a 5.x playground for you to check your app out in for at least several weeks prior to the upgrade. Just waking up one morning with the database "upgraded" is almost surely going to be a mess. Good luck, Paul -Original Message- F

If exists query.

I am trying to formulate a query that will increment if a condition is true. For example, if I do a select (just let me know if there was data on this day, if so increment count by 1 and check the next day) where timestamp between jan and feb. Thanks. -- MySQL General Mailing List For list archi

Re: If exists query.

ECTED]> wrote: > Paul Halliday wrote: > > I am trying to formulate a query that will increment if a condition is true. > > > > For example, if I do a select (just let me know if there was data on > > this day, if so increment count by 1 and check the next day) where >

Re: If exists query.

On 4/23/06, John Hicks <[EMAIL PROTECTED]> wrote: > Paul Halliday wrote: > > I am doing queries that produce a table that looks something like this: > > > > Count | IP Address| First Seen| Last Seen | Days > > 5000 10.0.0.1 2005-12-1

Re: Can I select from remote tables in mysql 5.0.18-standard-log?

informix ? You can use FEDERATED to access tables on other MySQL servers. http://dev.mysql.com/doc/refman/5.0/en/federated-storage-engine.html -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http

Re: selecting all records inserted last 1 minutes?

TIME(), INTERVAL 15 MIN) ?!? Thanks for any help. If you mean "what is the syntax of BETWEEN?," it's in this section of the manual: http://dev.mysql.com/doc/refman/5.0/en/comparison-operators.html -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.

Re: selecting all records inserted last 1 minutes?

At 22:29 -0500 4/27/06, Afan Pasalic wrote: No, not exactly. More as "there is a solution"... What would be the best way to do? -afan What's wrong with WHERE last_access >= NOW() - INTERVAL 1 HOUR ? You don't want CURTIME(), I think, because that has only time, not th

RE: How to move the MySQL data directory?

Specify the data dir in the local my.cnf and be sure your instance uses it by starting it with the --defaults-file parameter set to that instance's local copy. Regards, Paul -Original Message- From: Yves Goergen [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 02, 2006 3:11 PM To

Re: GROUP BY *column* when *column* is NOT in SELECT list?

tion or mentioned in the GROUP BY...how am I wrong? It's a MySQL extension to GROUP BY: http://dev.mysql.com/doc/refman/5.0/en/group-by-hidden-fields.html -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL General Mailing List For list arc

Re: insert html into database

At 15:55 -0500 5/18/06, Steve wrote: Hi everyone... how do I enter html code into my database??? Like any other string. -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To

RE: How to find out about SSL connection?

ient and server, but this is actually non trivial to determine if the traffic is really encrypted, especially if compression is used. If there is another method, I would be interested in hearing it as well. Regards, Paul -Original Message- From: Yves Goergen [mailto:[EMAIL PROTECTED] Sent

RE: How to find out about SSL connection?

And of course just as I send this to a public list, I realize there is also Ssl_version and Ssl_verify_mode, which seem to be session level counters to give us the information we are after here. *sheepish* -Original Message- From: paul rivers [mailto:[EMAIL PROTECTED] Sent: Saturday

Backup and recovery problems

ind file: './mysql/time_zone_transition_type.frm' (errno: 13) (1017) When I recover the databases using this command: mysql --force -u root -p -h localhost < all.sql Tables are missing (and not the ones the dump is complaining about) and relations are broken. I'm assu

Re: Backup and recovery problems

On Thursday 25 May 2006 12:09, you wrote: > Paul Nowosielski wrote: > >Dear all, > > > >I've been testing our backup and recovery strategies here at work. > >When dumping all the databases I'm using this command: > > > >mysqldump --all-datab

Re: Backup and recovery problems

#x27; not found (Errcode: 2)) /usr/local/mysql/bin/mysqldump: Can't get CREATE TABLE for table `procs_priv` (Can't open file: 'procs_priv.MYI'. (errno: 138)) /usr/local/mysql/bin/mysqldump: Can't get CREATE TABLE for table `time_zone_name` (File '/usr/local/src/mys

Re: max size of TEXT columns

really to any length? any hint is very much appreciated, thanks in advance. suomi -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB,

Re: select 9000000000000.10*19.80 wrong result 178200000000001.97

1.9800 | ++ MySQL 3.23, 4.0, 5.1: mysql> select 9.10*19.80; ++ | 9.10*19.80 | ++ | 1782001.97 | +----+ -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA

Re: select 9000000000000.10*19.80 wrong result 178200000000001.97

also influenced by the div_precision_increment system variable, which is described on this page: http://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL General Mailing List For l

Re: set "DEC" as a column name : forbidden

understand why this cannot be allowed for a column name. Is there a turn around ? This is annoying ; I add to name the column as "DECL" which is much less meaning full in the astronomy community. thanks, =_==_==_==_==_==_= =¯==¯==¯==¯==¯==¯= Gilles Missonnier IAP - [EMAIL PROTE

Re: question+comment : Re: set "DEC" as a column name : forbidden

At 17:38 +0200 5/31/06, Gilles MISSONNIER wrote: Thank you Paul DuBois. I have 2 questions for you : 1-Why the error code (1064) can't lead explicitly to the syntax problem ? I'm sorry, I don't understand the question. 2-Could you tell me how I could go directly to th

Re: auto_increment Question

es into the column if they aren't already there. But you could also insert NULL (or omit people_id from the statement entirely), and then MySQL will generate sequence numbers automatically. -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL Gen

Re: Windows Compiled Help MySQL Reference Manual -- Error

;ll take a look into it. Thanks. -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: mysql-5.0/Docs

//svn.mysql.com/svnpublic/mysqldoc/ See: http://dev.mysql.com/tech-resources/sources.html If you just want to download pre-built documentation in various output formats: http://dev.mysql.com/doc/ -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQ

Re: mysql-5.0/Docs

t it? It's the document from which you're quoting. -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Stored Procedures and DECLARE weirdness

ple near the end of this section: http://dev.mysql.com/doc/refman/5.0/en/create-procedure.html Also: http://dev.mysql.com/doc/refman/5.0/en/begin-end.html -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL General Mailing List For list ar

Re: How can i decrypt password

MySQL you are using - and which crypt method you are using for the passwords. mysql.user.Password is encrypted using the same algorithm as the PASSWORD() function. The algorithm changed in 4.1.0 and again in 4.1.1, but in all cases, it is one-way encryption. -- Paul DuBois, MySQL Documentatio

Re: Can I have multiple sockets?

ts e.g. a socket per database or would I have to run several instances of a MySQL server giving each instance a different (socket) configuration? The server listens to a single socket file. You'd need multiple instances. -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, US

Re: ERROR 1016 (HY000): Can't open file: 'agent.ibd' (errno: 1)

) set the permissions to 777 (read, write, execute) for all the files in sfgnew d) restarted mysqld Murthy -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysq

Join help

VENUE_ID = tv.ID and tv.id =tvtx.VENUE_ID AND tvtx.TYPE_ID = vtp.PKEY and vax.VENUE_ID =tv.ID AND vax.AGE_ID = vage.PKEY AND UNIX_TIMESTAMP(t.td_date) >$time GROUP BY t.td_id Thanks for the help! -- Paul Nowosielski -- MySQL General Mailing List For list archives: http://lists.mysql.c

Left Join Help

run the full query on a daily basis without killing the DB engine. The query needs to pull in about 50,000 results. Does anyone see a way to optimize this query or rewrite it so it doesn't cause a huge system load? Thank you, -- Paul Nowosielski Webmaster -- MySQL General Mailing

Re: Left Join Help SOLVED

tv.ID=tvc.VENUE_ID) LEFT JOIN tbl_VENUE_AGE_XREF ON (tv.ID=tvax.VENUE_ID) LEFT JOIN tbl_VENUE_AGES ON (tvax.VENUE_ID = tvage.PKEY) WHERE td_date > NOW() AND (td.td_id = artd.td_id AND artd.artist_id = art.PKEY AND td.venue_id=tv.ID) 45929 rows in set (3 min 11.75 sec) Best Regards, -- Paul Now

PBXT version 0.9.5 has been released

directly to me. Thanks for your support! Best regards, Paul McCullagh SNAP Innovation GmbH PBXT Release Notes == --- 0.9.5 - 2006-07-03 RN15: This version concludes the re-structuring of the PBXT implementation. I have made a number of major changes, including: - All

Re: PBXT version 0.9.5 has been released

Hi DÆVID, Thanks for your feedback. What version of IE are you using? You got a point about the style. I'll look into it... Please reply to me directly, or write to [EMAIL PROTECTED] Thanks, Paul On Jul 6, 2006, at 9:17 PM, Daevid Vincent wrote: Your site has a bunch of JS errors (usi

RE: May I create more than 200 databases for one mysqld?

ion to the next? Since mysql is threaded, sometimes it makes sense to run multiple mysqld processes on the same machine. But again, this is more an administrative decision than a technical one. 200+ databases is certainly well within practical mysqld limits. Regards, Paul -Original Message

Announce: Log Buffer, a Carnival of the Vanities for the DBA world

val-of-the-vanities-for-dbas Thanks and cheers, Paul

Searching through an alphabetical range

Dear All, I need to write a query that searches last names between the ranges of m through z. Is there a way to do this in the query? Thank You, -- Paul Nowosielski Webmaster office: 303.440.0666 ext 219 cel: 303.827.4257 -- MySQL General Mailing List For list archives: http

Re: [5.0] Left Join Problem

ed is here: http://dev.mysql.com/doc/refman/5.0/en/join.html See particularly "Join Processing Changes in MySQL 5.0.12" -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Searching through an alphabetical range

I have the solution: SELECT DISTINCT email_address FROM mailing_list WHERE last_name >= 'm' AND last_name <= 'z' Thank you, -- Paul Nowosielski Webmaster On Friday 21 July 2006 11:03, Paul Nowosielski wrote: > Dear All, > > I need to write a query t

Re: Searching through an alphabetical range

Its working fine for me: mysql> SELECT DISTINCT email_address FROM mailing_list WHERE marketing_list LIKE 'Y' AND last_name >= 'm' AND last_name <= 'z'; 26371 rows in set (1.00 sec) Thank You, -- Paul Nowosielski Webmaster On Friday 21 July 2

Re: How to "control" the number of sql dameons?

ysqld processes, that doesn't necessarily indicate that you have multiple multiple daemons. For example, on Linux, you're see one mysqld per thread, but there is still just one mysqld. -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL Gener

PBXT version 0.9.6 has been released

4.1.16 and runs on Mac OS X and Linux. Any questions, comments and bug reports can be sent directly to me. Thanks for your support! Best regards, Paul McCullagh SNAP Innovation GmbH PBXT Release Notes == --- 0.9.6 - 2006-08-05 RN35: NOTE: This version is incompatible

Re: question about the query against to the federated engine tables

As a storage engine, federated does not have the information as to exactly which columns have been selected. This information is simply not passed down to the engine. However, if there is index support for a query then MySQL will indicate to the engine if it is only interested in the columns o

Re: Can a row be refered using row number?

5 No, because you don't know what the row number is. Even if you did, the number is not guaranteed to remain the same over time. The table should include a primary key, so that you can refer to each row in the table by its unique key number. -- Paul DuBois, MySQL Documentation Team Madison, Wis

Re: mysql naming convention

#x27;flags' in a C program. It is extremely useful to be able to quickly find all references to a particular flags field. This also makes a program for outsiders easier to understand because it is possible to answer questions like "How is this field/column used?", but just doing

Re: table sizes, rolling data.

If you use an auto_increment column (e.g. id int auto_increment) then your trigger could do something like this: DELETE FROM table WHERE id < new.id - 100; On Aug 30, 2006, at 3:49 PM, Dan Buettner wrote: You could accomplish this with a trigger on the table - on INSERT, execute a DELETE st

Re: DBD/DBI datetime insert

At 7:23 PM -0500 9/3/06, Hal Wigoda wrote: anyone have the code that will insert the current time into a datetime field in a table while using perl DBI/DBD::mysql? Something like this: $dbh->do("INSERT INTO t (col_name) VALUES(NOW())"); -- Paul DuBois, MySQL Documentation

Re: problem with InnoDB

On Sep 7, 2006, at 3:32 PM, <[EMAIL PROTECTED]> wrote: I need to know the number of rows that a query will return before actually executing the query. So I am sending select count(*) before sending select *. Actually I need to reject queries if the number of records that it will return is huge,

Re: where are the .MYI and .MYD files?

[EMAIL PROTECTED] wrote: I've installed MySQL, created a database and tables and then loaded fields into them. I use the command line client and can see the fields, use the select command and every thing is OK, but when I look for the table files in the data directory, only the .frm ones appear,

Re: Shell

Hi Steve, You have to edit a file called ".tcshrc" which resides in your users home directory, and add ":/usr/local/mysql/bin" to the PATH environment variable. The tricky part is, this file is not visible to any text editor (for example BBEdit), so I always use a command line editor, for

Re: Could someone help this guy :-?

Behrang Saeedzadeh wrote: Hi, Could someone help this guy work around this problem in MySQL: http://www.redhillconsulting.com.au/blogs/simon/archives/000347.html I think the answer to his questions lies in the manual: http://dev.mysql.com/doc/refman/5.0/en/data-type-defaults.html If a column

Re: Unicode

x27;t use CHAR(...) UNICODE, unless the text field is short, because there is a bug with the removal of trailing spaces in the index, that makes the index file much larger than necessary. - Paul On Sep 11, 2006, at 11:58 AM, Charlie Schaubmair wrote: Aloa, ich muß in einer Webanwendung jetzt

Re: Varchar mystery

Jerry Schwartz wrote: I'm using MySQL Linux version 4.1.21 standard. I have a table with fields of a variety of types, including varchar(255) and text (which might matter). When I do SELECT MAX(LENGTH(x)) FROM tx; where x is a varchar(255), I get back 266 as the result of the query! This

Re: South American timber products.

?!:( A license to SPAM: On Sep 12, 2006, at 4:57 AM, Agrapin S.A. - Timber Industry and Trading wrote: This message is in full compliance with U.S. Federal requirements for commercial email under bill S.1618 Title lll, Section 301, Paragraph (a)(2)(C) passed by the 105th U.S. Congress and

Re: auto_increment field start value

At 14:16 -0500 9/22/06, [EMAIL PROTECTED] wrote: I seem to recall that when creating a table, you could designate an auto_increment field to begin counting at zero(0) instead of one (1), but I can't find an example in the documents. Don't store 0 in an AUTO_INCREMENT column. -- P

Re: fields separator

s you data to convert runs of spaces to a single space (or some other character that doesn't appear in your data), and the load the preprocessed result with LOAD DATA. -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL General Mailing List For lis

[ANN] Beta version of the PBXT storage engine has been released

://www.primebase.com/xt For more details and news, please checkout my blog: http:// pbxt.blogspot.com Best regards, Paul McCullagh SNAP Innovation GmbH -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: need help on before insert trigger

any idea how to do that? thanx in advance The syntax for your IF statement isn't correct. You need a THEN after the condition. http://dev.mysql.com/doc/refman/5.0/en/if-statement.html -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL Gen

Re: How to not repeat fields

UNIQUE index to provide a uniqueness constraint on anything from the 256th character on. -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: How to not repeat fields

test case that shows repeats? How can i avoid the repeates rows ? Best Regards, Deckard Paul DuBois wrote: At 22:11 +0100 10/8/06, Deckard wrote: Hi, How do i dreate a table, let's say: CREATE TABLE wl_articles(wl_articles_id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, titl

Re: How to not repeat fields

licate. But in that case, I suggest that what you really want is a separate PRIMARY KEY on the wl_user_id column, and a UNIQUE index on (name, email, password). That will prevent duplicate combinations of those three column values. Paul DuBois wrote: At 22:21 +0100 10/8/06, Deckard wrote: H

Re: How to not repeat fields

At 17:17 +0100 10/9/06, Deckard wrote: Hi Paul, Now, i have this: CREATE TABLE wl_users(wl_user_id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, name VARCHAR(255) NOT NULL, email VARCHAR(50) NOT NULL, password VARCHAR(40) NOT NULL, UNIQUE (wl_user_id, email)) TYPE=MyISAM; and the issue persists

£ (Great Britain Pound) breaks MySQL insert and u pdate - disastrous overwrite

t one row perfectly well. The character set in the database table is latin1. The character set in the browser is ISO-8859-1, and the character set in Tomcat and in my application are all the default. Samples and info below. Thanks for any help on this urgent problem!! Thanks, Paul Tabl

Re: £ (Great Britain Pound) breaks MySQL insert a nd update - disastrous overwrite

ows at all, rather than overwriting them all. Again, the update and insert statements work when pasted into the mysql command line utility. A perl script brings up the data nicely, and does an update including a £ sign to just one row without a problem. So, has anyone ever encountered t

Re: £ (Great Britain Pound) breaks MySQL insert a nd update - disastrous overwrite

e advert set adverttitle='jobs pages', mainbody='idiotic stuff £50605 blahblahblah...', forfurtherinfo='contact Paul Warner, MISD editing this text.', finalcopy='RESEARCH ARTISTManagement Information Services Division Salary: £28,930.00-£50,219.00 paidiotic stuff

Re: £ (Great Britain Pound) breaks MySQL insert a nd update - disastrous overwrite - FIXED

rom this thread. Regards, Paul - Original Message From: Philip Mather <[EMAIL PROTECTED]> To: MySQL List Sent: Friday, October 20, 2006 2:24:18 PM Subject: Re:£ (Great Britain Pound) breaks MySQL insert and update - disastrous overwrite Warren Young wrote: > Paul Warner wrote:

Re: £ (Great Britain Pound) breaks MySQL insert a nd update - disastrous overwrite - FIXED

upgraded to a new server running 5.0.22 a couple of weeks ago. And that was it. It seems one better keep the connector in the same version realm as the database. Now we are in UTF-8, it is saving everything I can throw at it without creating garbage characters. Whew. Regards, Paul

Re: change format of date fields during LOAD DATA INFILE?

%m/%d/%y'); The format string depends on the format of your input data, of course. http://dev.mysql.com/doc/refman/5.0/en/load-data.html -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysq

  1   2   3   4   5   6   7   8   9   10   >