MySQL Database Forum

Ok I upgraded to 4.1.12 Max so I could start using InnoDb and be able to do multiple table deletes among others. I have an app system that I need to delete info from a few tables when we delete a bogus app or a client we cant place. Here is the query I wrote that finally worked DELETE applications,client_rates,avail_apps,req_docs,uplo...

Hello, I am using the LOAD DATA INFILE command to import a text file into mysql. However, there is much more text in the file than needed in my tables. How can I make a selection from the text line. For example position 5 - 10 in field A, position 20-23 in field B, etc Regards,

Hi, I would like to transpose a table in mysql. I have looked on the web for a while but nothing seems to fit the bill, so I just want to clarify if I have to write some php or if I can use a SQL query (preferred). What I would like to do is to use the values in a row as column headings during output, so that I can enter different sets of...

Am I correct in assuming to use MySQL you actually need a computer connected to a server?

Hello, I am currently upgrading a database of products to include pictures to be displayed online. I would like to know whether it would be best to store the pictures themselves in a database as a BLOB or whether it would be best to simply store the filename. What are the pros and cons? Thank you,

I used to have an older version of Mysql (4.0) that I started by starting Winmysqladmin. Now I replaced this with the newest version: 4.1.12 and that doesn't have Winmysqladmin. After some experimentation I found out that MYSQLD.EXE seems to start mysql. I can then use phpMyAdmin. However, my own application still does not work (I can log...

select count(*) from syslog.SystemEvents where message like '%postfix/smtp[%' and (message like '%@carcass.us>%' or message like '%@deadghost.com>%' or message like '%@phatho.com>%'); Above query returns error. Have no idea how to count something like this and the manual is not helping. I'm thinking select it into a temp table and then...

i have macosx tiger 10.4.1 i installed mysql 4.1.12 and when i view my phpinfo() i see it is still using the 3.23.49 client. how do i get to use the 4.1.12 client? /|\

Hello, I am using the LOAD DATA INFILE command to import a textfile into mysql. However, there is much moor text in the file the needed in my tables. How can I make a selection from the text line. For example position 5 - 10 in field a, position 20-23 in field b, etc Regards,

Hello, All! Example. I have a table with information about payments (id, amount, pay_date, customer_id). Can I select two sums for two different date ranges, grouped by 'customer_id' (for each customer) in one query? -- With best regards, Gregory Konev. E-mail: voyage@ml.net.ua

I have two tables, WIDGETS and VERSIONS. The WIDGETS table has descriptive information about the widgets while the VERSIONS table contains IDs relating to different iterations of those widgets over the years. The idea is that from any widget in the database you can look forward and backward to see different versions of the widget through...

Hello, I'm running into some inconsistent query caching. Has anyone run into this and has a solution or better place to look? All of my queries don't violate the caching terms (no Now() or other mysql reserve words), so it is unclear what is happening. Even when I do simple lookups, I'll get the query caching after the first lookup,...

Hello, I have a CREATE TABLE statement which runs fine under PostgreSQL. However, when I run the statement under MySQL I get the following error message: ERROR 1071 (42000): Specified key was too long; max key length is 1024 bytes I would like to know whether there is some way of bypassing this MySQL-specific restriction on key size,...

Can you join two tables across different servers in mySQL, or am I dreaming of Oracle? -- Posted using the http://www.dbforumz.com interface, at author's request Articles individually checked for conformance to usenet standards Topic URL: http://www.dbforumz.com/mySQL-Join-servers-ftopict225285.html Visit Topic URL to contact author (reg....

Hi there, I was hoping someone could help me out here. I have a table which has columns seq and price. Some sample rows are... seq price 1 34 1 35 2 25

Hi, I am not quite sure where to place this question, by Powerbuilder or MySQL as I guess it is a communication glitch between the two platforms. I am trying to convert a Powerbuilder application from Sybase SQLA to MySQL. I have created a new database, exported the Sybase data and imported it into MySQL. The original datawindows still...

Microsoft Office Outlook, Build 11.0.6353 Message-Id: <2.20020816120021.01316aXme.Coon@comcast.net> Hello, We sent you an email a while ago, because you now qualify for a much lower rate based on the biggest rate drop in years. You can now get $327,000 for as little as $617 a month! Bad credit? Doesn't matter, ^low rates are fixed no...

I am trying to connect to a server hosting a MySQL database called "BusinessMind" using the Query Browser. I keep getting the following message listed below. Do I have to somehow register my client machine with MySQL in order to make a connection across a network? MySQL Query Brower Error: MySQL Error Number 1045

We're planning an SQL-based solution, possibly mySQL for Windows or Linux. But some in the organization might favor Oracle. Are there any particular pitfalls of using mySQL instead of Oracle? I'm a novice when it comes to evaluting different SQL solutions. We expect to have maximum 10 million records for our largest table, and perhaps...

hello, suppose a hypothetical table called 'table' with one field called 'field' of an arbitrary type. the query select count(*) from table where field='value' group by field produces no rows when run under the latest mysql. without "group by" it

Perche' non riesco ad inserire immagini opiu' grandi di 1Mb in un campo LONGBLOB? Ha forse il limite di 1Mb il campo LONGBLOB? Se si, posso modificare tale limite? Per le immagini inferiori a 1Mb e' tutto ok funziona perfettamente. Grazie a tutti, ciao.

Hello, Consider the following PostgreSQL or Oracle SQL DDL code: CREATE TABLE fooTable ( foo INTEGER, PRIMARY KEY (foo) ); CREATE TABLE barTable (

hi all, is there sombody who can helpme witht he following, i am ''pretty new'' to php and am looking for a script to show images randomly at a 10/ 15 seconds interval. is there anybody who can help me with this or does know where to find a good template script for this? thanks in advance, rene

Hi, I have a simple master/slave replication environment that is working smoothly with one exception. If I restart the master server the Master Log File is incremented by one (e.g. the original master log is named data-bin.000001 and the new master log is named data-bin.000002) the slave server never notices that the Master Log File and...

Can some tell me of a syntax to search for a text string that might be in any column in a table. Something simular to: SELECT * FROM mycontact WHERE * LIKE 'string'; Thanks in advance for any suggestions or comments. -- L. James -- --------------------------------