Re: phpMyadmin

Quick one... is this program just for Linux? I think not. As long as you have mysql and apache/php running it can run on any unix os i think. Take out the word 'unix' and you'll be right. If you can get a PHP environment (doesn't necessarily require Apache to be the web server) and MySQL,

mysql update

i want to update every row in the mysql table that matches a part of each row in it. ie. for example if a table contains the following rows : Pid:21577 PPid: 21174 Uid:501 Gid:501 i want to change the first row to Pid:30209 similarly for any row plz advice me

Find entry with max date.

Hi I have a relational db with a couple of tables holding things like comments and complaints and actions. In the main table, I have the contact details. What I'd like to do is to query the db with a php app and to display the entries in the result set with a last action/comment/contact done

table crash problem

hi listers i've upgraded my mysql env from 3.23.53 to 4.0.13. also, i changed os from m$ to rh 7.3. what did not change was h/ware. since the upgrade, i often get the error message table is marked as crashed and should be repaired. (errno 145). i then run myisamcheck --auto-repair to fix the

RE: Rows into Columns

In the following statement replace STRING by concat(group_concat(payment ORDER BY paymentid SEPARATOR '|'),'|') SELECT invoiceid, if ( STRING IS NOT NULL, substring(STRING, 1, if( locate('|',STRING) 0, locate('|',STRING)-1,

Re: Fw: check

Alex82 [EMAIL PROTECTED] wrote: so what can i do to make a column accetp only certain values...there are any other solutions? Check values in your application. - Original Message - From: Egor Egorov [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, July 14, 2003 1:58 PM

RE: !!! NEWBIW !!! how to start? !!! NEWBIE !!!

Best method to start, restart, the server is with the service command: service mysql start service mysql stop service mysql restart Of course, this assumes that you have it configured in the init.d, which is something mysql installation normally does itself (at least with the rpm). These

Re: mysql update

Prem Soman [EMAIL PROTECTED] wrote: i want to update every row in the mysql table that matches a part of each row in it. ie. for example if a table contains the following rows : Pid:21577 PPid: 21174 Uid:501 Gid:501 i want to change the first row to

Re: MySQL vs. PostgreSQL -- speed test

Hi! First of all, if I decide to benchmark MySQL vs. PostgreSQL with my application, PostgreSQL will probably be faster. That does not mean that MySQL is generally slower or that I *want* it to look slower. That just means 1) I have no experience in tuning MySQL 2) My application was built

RE: Find entry with max date.

SELECT c.name, c.surname, substring( if ( max(concat(cont.date,'Conctact ',cont.date) max(concat(compl.date,'Complaint ',compl.date), if (max(concat(cont.date,'Conctact ',cont.date) max(concat(act.date,' Action

RE: Extracting data from SQL Server *.DB file

I've read through the archives and spent hours on Google but I still can't figure this out. I must extract the data from a SQL Server *.DB file. Viewing the raw text, I can see that there views, grants, etc. at the top of the file, but this is a process that could not possible be done by hand.

FW: Pulling large Microsoft SQL files into MySQL

-Original Message- From: Rudolf Bekker Sent: Monday, 14 July 2003 14:13 To: MySQL MailList ([EMAIL PROTECTED]) Subject: Pulling large Microsoft SQL files into MySQL Importance: High The MySQL manual mentions that one could specify the column and value separators and the end of file

Re: alter table 'table' auto_increment = # doesn't work

Ittay, ALTER TABLE ... AUTO_INCREMENT=... does not work with InnoDB type tables. http://www.innodb.com/ibman.html#InnoDB_restrictions For an AUTO_INCREMENT column one must always define a key to the table, and that key must contain just the auto-increment column. InnoDB does not support

Re: Weird Temp File Issue

Feesch ListMaster [EMAIL PROTECTED] wrote: I'm not sure if this is a bug report, possibly a security issue. I have started getting Too many connections error, but not at times when I would expect the database to be busy. The worrying thing is that the temp drive gets completely filled (about

Getting columns into a single row

Hi guys, I need some help with this. I have the following 3 tables. +--+---+ | uid | name | +--+---+ | 100 | sue | | 102 | harry | | 104 | louis | | 107 | sam | | 110 | james | | 111 | mark | | 112 | rita | +--+---+ +--+---+ | gid | name

working with linked Tables

Database mysql running on localhost Error The additional Features for working with linked Tables have been deactivated. To find out why click here. - Database mysql running on localhost PMA Database ... not OK[ Documentation ] General relation features Disabled response from phpmyadmin

auto number primary key - restarting

Hi, is there an SQL command for making a primary key (auto number key) to start numbering from beginning after deleting all the records from the table. thanks

The sales TEAM

The sales team are down ? I'm trying to order MySQL-PRO licences and the team not return my emails... i trying with [EMAIL PROTECTED] and [EMAIL PROTECTED] gerardo is out ? this is my contact in MySQL AB : Tnks in advance, mysql,innodb,sales,money,help...

Another Newbie Question

I am finally able to enter data and am going through the Tutorial in section 3 of the mySQL manual. It suggests that I create a .txt file from which to load date into a table. Where does mySQL look for data to load in the default installation? I thought it would be in the data folder under

Re: Fw: check

Use InnoDB tables and a foreign key. Alex82 wrote: so what can i do to make a column accetp only certain values...there are any other solutions? - Original Message - From: Egor Egorov [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, July 14, 2003 1:58 PM Subject: Re: check Alex82

Re: auto number primary key - restarting

delete all records by this command: TRUNCATE TABLE `mytable`; - Original Message - From: Miroslav I. [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, July 15, 2003 8:10 AM Subject: auto number primary key - restarting Hi, is there an SQL command for making a primary key (auto

RE: FileMaker Pro

I'm actually working on a large Filemaker to MySQL conversion project right now. I don't need live data at this stage, so I've got a script running that reads in a FilePro-generated CSV file each night. It works fine, though early on we had a problem with our old version of Filepro not exporting

Managing big tables

Hello, i've got a little problem, we're using mysql with two big tables (one has 90 Mio. Rows (60 Gb on HD), the other contains nearly 200.000.000 (130 Gb on HD). Now we want to delete some rows from these tables to free diskspace. It seems that MySQL frees the harddisk-space which was used by

RE: Another Newbie Question

George, Try in the folder with the same name as your database, under the data folder. Andy -Original Message- From: Degan, George E, JR, MGSVC [mailto:[EMAIL PROTECTED] Sent: 15 July 2003 13:30 To: [EMAIL PROTECTED] Subject: Another Newbie Question I am finally able to enter

Re: auto number primary key - restarting

Miroslav I. [EMAIL PROTECTED] wrote: is there an SQL command for making a primary key (auto number key) to start numbering from beginning after deleting all the records from the table. For MyISAM tables you can use ALTER TABLE: http://www.mysql.com/doc/en/ALTER_TABLE.html -- For

RE: Managing big tables

Hi The only thing I can say is that if you optimise the table often there is less work for it to do so you table will be left locked for shorter time. I have not looked in to this but if you use the RAID option. I don't know if splitting the table up you could just work on one bit at a time??

RE: auto number primary key - restarting

Please check the history on this list. There are numerous answers to this problem. Cheers /rudy -Original Message- From: Miroslav I. [mailto:[EMAIL PROTECTED] Sent: dinsdag 15 juli 2003 14:10 To: [EMAIL PROTECTED] Subject: auto number primary key - restarting Hi, is there an SQL

Re: Managing big tables

http://www.mysql.com/doc/en/Data_size.html [EMAIL PROTECTED] wrote: Hello, i've got a little problem, we're using mysql with two big tables (one has 90 Mio. Rows (60 Gb on HD), the other contains nearly 200.000.000 (130 Gb on HD). Now we want to delete some rows from these tables to free

Re: auto number primary key - restarting

Hello Miroslav, Tuesday, July 15, 2003, 3:10:10 PM, you wrote: Easiest way to do what you want is to make this: 1.SHOW CREATE TABLE TableName and copy SQL 2. DROP TABLE TableName 3. CREATE TABLE - with SQL copied in 1. MI Hi, MI is there an SQL command for making a primary key (auto number

RE: Managing big tables

I do not really think that optimizing (in your case compressing, thus cleaning up free space) is much faster with fixed record length on LARGE tables. Why? When optimizing the table the DB rebuilds the file record for record to a temporary file and then moves it back to the original file (well,

RE: Managing big tables

Always take care what you want to achieve! And consider the circumstances. Yes, adding a lot of indexes makes queries faster. But makes inserts/deletes/updates slower. Alex's problem is NOT that his/her queries takes too long, the problem is that optimize takes too long. Which is something

Re: auto number primary key - restarting

Easiest way to do what you want is to make this: 1.SHOW CREATE TABLE TableName and copy SQL 2. DROP TABLE TableName 3. CREATE TABLE - with SQL copied in 1. Actually, the easiest way to do this (assuming *all* records have been deleted) is: UPDATE table_name SET auto_increment_field = 0;

What about auto number primary key - wrapping?

Has anyone had a table that has lived long enough to wrap the auto incrementing number...? i.e. the complete byte span and back to 0x32. I'm just wondering if mySql will fill in the deleted ID's that don't exist, or if it just halts... -- MySQL General Mailing List For list archives:

RE: auto number primary key - restarting

truncate table_name does both in one statement. And even optimizes the table (frees up unused disk space). However take care that you cannot rollback this DDL. Cheers /rudy -Original Message- From: Chris Boget [mailto:[EMAIL PROTECTED] Sent: dinsdag 15 juli 2003 15:29 To:

Re: auto number primary key - restarting

truncate table_name does both in one statement. And even optimizes the table (frees up unused disk space). However take care that you cannot rollback this DDL. Wow. Learn something new every day! :p Thanks for the tip, Rudy! Chris -- MySQL General Mailing List For list archives:

RE: What about auto number primary key - wrapping?

Set the autoincrement column to the max value or the given data type (via alter table), insert a record and see what happens... Cheers /rudy -Original Message- From: TheMechE [mailto:[EMAIL PROTECTED] Sent: dinsdag 15 juli 2003 15:40 To: [EMAIL PROTECTED] Subject: What about auto number

How to import XML into MySQL?

Sorry. I missed this discussion previously. Now I need the answer. Figures. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MySQL vs. PostgreSQL -- speed test

MySQL has posted a very interesting comparison on their website. It appears to be a reasonably fair evaluation. PostgreSQL was faster than MySQL in some areas and MySQL was faster than PostgreSQL in most areas. For speed with all of that functionality, I'd be more inclined to look at DB2

Re: Managing big tables

Sorry rudy, but I can not understand what you try to say! I can only say that if you follow the link below and read the explanations on that page and also follow the related links you can find answers to Alex's problems. [EMAIL PROTECTED] wrote: Always take care what you want to achieve! And

Re: Creating more than 32 keys?

If you have to create that many keys, you may want to consider changing your data structure. You additions and updates to the database would get pretty slow if that many indexes have to be updated. What I usually do is change my columns to rows and add an additional qualifier column to indicate

replication

I set up a replication with MySQL 4.0.13, it works very fine, but unfortunately only for several hours (between 10 and 30 hours) Has someone an idea why the replication stopps? Thanks, Moritz 030714 18:02:07 Slave I/O thread: connected to master '[EMAIL PROTECTED]:3306', replication

RE: Managing big tables

Ok, sorry, I focused too much on the optimization of the table. Because this is an isolated problem and most what is written on the page does not apply to this issues. This is like saying When the sun shines, there is always a shadow which is generally true but not on June,21, 12:00pm on the

Re:Managing big tables

Thanks for your efforts, and in rudys last mail he confirms what i have feared, the io-overhead for reading the extremely longer rows most probably causes these longer query-times. I think we will have to redesign our table-structure, because we're already working on a (hardware-)raid, so the

RE: replication

on the slave, run show slave status at the mysql prompt. if there is an error, one of the fileds will tell u what it is -Original Message- From: Moritz Steiner [mailto:[EMAIL PROTECTED] Sent: 15 July 2003 16:41 To: [EMAIL PROTECTED] Subject: replication I set up a replication with

More duhh! questions

I am attempting to create a temporary table to do a complex query and I get an error: error 1044: Access denied for user: '@localhost' to database 'shopsample' what can I do to keep this from happening? I am using the production version of mySQL 4.0.13 in windows 2000. Here is the query:

Replication setup

I have set up a master and slave whose versions are (using 'show = variables') S: 3.23.47-nt, M: 3.23.47-nt-log. They were both installed = from the same distribution zip. I can't get replication going even = though the server and client status seem ok (slave running and file and = position

WG: wait_timeout in my.cnf

I set a lot of variables in the my.cnf file, all variables are set (I checked it with show variables) except of wait_timeout. If I set the option in MySQL with option wait_status=xxx it works. Does anybody know why this could happen? Thanks, Moritz -- MySQL General Mailing List For list

genereal query log

I want to turn on and off the general query log from time to time. Is there a possibility to do this without changing the my.cnf file and restarting the server. I thought for example set option log=ON Thanks, Moritz

CF MySQL

Hi All I've had a quick scoot about and could see anything about cold fusion and mysql is it possible to use this combination successfully if at all? Thanks Andrew -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

MySQLDump

Hi, I am new to MySQL. I wonder if someone could tell me if I can run MySQLDump on a database while a few users are still connected to it. If yes, is it clever enough to backup the transaction log and use it to restore the database to the nearest state to the before the dump? Many thanks.

RE: CF MySQL

Thanks Curtis, interesting indeed... presumably MySQL is in a different location as CF runs off NT4 or is MySQL a win version? The reason I am asking is because a solution has been presented to me in CF and MS SQL which I think will restrict future development and wondered whether a conversion to

RE: MySQLDump

The connections will still write to one or two tables. Mainly stock prices from a price server. Hence, not so bother if any prices arrive after the dump starts are not captured. I would like to know if mysqldump will fail to run if the tables are not locked? Cheers. Gilbert -Original

One Big Data Base or Many Smaller Ones

Hello, I am creating an on-line course and would like to know if it will make a difference in the way I set up my database(s). Option 1 : Create one large Database for the course Here I would prefix the tables with their functions, ie. reg_ quizzes_ forum_ etc. Option 2 : Create a

DATE COMPARISON

Hi: I was wondering if there is a date function to get the older date between two dates?. Or smething that indicates me that one date is older than the other one. I know that I have the function YEAR,MONTH,DAY and I can use them, but I don't know if exists a function that can do the same.

Single Record Locking - Permanent?

Is it possible to lock single records for all but a certain set of users, permanently? The intention is to make old items permanently unchangeable by anyone but managers. Thanks, Dan Ullom TechCentric 314-991-2594 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: DATE COMPARISON

Miguel - You can compare dates directly using and - no need for a special function. Dates are older when they are less than other dates. Cheers. Jeff On Tuesday, July 15, 2003, at 09:36 AM, Miguel Perez wrote: Hi: I was wondering if there is a date function to get the older date between

RE: Pulling large Microsoft SQL files into MySQL

LOAD DATA INFILE data.txt INTO TABLE table_name FIELDS TERMINATED BY '|' ENCLOSED BY '' LINES TERMINATED BY '\n'; You can find more on this at: http://www.mysql.com/doc/en/LOAD_DATA.html -Original Message- From: Rudolf Bekker [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 15, 2003 2:43

Re: Single Record Locking - Permanent?

2 methods I can think of: 1) Move the records into a different table, and set permissions accordingly (allow updates on for managers on that table) 2) Control authentication and access in your program. -Cameron Wilhelm On Tuesday, July 15, 2003, at 11:03 AM, Dan Ullom wrote: Is it possible

RE: CF MySQL

Contents are Direct Alliance Corporation CONFIDENTIAL - Andrew, I have setup all the environments you are talking about. CF with MS SQL is much easier to setup and get going than PHP and mysql. However I have see twice the speed and stability with my applications that are written in PHP

Frequent Table Corruption - Please Help

Hi everyone, Since we upgraded to MySQL 4.0.13 from 3.23, we have been getting table corruption often. It happens about twice per week (with about 500 queries per second average). I have even set up a cron to run mysqlcheck every hour to try to do some damage control. The biggest problem is

Calendar SELECT with repeating occurance

I¹m developing a calendar, with a view by month and list view, for a client and I would like to add the option for them to add an event and select if it is to repeat, i.e. Annually, monthly, weekly. As I see it now I can do one of two things (possibly more?). Add a predetermined amount of records

Re: DATE COMPARISON

This would do it if you are just comparing two dates: $max_date = ($date1$date2?$date1:$date2); It's just using the one line form of an if statement. Note that the function is incorrect if they date are equal. On Tuesday, July 15, 2003, at 12:36 PM, Miguel Perez wrote: I was wondering if there

table protection

Is there any command that we can use to view the protection on the tables??. Is there any way that we can convert read only tables to read write?. Please ehlp thank u kamran -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

table protection

Is there any command that we can use to view the protection on the tables??. Is there any way that we can convert read only tables to read write?. Please ehlp thank u kamran -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

RE: Pulling large Microsoft SQL files into MySQL

Hi: Or you can use a DTS to transfer the info to MySQL Greetings From: Ralph Guzman [EMAIL PROTECTED] To: 'Rudolf Bekker' [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: RE: Pulling large Microsoft SQL files into MySQL Date: Tue, 15 Jul 2003 10:32:03 -0700 LOAD DATA INFILE data.txt INTO TABLE

4.0.13 or 4.0.14

I'm getting ready to upgrade a server from 4.0.12 and was wondering if anyone knew the time frame for 4.0.14, or if I should just go with .13 for now. -- Michael Conlen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

Best practice column type for storing decimal currency amounts?

Is there an accepted best practice on whether to store decimal currency amounts (e.g. dollars and cents) in MySQL decimal column types? Certainly, the most straightforward way is to use decimal columns. But it appears that such values are stored as ASCII strings, which would be inefficient

How can I display images from a mySQL Database in a web page?

I have created a BLOB field to store images. Is there any way to embed them within HTML with something like: image start: jpeg /image Thanks in advance, Dan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

Re: Frequent Table Corruption - Please Help

Richard, you are running a Red Hat kernel 2.4.18? Kernels 2.4.20 seem to be much more reliable. Best regards, Heikki Tuuri Innobase Oy http://www.innodb.com Transactions, foreign keys, and a hot backup tool for MySQL Order MySQL technical support from https://order.mysql.com/ - Original

Re: CF MySQL

I am currently running ColdFusion MX on my Linux Servers access both MySQL from different Linux Servers and MS SQL from a MS2000 WS. ColdFusion and MySQL are both available and run on both Win Linux machines. I also have PHP installed on Linux, but have never attempted to learn fully

Re: 4.0.13 or 4.0.14

Michael, - Original Message - From: Michael Conlen [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Tuesday, July 15, 2003 10:36 PM Subject: 4.0.13 or 4.0.14 I'm getting ready to upgrade a server from 4.0.12 and was wondering if anyone knew the time frame for 4.0.14, or if

RE: What about auto number primary key - wrapping?

I have a copy of 3.23.56 running on one of my machines and it does NOT wrap auto_increment columns when the upper limit is reached. I haven't tested it with any newer versions, though I doubt they'd be any different. If this is a concern for you then I would suggest using a bigger column type

Re: Frequent Table Corruption - Please Help

Thanks for the tip. I'll see about upgrading, but it won't be a small task. Any reason why 2.4.18 problems wouldn't have effected MySQL 3.23? I'm trying to search for a solution that does not involve upgrading kernels on 20 machines that are in production use right now. Thanks again! Richard

Re: 4.0.13 or 4.0.14

Hi! On Jul 15, Michael Conlen wrote: I'm getting ready to upgrade a server from 4.0.12 and was wondering if anyone knew the time frame for 4.0.14, or if I should just go with .13 for now. 4.0.14 release it a matter of days. Regards, Sergei -- __ ___ ___ __ / |/ /_ __/

RE: One Big Data Base or Many Smaller Ones

Hi Charla, Generally if the tables will be related to each other then you want to keep them in the same database. as an example, you would want to link quiz scores to the individual students registered in your class. It is a little easier to do table joins and such when there is only one

Re: Frequent Table Corruption - Please Help

Richard, - Original Message - From: Richard Gabriel [EMAIL PROTECTED] To: Heikki Tuuri [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, July 15, 2003 10:53 PM Subject: Re: Frequent Table Corruption - Please Help Thanks for the tip. I'll see about upgrading, but it won't be a small

Malformed Packet

Using the C API I'm getting this on some of my queries, however if I run the query on a different mysql connection, it seems to run fine: Errmsg: Malformed packet Errno: 2027 Any Ideas? -Ryan.

Re: innodb file won't shrink

Alvaro, - Original Message - From: Alvaro Avello [EMAIL PROTECTED] To: Heikki Tuuri [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, July 15, 2003 1:13 AM Subject: Re: innodb file won't shrink -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 There 's any

Re: innodb file won't shrink

Walt, - Original Message - From: walt [EMAIL PROTECTED] To: Heikki Tuuri [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Monday, July 14, 2003 11:56 PM Subject: Re: innodb file won't shrink Heikki Tuuri wrote: On September 15th, 2003 you will be able to put every InnoDB table into

Lost connection to MySQL server during query

Hello all, After changing RAM and the ethernet card of my DB server, the problem of getting frequent: Database error (error code 102) Could not connect to database server (Lost connection to MySQL server during query) Still occurs ;/ I've tried to eliminate all factors (like multiple servers,

Re: Frequent Table Corruption - Please Help

Thank you very much for the help. I will schedule the upgrade and see if helps. I have 2 other machines running 2.4.18 without problems, but they also do not run the volume that the problematic machine has and they do not have RAID. Take care. Richard Gabriel Director of Technology, CoreSense

Re: CF MySQL

there is a windows version of mysql. However, I agree with this post as to have it all run on Linux would be cool. There is also a Linux version of Cold Fusion. Curtis On Tuesday 15 July 2003 14:15, Cory Lamle wrote: Contents are Direct Alliance Corporation CONFIDENTIAL - Andrew, I

Join optimization

Hi folks, I¹m wondering what (in general) causes a join to use temporary tables and filesorts... More specifically, what can I tune to avoid it? I can give more info about a specific situation if anyone¹s interested. All the docs say is that you are likely to get a ³Using temporary² if you sort

Re: innodb file won't shrink

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Sorry HeikkiCan you give me a few steps to obtain that...? Thanks a lot. Alvaro Avello. Heikki Tuuri wrote: |Alvaro, | |- Original Message - |From: Alvaro Avello [EMAIL PROTECTED] |To: Heikki Tuuri [EMAIL PROTECTED] |Cc: [EMAIL

Re: innodb file won't shrink

Alvaro, - Original Message - From: Alvaro Avello [EMAIL PROTECTED] To: Heikki Tuuri [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Tuesday, July 15, 2003 11:38 PM Subject: Re: innodb file won't shrink -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Sorry HeikkiCan you give me a

RE: Complex select statement

Still having a problem with this. Still have one last thing that isn't working. This is MySQL 4.0.13. UPDATE table_tmp,table2_daily SET table_tmp.period_count = table_tmp.count - table2.count WHERE table_tmp.id = table2.id AND MAX(table2.timestamp); This is giving me: ERROR : Invalid

Re: Complex select statement

As far as I know, MAX only returns the greatest row, so what you really want at the end is WHERE table_tmp.id=table2.id AND table2.timestamp=MAX(table2.timestamp) ~MJI Roy Walker wrote: Still having a problem with this. Still have one last thing that isn't working. This is MySQL 4.0.13.

Re: How can I display images from a mySQL Database in a web page?

THis is kinda offtopic.. it depends on what frontend you are using to access mysql (php,java,perl,etc) .. You just need to pull the binary data and output it with the correct http headers and it will show up in a browser.. search the list for more info. www.php4.com has an example using php..

Re: How can I display images from a mySQL Database in a web page?

I think there is a way to insert binary image data in your html, but is there any particular reason you need to do that? First you would need to encode it in some ascii equivalent (check w3c.org, I think) ...and it would increase the size of your html page while rendering the browser's image

Re: How can I display images from a mySQL Database in a web page?

I think there is a way to insert binary image data in your html, but is there any particular reason you need to do that? First you would need to encode it in some ascii equivalent (check w3c.org, I think) ...and it would increase the size of your html page while rendering the browser's image

Re: How can I display images from a mySQL Database in a web page?

I think there is a way to insert binary image data in your html, but is there any particular reason you need to do that? Yes, my client's server is running with particularly restrictive PHP safe mode settings and has informed me that dynamic images are a /must have/. :: bangs head against

Re: How can I display images from a mySQL Database in a web page?

On 15 Jul 2003 at 18:31, Dan Anderson wrote: I think there is a way to insert binary image data in your html, but is there any particular reason you need to do that? Yes, my client's server is running with particularly restrictive PHP safe mode settings and has informed me that dynamic

errors with source file

The file mysqlqui-win32-static-1.7.5-2.zip with file size of 37k downloaded from http://www.mysql.com/downloads/gui-mysqlgui.html is corrupt. Is there a mirror with a compiled windows xp compatible version somewhere? Pres. Cliff Murphy Hyperactive Media Group Static is for the laundry, Flash is

passing multiple variables

I have a catalogue built and it passes a variable to the sample page that shows the larger pic on the page. But I want to pass a second variable to the page as well, can that be done. This variable is the simple line of text that talks about the product. This page does not access the database

Re: MATCH AGAINST () ('XXX' IN BOOLEAN MODE) SYNTEX ERROR

I have MySQL version 3.23 on Linux 8.0 . I am trying to do a full text search IN BOOLEAN MODE and I get an error. If I remove the IN BOOLEAN MODE option my query runs fine . Does it mean I have to upgrade to 4.0 to use this Search mode? Can somebody please confirm ? -- MySQL General

select, join, order assistance - simple

I have 2 tables similar to T1 --- ID | initial | T2 -- initial | full_name | I want output based on the T1.ID row which has a given ID=' X ' (If ID = 7 then pretend initial = initial3, as example) The first or

Re: MATCH AGAINST () ('XXX' IN BOOLEAN MODE) SYNTEX ERROR

At 19:28 -0400 7/15/03, Francis Van-Lare wrote: I have MySQL version 3.23 on Linux 8.0 . I am trying to do a full text search IN BOOLEAN MODE and I get an error. If I remove the IN BOOLEAN MODE option my query runs fine . Does it mean I have to upgrade to 4.0 to use this Search mode? Can

RE: Complex select statement

Alright, I am almost there, got one problem now. There are multiple entries for each id in table2. I need only the records with the newest timestamp for each id. Want to do something like this, but doesn't work: INSERT INTO table_tmp (id,count_new,count_old,date) SELECT table1.id,

Re: errors with source file

red fraggle wrote: The file mysqlqui-win32-static-1.7.5-2.zip with file size of 37k downloaded from http://www.mysql.com/downloads/gui-mysqlgui.html is corrupt. Is there a mirror with a compiled windows xp compatible version somewhere? Pres. Cliff Murphy Hyperactive Media Group Static is for

Foreign Keys

When I type: Show keys from [tablename]; I do not see foreign keys listed there and I cannot seem to find any command that will list foreign keys. Can anyone help? Also, I notice Innodb tables only store one file unlike MyISAM which stores 3. Are Innodb tables any slower than MyISAM since they

  1   2   >