RE: Cant connect with SSL support

try connecting using the server name not localhost hth Andrew >-Original Message- >From: Karam Chand [mailto:[EMAIL PROTECTED] >Sent: 02 June 2003 14:43 >To: [EMAIL PROTECTED] >Subject: Cant connect with SSL support > > >Hello > >I have a MySQL 4.0.3 server with SSL option. I know >that t

Re: Query problem

No, not swearing - just As Soon As Financially Possible!!! Robin *** Still need an answer if someone can help * - Original Message - From: "Nils Valentin" <[EMAIL PROTECTED]> To: "Sparky Kopetzky" <[EMAIL PROTECTED]>; "My Sql List" <[EMAIL PROTECTED]> Sent: Sunday, June 01,

Cant connect with SSL support

Hello I have a MySQL 4.0.3 server with SSL option. I know that the SSL option is runnish coz when I do show variables...i am getting the value for ssl to be true :) I am writing a C app to connect to the MySQL server to do some jobs. I am using the mysql_real_connect() function to connect. The

result returned from query 'show fields from .....'

Hello It seems that an extra column has been added to the column information returned from the query] show fields from `dbname`.`tablename` the column is called collation and gives some extra information. Can somebody tell the exact version of MySQL from which this extra information was added.

Re: Bug in RIGHT OUTER JOIN?

Harald Fuchs <[EMAIL PROTECTED]> wrote: > Either I misunderstand what a RIGHT OUTER JOIN does, or MySQL has a bug. > Consider the following example: > [skip] > > This looks somewhat like the cartesian product of t3 with (t1 left > join t2). I would expect t3 left join (t1 left join t2). > Th

Re: ft_boolean_default='AND'

"electroteque" <[EMAIL PROTECTED]> wrote: > hi guys , i was wondering if this variable , is available for 4.0.12 ? we > tried to make it work but mysql would not start , if this is still not > available , what are the best ways for me to try and format a search say for > instance currently if i sea

RE: Is this an inefficient query?

Actually, the query I originally sent is probably OK...it is this query that may be causing the problem (I have left the PHP code intact.) $qin = "SELECT COUNT(cdr.ani) AS qtyin, SUM(cdr.calldur/60) AS minin "; $qin .= "FROM tblCDR cdr LEFT OUTER JOIN CDRFilter e "; $qin .= "ON cdr.dialedno =

Is this an inefficient query?

I am having some frustrations with a group of queries on one table in my database. Queries to other tables seem to proceed smoothly enough. This group of queries (6 in total) is called from a PHP page for a report, there are millions of records. Here is an example of one of the queries... SELECT

Re: Problems installing DBD::mysql for My SQL 4

> I believe the package you are looking for is > > zlib-devel > > The latest version from redhat is available at > http://updates.redhat.com/8.0/en/os/i386/zlib-devel-1.1.4-8.8x.i386.rpm > > Thanks, > Ryan Yagatich > > ,_, > \ Ryan Yagatich

ft_boolean_default='AND'

hi guys , i was wondering if this variable , is available for 4.0.12 ? we tried to make it work but mysql would not start , if this is still not available , what are the best ways for me to try and format a search say for instance currently if i search for two words "something1 something2" "someth

Database/table size

Is it possible to limit the size of a dbase or table? --- Keith Schuster Schuster & Company LLC ph:704-799-2438 fx:704-799-0779 iChat/AIM:FSHSales WWW.FlagShipHosting.com WWW.Schusterandcompany.com WWW.Vsheet.net -- MySQL General

Re: MySQL 4.0.12 proftpd 1.2.8

> Jun 02 08:07:17 mod_sql/4.10[1108]: message: 'Unknown column 'password' in > 'field list'' > > mysql> SELECT * FROM users WHERE userid = "test" > -> ; > ++-+--+--+-+--+---+- ---+-+---+--+-

AW: MySQL 4.0.12 proftpd 1.2.8

