MySQL Database Forum

I need a MySQL select statement as part of a PHP script. I want to find rows where a certain column either starts with or equals a user-supplied string. The string will be 1 or more characters in length. The sending page allows the user to choose which search criteria he wants, so this (and many other) pieces of the select statement may or...

Hi all, During executing SELECT query, MySQL creates disk temporary table. After the tabe exceeds 4GB I get table is full error. How can I change settings to remove 4 GB bareer from disk tmp tables? It is easy to set in phisical MyISAM table by increase MAX_ROWS. I have ext3 filesystem

What object do I use for a blob that must be >64 k ?-Ike

I need to do a one line insert to a MySQL database from a Linux Shell. I have a program that collects data and I can do a one-line shell call after the data-update is finished. On this line I would like to send the data from the program to a MySQL database. The problem is that the program has all data in variables so I would like to do...

How to I get the results from selecting a float coloum to display as such? xxxx.xx Just as you would any monitary value? Tried TO_CHAR(float, "00.00") TIA

Hi All, I am new to mySQL and I have 2 questions: 1. Everytime I login to mySQL: machine 21:06:32 ~ $ mysql -u root -p Enter password: It asks me for password. Since I didn't set a password for root when I installed mySQL, I can just hit Enter and I will be login. This seems

Hello, Trying to get help with this situation. I have installed PHPBB, PHP (4X) and MySQL 4.1. This is how I started out. 1. Installed MYSQL - ran setup - did FULL install - and entered in new password when requested. MYSQL gave the green light when computer rebooted. Created new database with CREATE DATABASE XXX; Also installed ODBC...

hi, i am using the perl DBI. -- how can i make load_file read a blob. it treats the file contents as a string rather than text/blob. -- is there an ENV or mysql var to tell the engine where to find files you want to load? mysql looks in ~ by default and i know i can use a full path but it is reather long and cumbersome.

hi, the version of erwin i have does not support mysql. is there a gpl-type case tool for mysql? thanks again, peter

hi, is there a way to dump just data to a file similar to the way "load data infile" reads data? tia, peter

Gentlemen, I still don't understand why... But the only way MySql works is if you set rstTable.CursorLocation = adUseClient. (if it's not set it won't ..Update, load a grid, doesn't know .RecordCount etc.) Is there any way you can set the a global default to adUseClient?

My organization currently has 2 different MySQL database servers. We are in the process of moving the databases from Server A to Server B and have Server B be our primary database server. I've done some research on the web and believe the best option is to use the "mysqldump" command to remotely recreate Server A's databases on to Server B....

I'm selecting fields from History table (Oelsls) including Description from Inventory table (Invt) where Cust_# = value of PBV_lngCustomerNumber. However I get an error: 'Unkown Table Oelsls'!! When it's there! Anything wrong with what I'm doing? "Select Oelsls.Part_ID, Invt.Desc1, Oelsls.Last_Sale, Oelsls.Order_#, Oelsls.Ltd_Units,...

Hi guys, I have a table currently set up like this: <- -> video ------ video_id

I am trying to insert some textual data belonging to an HTML page into a table column with 'TEXT' as data type mysql's maual _/manual.html#String_types tell you, you may insert up to (2^16 - 1), that is 65535 characters, but I am getting errors when I try to insert a column larger than 236 characters. Initially I thought it might be...

I am using: mysql Ver 12.22 Distrib 4.0.18, for sun-solaris2.9 (sparc) And I do this: mysql> create table test (a timestamp default null, b timestamp default null); Query OK, 0 rows affected (0.03 sec) mysql> desc test;

I installed mysql-4.1.7 on solaris 8. I can start it using mysqld_safe. But when I tried to shutdown using 'mysqladmin -p shutdown' and type in the root password, it gave: mysqladmin -p shutdown Enter password: mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'oracle'@'localhost' (using password: YES)'

I am converting an ms access query to work with mysql, however I cant seem to find a replacement for IsNumeric() Anyone help? Thanks

Hi, I need to retrived a specific row from a query, these these specific row number is the result of another query. Is it possible to do that in one query with a subquery (mysql 4.1.x)? Here is how I try (that gave me a syntax error.): SELECT a FROM t1 WHERE a = 1 ORDER BY LIMIT (SELECT b FROM t2 WHERE c = 2),1;

Hello, I have a database with three text fields in it , each with a fulltext index. If I do a fulltext query against one of the fields, the explain says it will use the index. If I do a query on more than one of the fulltext fields, it doesn't use any of the indexes. What am I missing here? TIA, Jay

Hello, I am having a problem writing an SQL query. The tables I have are History id transaction_id state_id 1 1 1

Hi I have a large database with text strings. What is the quickest way to replace each with a throughout the database fields while leaving everything else intact? ex .... I'm a monkey ...

I have been trying to find information on the business potential for providing PHP/MySQL services in US and Europe. Would appreciate if somebody can help me on this.

Not sure if this is the right place, but I think that MySQL owns MaxDB. I have MaxDB (SAPDB) installed as part of a packaged SAP installation. I know that I can install a web-based query tool, but it seems like I have to re-install the entire DB, which I cannot do. Is there a way to install the web based tool without a complete re-install?

I have a table that stores a list of zip codes using a varchar column type, and I need to perform some string prefix pattern matching search. Let's say that I have the columns: 94000-1235 94001 94100 If I run a pattern matching search for the string "940", then I should get the top two rows of data back. If I run a pattern matching...