The select statement references a column password but the table definition/result of the select contains the column passwd!(you selected password not passwd) > -Ursprungliche Nachricht- > Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Gesendet: Montag, 2. Juni 2003 14:19 > An: [EMAIL

MySQL 4.0.12 proftpd 1.2.8

I have created two tables in mysql for users, and groups, but when I try to log into the ftp server I get this error: backend module 'mod_sql_mysql/4.03' Jun 02 08:07:13 mod_sql/4.10[1108]: backend api'mod_sql_api_v1' Jun 02 08:07:13 mod_sql/4.10[1108]: >>> sql_getconf Jun 02 08:07:13 mod_sql

Re: QUESTION ABOUT DATA AND INDEX FILE DIRECTORIES

Ares Liu <[EMAIL PROTECTED]> wrote: > > Under windows XP, mysql-4.0.12, when I create a table with special data and index > directories as follow: > > USE DATABASE test; > > CREAT TABLE IF NOT EXISTS test_table ( Vola INT NOT NULL, PRIMARY KEY (Vola)) > DATA DIRECTORY="D:/mySQLDBs/test/d

Re: Signal 11 on replicated MySQL Slave (4.0.13-standard)

Joel Rowbottom <[EMAIL PROTECTED]> wrote: > >Description: > MySQL crashes out with signal 11 when replication has been set up as > a slave. > >How-To-Repeat: > Follow instructions for replicated slave, then simply log out. If you > started mysqld (even if in nohup or

Re: ALTER TABLE

"Lilian" <[EMAIL PROTECTED]> wrote: > I have tested that function > > ALTER TABLE table_name_here AUTO_INCREMENT = 1000; > > on version 4.0.12 and it's not working. > (table TYPE=InnoDB) > > in 3.23.54 that is OK > > does anybody know what's wrong here? Option AUTO_INCREMENT works only on MyI

Re: ALTER TABLE

Hi! I have now updated the manual to reflect this restriction on InnoDB tables: " You cannot set the first AUTO_INCREMENT column value in InnoDB with CREATE TABLE ... AUTO_INCREMENT=... (or ALTER TABLE ...). To set the value insert a dummy row with a value one less, and delete that dummy row. "

Re: Connecting WO 5.2.1 to MySQL 4.0.13 on Windows 2000?

Hi! Most probably the drivers will be fine placing the jar file under c:\jdk_dir\jre\lib\ext This way there should be no classpath problem Adding JDK_HOME and JAVA_HOME variables to your environment should help also As for the drivers, both should work, just fine =) On Sunday 01 June 2003 19:15

advanced statement

Hello, I was wondering if the following could be done with an advanced sql-statement in MySQL 3.23: I have 5 tables with the following columns: id, name, phonenumber I need to check for duplicate phonenumbers in the 5 tables, that is if the same phonenumber exists in 3 tables or more. I've tried

SELECT query with OUTER JOIN - problem

Hi, I have two tables, one is containing data about courses and the second one is containing data about course start date. Is it possible to list all courses with one query which should also return earliest scheduled start dates for courses (which are in the second table). I tried something like t

UTF 8

Hi, I have a 4.1 alpha running and need to write Greece and german chars in it. Where I have to configurate UTF8? Thanks Stefan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

AW: How to run a script? Newbie alert..

Use "source " from the mysql command line Start mysql in the bin directory, switch to the db in use via "use " and run the command "source " Or read the manual section "3.6 Using mysql in Batch Mode" Cheers > -Ursprungliche Nachricht- > Von: Terry Riley [mailto:[EMAIL PROTECTED] > Gesend

How to run a script? Newbie alert..

I've not been at this MySQL stuff too long, so bear with me.. (4.0.13 running on Windows XP/Apache). Most of my work has been in Windows, and almost always with a GUI, so that when presented with the instruction to 'run mysql_fix_privilege_tables' script, I am totally clueless as to how to go a

Re: Maximum table size

If your os permits, mysql can handle file sizes up to terabytes. You don't need to spawn your tables. But you have to be careful when creating your myisam tables. If you don't specify your table size limit with the max_rows option when creating table mysql will create a table with 4G file size

Re: Maximum table size

And the manual says : . http://www.mysql.com/doc/en/Table_size.html Jerry - Original Message - From: "Mark Vollmann" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, June 02, 2003 9:39 AM Subject: Maximum table size > Hello > > As i understand it mysql maintains a file fo

Maximum table size

Hello As i understand it mysql maintains a file for every table created. Does it mean that the filesystem restricts the maximum size of a given table or do i have the option to make table data spawn more than on file like in oracle? Thanks in advance Mark Vollmann Mit freundlichen Grüßen, Mar

Re: SELECTing last occurences from a table

> select > substring_index(max(concat(lpad(day,4,'0'),'|',name,'|',id,'|',price)),' > |',1) + 0 as day, > > substring_index(substring_index(max(concat(lpad(day,4,'0'),'|',name,'|', > id,'|',price)),'|',2),'|',-1) as name, > > substring_index(substring_index(max(concat(lpad(day,4,'0'),'|',name,'

Re: mysql/innodb and the 2GB limit

On Monday 02 June 2003 04:32 am, Kieran Kelleher wrote: > What platform and hardware spec are you using? Linux (2.4.19 with the rmap vm) on Intel x86 (32 bit) with 3GB of memory. Mysql won't start if I set the InnoDB buffer above 2048MB. > > -Original Message- > From: Per Andreas Buer

Re: my first select

SELECT thankyou, thankyou FROM thankyou.thankyou WHERE thankyou = thankyou. It's nice to end the weekend and go to bed with one small success! Though my persistence is unending. ;-) I added ORDER BY lastName on the end, et viola! Thanks and goodnight! Ted On Monday, June 2, 2003, at 03:26 AM, P

RE: my first select

peopleID should match: SELECT lastname, model FROM people, machines WHERE machines.peopleID = people.peopleID; -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 2. júna 2003 9:19 To: [EMAIL PROTECTED] Subject: my first select I made a small DB of people and mach

my first select

I made a small DB of people and machines, where one person can have more than one machine, each machine can be assigned to only one person. people | machines, one-to-many. I have a primary key ID field in each table (peopleID, machineID) and in the machines table I have the peopleID, the foreig

Re: ALTER TABLE

Is 'id' indexed? AUTO_INCREMENT fields must be to work correctly. Try this: ALTER TABLE users ADD INDEX idx_id (id), AUTO_INCREMENT=1000; Quite honestly, your ID field should probably be the primary key, so: ALTER TABLE users MODIFY id INT(9) UNSIGNED NOT NULL PRIMARY KEY AUTO_INC

Re: QUESTION ABOUT DATA AND INDEX FILE DIRECTORIES

I use MySQL AB released win32 binary package. i don't know if it used --skip-symlink option. And after I added an entry skip-symlink=false in my.cnf, I can't start mysqld unfortunately. -Ares On 02 Jun 2003 14:15 CST you wrote: > >From the Manual: > By using DATA DIRECTORY="directory" or INDEX

Fwd: Encoding problem (JDBC, mysql)

Dear All, I have fixed the problem by my self. I just specify the character encoding as follows jdbc:mysql://myserver:3306/mydatabase?useUnicode=true&characterEncoding=UTF8 Thanks for your time. Best Regards, Srinivas. Mailing-List: contact [EMAIL PROTECTED]; run by ezmlm

Re: ALTER TABLE

I have check http://www.mysql.com/doc/en/ALTER_TABLE_problems.html but no solution for my problem. I have table_name 'users' (TYPE=InnoDB) with one of field id id int(9) unsigned NOT NULL auto_increment, when I update last insert id to 1000 , mysql 3 add next data automatically with 1001, 100

Encoding problem (JDBC, mysql)

Dear All, I am facing encoding problem with JDBC, mysql.  I can't insert/select Big5 text with JDBC connection. After I insert Big5 text, it becomes question marks () in the database. Before I insert Big5 text to mysql db, I am converting web browser post data from "8859_1" to Big5 en

Re: QUESTION ABOUT DATA AND INDEX FILE DIRECTORIES

>From the Manual: By using DATA DIRECTORY="directory" or INDEX DIRECTORY="directory" you can specify where the storage engine should put it's table and index files. Note that the directory should be a full path to the directory (not relative path). This only works for MyISAM tables in MySQL 4.0, wh

QUESTION ABOUT DATA AND INDEX FILE DIRECTORIES

HI, ALL Under windows XP, mysql-4.0.12, when I create a table with special data and index directories as follow: USE DATABASE test; CREAT TABLE IF NOT EXISTS test_table ( Vola INT NOT NULL, PRIMARY KEY (Vola)) DATA DIRECTORY="D:/mySQLDBs/test/data" INDEX DIRECTORY="D:/mySQLDBs/t

ALTER TABLE

Hi, I have tested that function ALTER TABLE table_name_here AUTO_INCREMENT = 1000; on version 4.0.12 and it's not working. (table TYPE=InnoDB) in 3.23.54 that is OK does anybody know what's wrong here? regards, lilian -- MySQL General Mailing List For list archives: http://lists.mysql.com/m

MYSQL Documentation

Hello Mysql List members, I am about to create some documents which I feel are not "so" complete documented until now. It's not a lot right now. I ceate a table comparison chart and a MySQL error code listing (in text format) which you could use to lookup Client and Server errors. Table or OS

RE: SELECTing last occurences from a table

It is possible if you make the number of digits in day all the same by using something like lpad. The secret is to tie all of the values you want together with something like CONCAT and making sure that the resulting string sorts in the order you want with its alphabetic sort sequence. Then MAX gi

confusion clearing up

Ok, list friends... I think I get it. My tables are ALREADY populated except for a Foreign Key column. What I think I "get" is that there is no way that the DB can possibly know or be told which row from the master table to insert/correspond (Foreign Key) to which row(s) in the slave ("many")

Re: becoming unconfused

I appreciate this and I have read it several times, the problem is it ain't easy to find a practical example, one with real data. That would I could figure out what "symbol" was. In fact what I am doing now is trying to build a small DB so I can learn these things --the books and I've got lot

Re: Problems installing DBD::mysql for My SQL 4

I believe the package you are looking for is zlib-devel The latest version from redhat is available at http://updates.redhat.com/8.0/en/os/i386/zlib-devel-1.1.4-8.8x.i386.rpm Thanks, Ryan Yagatich ,_, \ Ryan Yagatich [EMAIL

Re: swapping data

Why do you need to do that? If all that matters is which column the data is, use ALTER TABLE to rename them. Edward Dudlik Becoming Digital www.becomingdigital.com - Original Message - From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, 01 June, 2003 22:18 Subject: swapping

Re: becoming unconfused

Thanks, so is this correct, do I run this on table1? table1 table2 studentID -->PK classID -->PK student_name class_name studentID (foreign key) [CONSTRAINT symbol] FOREIGN KEY (studentID) REFERENCES table2 (st

RE: mysql/innodb and the 2GB limit

What platform and hardware spec are you using? -Original Message- From: Per Andreas Buer [mailto:[EMAIL PROTECTED] Sent: Friday, May 30, 2003 1:48 PM To: [EMAIL PROTECTED] Subject: mysql/innodb and the 2GB limit Hi. Lately, I've been banging against the glibc 2GB malloc limit - what a

Re: Inserting data?

Hi Ted, I believe that there is no easy right wrong answer here. Your question is to general to be ale to answer it correctly. The correct table format depends STRONGLY on how you want to use your data and which SELECT requests you will use. It might make sense to put all data in 1 table in ca

swapping data

how can I swap the data between to columns in the same table? Ted -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: SELECTing last occurences from a table

This would return only the most recently updated rows, excluding, from the poster's example, the onion prices from Day 1. Edward Dudlik Becoming Digital www.becomingdigital.com - Original Message - From: "Nils Valentin" <[EMAIL PROTECTED]> To: "Mateusz" <[EMAIL PROTECTED]>; <[EMAIL PROTE

Re: SELECTing last occurences from a table

It seems to me that you have two options: 1) Insert the price for each item every day and use a SELECT similar to that which I posted. 2) Use different tables for each food if you don't like (1) Your request, while easy on the surface, is not so easy when the dates differ and you aren't using a s

Re: SELECTing last occurences from a table

I believe you are at minimum talking about a subselect command here. I am just about to get the idea what you really want. You want to request all updated prices f.e. to show a pricelist with the newest prices. I guess thats to high for me to reach right now - but definitely interesting ;-) Be

Re: becoming unconfused

Check out the InnoDB reference in the MySQL manual. http://www.mysql.com/doc/en/InnoDB.html Here's the section Foreign Key Constraints http://www.mysql.com/doc/en/InnoDB_foreign_key_constraints.html Good luck. Edward Dudlik Becoming Digital www.becomingdigital.com - Original Message -

Fulltext indexing/searching of Unicode fields

Hello! I'm building a database that will have tables containing UTF-8-encoded text, and I want to use full-text indexing and searching for these fields. The aim would be that I should be able to index the UTF-8 text, and then search it accent-insensitively - that is, a search query for "cliche" s

Re: SELECTing last occurences from a table

In this case you would need to add a timestamp and check for the latest timestamp. This price should be taken for your query. Something like SELECT * FROM food WHERE timestamp(MAX); Thats my guess - anybody please correct me if I talk rubbish here Best regards Nils Valentin Tokyo/Japan 2003

Re: Query problem

Hi everybody, I hope ASAFP stands for something like AS Soon AS Feasable Possible ;-) We are not going to swear are we ? Best regards Nils Valentin 2003年 6月 2日 月曜日 07:30、Sparky Kopetzky さんは書きました: > I have a view I need to create from several tables where I'm looking up one > value from a tabl

Re: becoming unconfused

I just came from the bookstore where I perused "Mastering MySQL 4". Specifically, I wanted to know how to specify a Foreign Key. After a thorough, albeit short lived search, and reading every page the index on "Foreign Key" pointed to, I deduced that all one needs do is put the blasted field

Problems installing DBD::mysql for My SQL 4

I know this isn't the perl list but I'm thinking that some one out there has installed MySQL 4 on Red Hat 8. I couldn't upgrade from MySQL 3. I tried to uninstall MySQL 3 but I had too many dependency errors. I keep trying to install the necessary packages but I have a problem with the DBD::mysql m

Re: Find out what version I am using?

At 22:52 -0400 5/31/03, Mehrdad Ziaei wrote: That will give you version of mysql client you're running, That seems to have been what the original question was. For version of mysql server, after successful connection to mysql, use status command. mysql> status Or telnet to port 3306 of server run

RE: Update query with substring

You can't have two tables in the UPDATE query, at least not in v3.x of MySQL. I'm not sure about version 4. That's why it's complaining about table2. I think the SUBSTRING_INDEX should be OK. You may have to split your query into a series of queries. There is some guidance in the MySQL manual. Jo

Re: SELECTing last occurences from a table

> SELECT * FROM myTable ORDER BY COLUMN_WHICH_CONTAINS_INSERTED_DATE ASC LIMIT > 1; > COLUMN_WHICH_CONTAINS_INSERTED_DATE is a column which contains the date that > the record was inserted This would only select one row (the most recent). I need a set of rows, one for _each_ type of food (one and

Re: Query problem

Hi, Sounds like you will need to use subqueries which is available at MySQL 4.1 and above .. See: http://www.mysql.com/doc/en/Nutshell_4.1_features.html Hope this helps. Gurhan On Sun, 2003-06-01 at 18:30, Sparky Kopetzky wrote: > I have a view I need to create from several tables where I'm lookin

Not A Newbie to Application Development

Greetings, Want to submit a patch to mysql.h as I am porting an app which needs to be able to access Mysql servers and clients. Environment is a hybrid (not totally win32api, not totally Posix and not totally Linux but useable with all of those file systems) Msys/Mingw (http://www.min

Re: SELECTing last occurences from a table

SELECT * FROM myTable ORDER BY COLUMN_WHICH_CONTAINS_INSERTED_DATE ASC LIMIT 1; COLUMN_WHICH_CONTAINS_INSERTED_DATE is a column which contains the date that the record was inserted Hth, Martin - Original Message - From: "Mateusz" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, Jun

Re: SELECTing last occurences from a table

That'd be the solution, but unfortunately i gave You incorrect example (too little rows): the problem is I don't have a constant number of foods. For example the latest price of tomatoes could be from day 20 but the last price of potatoes might be from day 19, and for onions from day 1. I need sing

Re: Server configuration denies access to data source

You need to create the user and grant permissions try (username=teva): INSERT INTO user (Host,User,Password) VALUES ('%', 'teva', PASSWORD('your_password')); and finally add access to the database INSERT INTO db (Host,Db,User) VALUES('%','NameOfDatabase','teva'); Hope this helps, - Original Me

Re: Moving to version 4.1

Robert Mark Bram wrote: Howdy all! I now know that I was running 3.23.55 and that I need 4.1 for Unicode support. I am running Windows XP Pro and in my "add or remove programs" utility, I see "MySQL ODBC 3.51 Driver" and "MySQL Servers and Clients 3.23.55". If I use Windows "add or remove progra

Re: Inserting data?

> The way I was taught, in my limited education, was simply to have, say, > the people_id also appear in table2 as a Foreign Key, that tis would > serve to relate the tables. Now I've been advised that the way to do > this is NOT like that, but to have a third, linking, table In my opinion, you'v

Server configuration denies access to data source

I'm trying to use mysql with java, I create a short piece of code to make a conection but when the class run it sends an exception: Server configuration denies access to data source I can use the database using mysql client without problem. Could someone help me, or ask me where i find the listins

Re: SELECTing last occurences from a table

Do you have daily prices for a set number number of foods? If so, try SELECT * FROM food LIMIT n,-1; where n is the number of items. There's probably a better way to do it in SQL, I just don't know how. If you are using PHP, that's another story. Edward Dudlik Becoming Digital www.becomin

Query problem

I have a view I need to create from several tables where I'm looking up one value from a table and need to add it to the Select stmt like this: SELECT sex (SELECT yes_no_meaning FROM yes_no WHERE yes_no_id = bite.bite_animal_sex_id), type (SELECT type_meaning FROM type WHERE type_id

Re: Advice on improving our current method

> Unfortunately though i think we need to be able to make the changes in > something we can see which is why we are using mysqlcc. What is the final use for the database? Is it for a website, an application, or just mere data storage? If it's either of the first two, an admin form can be built i

RE: Insert query

Use 'char' instead of 'varchar' and INDEX the fields that you will be using in the WHERE clause of your SELECTS. -Original Message- From: Ulterior [mailto:[EMAIL PROTECTED] Sent: Saturday, May 31, 2003 10:35 AM To: [EMAIL PROTECTED] Subject: Re: Insert query sow what would you suggest, J

RE: updating database query

On 01-Jun-2003 Grant Cooper wrote: > I'm trying to update an email field. Our company has changed from a .com > to > a .ca. I wrote a php script to make the changes but I was wondering if I > could do this from the command line. Its a text field and I would like to > replace. [EMAIL PROTECTED] to

Re: Problems with Connector/J

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Gilmar Caiado wrote: > Hi! > > I've been experiencing some problems regarding connection mysql/java. I'm > using a connector 3.0.8, and linux debian. I have also copied the connector > to JAVA_HOME/jre/lib/ext directory. > > Here's is the code: > > im

Problems with Connector/J

Hi! I've been experiencing some problems regarding connection mysql/java. I'm using a connector 3.0.8, and linux debian. I have also copied the connector to JAVA_HOME/jre/lib/ext directory. Here's is the code: import java.sql.*; public class DBTeste{ public static void main(String[] args)

Re: Inserting data?

I'd be glad to share.. you mean what the db is supposed to be? Ok, there are 3 tables: table1 = people, people_id = primary key table2 = machines, machines_id = primary key One person can have many machines, one machine can only be assigned to one person. The way I was taught, in my limited educ

SELECTing last occurences from a table

Hi! I couldn't find anything in archives, maybe I search for wrong phrase. I'm running MySQL v.3.23.49 (if it's not possible under this version, I may upgrade it). What I need to accomplish is to find only last occurence of all possible items from given column. Supposing: idnameday

updating database query

I'm trying to update an email field. Our company has changed from a .com to a .ca. I wrote a php script to make the changes but I was wondering if I could do this from the command line. Its a text field and I would like to replace. [EMAIL PROTECTED] to [EMAIL PROTECTED] Can someone help me out plea

Connecting WO 5.2.1 to MySQL 4.0.13 on Windows 2000?

Getting EO Modeler in WO 5.2.1 to connect to MySQL 4.0.12 on Windows 2000 is evading us somehow and giving us a dreaded connection error. It works fine on OS X I know it is something to do with Classpaths and the fact that EO Modeler uses a different JDBC connector than WO. 1) If someone out

Re: Advice on improving our current method

Perhaps I'm being a bit slow today. I don't see (or maybe I haven't found the magic syntax) that would allow a table index to handle the re-sequencing of information. On Sun, 1 Jun 2003 14:09:15 -0400, Martin Gainty wrote: > let the DB manage the sequencing before and after Make Chart # an Inde

Re: Advice on improving our current method

let the DB manage the sequencing before and after Make Chart # an Index Martin - Original Message - From: "Don Read" <[EMAIL PROTECTED]> To: "Daniel Crompton" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Sunday, June 01, 2003 1:54 PM Subject: RE: Advice on improving our current method

Re: Advice on improving our current method

OK, here's a lengthy answer: I don't use MySQLCC, so I'm assuming that it has a way that you can enter and run SQL statements. Say our top 10 songs are: mysql [test]> SELECT * FROM musicchart ORDER BY chartnumber LIMIT 10; +-+--++

Re: Advice on improving our current method

> SET @rank:=5; > > UPDATE music SET chart=0 WHERE [EMAIL PROTECTED]; > UPDATE music SET chart=chart+1 WHERE chart<@rank; > Thanks Don Unfortunately though i think we need to be able to make the changes in something we can see which is why we are using mysqlcc. With mysqlcc any of us can simply

RE: Advice on improving our current method

On 01-Jun-2003 Daniel Crompton wrote: > > If for example we move song number 5 up to number 1, we then have to > manually change the > ' Chart Number' of all the ones below it, i.e. changing the old number > 1 to a number 2, > number 2 to a number 3, number 4 to a number 5 etc. > > Ideally

Re: Advice on improving our current method

Hi, I'm not to familiar with MySQL, but as far as I can seem, you might want to look at programming. I.e a program in C++ or Perl, or Visual Basic. Anthony -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Update query with substring

At 11:26 +0200 5/30/03, Davy Obdam wrote: Hello people, I am trying to run this query: UPDATE table1, table2 SET table1.periode = table.periode WHERE table1.id = 3 AND SUBSTRING_INDEX( table1.name, '.', - 1 ) = table2.name But i keep getting the same error message You have an error in your SQ

Rating rows only with FULLTEXT

Hi I would like to use a FULLTEXT index to rate each row without comparison to the other rows in the dataset. I am retrieving documents from remote databases and would like to limit the responses from the database before an external script rates them against each other. I was wondering if so

Advice on improving our current method

Can anyone advise how we should improve this method of updating our database. We have a Music chart it is a table with 3 columns Chart Number (ie, 1,2,3,4,5,6,7,8,9,10..) Artist (Artists Name) Title (Title of Song) Each week we login using mysql control center to make changes to the chart pos

Re: Using varchar or something else?

On Sun, 1 Jun 2003 14:53:54 +0100, Dan wrote: > I have used varchar for ALL my fields as this is the only one i know. > > Alot of my rows just contain image link text ie. > > /image/logoa.gif > > Is using varchar overkill for these fields?. Would i be better using > something else? It depends

RE: MYSQL DB PROBLEM

Hi This is a bug. You can fix it by adding a line to my.cnf. Can't remember what but search the archives as it has appeared before. Peter -Original Message- From: Nick Arnett [mailto:[EMAIL PROTECTED] Sent: 01 June 2003 15:54 To: [EMAIL PROTECTED] Subject: RE: MYSQL DB PROBLEM > -O

Re: Insert query

> If he only has a few million records, why would this be more efficient? Because MEDIUMINT takes up less space in the database. Edward Dudlik Becoming Digital www.becomingdigital.com - Original Message - From: "Nick Arnett" <[EMAIL PROTECTED]> To: "Andrew Braithwaite" <[EMAIL PROTECTED

Re: Inserting data?

You need a constraint on the data to be inserted into the second table. Care to share what that is supposed to be? Edward Dudlik Becoming Digital www.becomingdigital.com - Original Message - From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, 01 June, 2003 03:17 Subject: Ins

RE: MYSQL DB PROBLEM

> -Original Message- > From: Adam Murphy [mailto:[EMAIL PROTECTED] > Sent: Saturday, May 31, 2003 10:48 PM > To: [EMAIL PROTECTED] > Subject: MYSQL DB PROBLEM > > > > I am trying to insert a table ibf_posts > > into a localhost database using the MYSQL control center every > time i try to i

RE: Insert query

> -Original Message- > From: Andrew Braithwaite [mailto:[EMAIL PROTECTED] > Sent: Saturday, May 31, 2003 12:05 PM > To: 'Ulterior'; [EMAIL PROTECTED] > Subject: RE: Insert query > > > Hi, > > I would use mediumint rather than int for the ID column (int has > support for > up to 2.1 Bill

Re: Using varchar or something else?

i.e.16 chars, make it 30 to be sure "it" = CHAR - Original Message - From: "Jerry" <[EMAIL PROTECTED]> To: "Dan" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Sunday, June 01, 2003 3:10 PM Subject: Re: Using varchar or something else? > I'd advise char due to the over head and spac

Re: Using varchar or something else?

I'd advise char due to the over head and space usage of varchar. if its something like your example i.e.16 chars, make it 30 to be sure. Jerry ps. + pps. = http://www.mysql.com/doc/en/Column_types.html - Original Message - From: "Dan" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: S

Re: Practical samples for table types

Hi Everybody, our server was down for 8 hours. I applogize in case anybody did try to access the table chart. Its up and running and of course I would appreciate any feedback. http://www.knowd.co.jp/staff/nils/mysql-ttf.html Best regards Nils Valentin Tokyo/Japan 2003年 5月 30日 金曜日 17:34、Nils

Re: MySQL Errno: 2013

Hi Kevin, I dont think its the switch. I would like to try the following variables: net_read_timeout 60 net_write_timeout 60 long_query_time 30 Please let me know if this was of any help. Best regards NIls Valentin Tokyo/Japan 2003年 5月 30日 金曜日 23:33、Kevin A. Miller さんは書きました: > Nils: > > th

  1   2   >