MySQL Database Forum

i have a column "path" with values eg. +---------------+ | path | +---------------+ |/path/path/path| +---------------+ |/path/path | +---------------+ |/path |

Hi all, I am inserting datatime value into mysql table, while select value its giving 0000-00-00 00:00:00 value. mysql> insert into dtest values('02-17-05 17:08:02'); Query OK, 1 row affected (0.00 sec) mysql> select * from dtest;

For instance, there is one column has values 'New', 'Maintenance', 'Renovation', 'Not Specified', and which options below is better in term of performance? option 1. set the column to tinyint unsigned not null, and store the value 1,2,3,4. The values 1,2,3,4 represent the values 'New', 'Maintenance', 'Renovation', 'Not Specified'...

Warning: Error while executing this query:CREATE TABLE "purchaseorder" ( "PurchaseOrderID" int(10) unsigned NOT NULL auto_increment, "PurchaseCost" double unsigned zerofill NOT NULL default '0000000000000000000000', "PurchaseDescription" varchar(255) character set latin1 collate latin1_bin NOT NULL default '', "PurchaseeBayReference"...

Before anyone cracks a quick joke... my question does not refer to same-sex marriage... I know how to create a join - correct me if I am wrong, but its something like the following: SELECT contacts.firstname,contacts.lastname,address.line_1 FROM contacts,address WHERE contacts.address_hash='$myhashkey' AND address.hash='$myhashkey';

Hi, I am using java to retrieve a resultset with "show table status" mysql command. I am having problem reading the and column. In the metadata object it is showing as VARCHAR but when I do getString() it is returning me the object string (e.g. "[B@1e3e7d2")and not the actual database value. I am using Mysql 4.1 and jdbc driver 3.1. I...

Can anybody tell me why I am getting rounding errors using the ROUND function. 3.7125 rounds to 3.70 when I use the following: TRUNCATE(ROUND(units_pay_amount * fees_amount, 2),2))) The correct value should be 3.71 I could round to the 3rd decimal place ROUND(X,3) and that would round it correctly to 3.71 but that would mean I would...

Hi, I hope this is the right place to post, but, I am having a problem with an UPDATE command and a LEFT JOIN, I am using something like: UPDATE table_a LEFT JOIN table_b ON table_a.field1=table_b.field1 SET table_b.field6='1' WHERE table_a.field2='1'; Something along those lines. Anyway, from what I can see on various web sites,...

Hi, I've recently installed MySql 5.0.2 on a WinXp box and am always getting the error "Error While Fetching Schema Table Status" every time I click on a schema in the Catalog. I can log on to the db fine, it always happens when I click on a schema.

Hello! I have a weird problem... The application I use issues this SQL from time to time: alter table t modify id int(6) unique not null auto_increment; The problem is that this SQL adds a key on id every time it is run! mysql> show keys;

Hello We are about to convert our authentication from plain text (passwd/shadow) to an mysql database to ease administration. Dows anyone know of a script that kan take the passwd and shadow file as input and create tables and database for mysql ? Tia, Rickard

I have a virtual dedicated server on GoDaddy which has Redhat, Apache, PHP, MySQL, and Plesk Reloaded installed. Plesk runs MySQL-Admin to administer databases. I have not problem logging in and setting up new domains, and php runs fine locally in each domains webspace, however, I have set up a database for one domain and cannot access it...

Hi, When I do a select with a limit I get always the same records. Usually this is the desidered effect. But now I want to do a random select. So every time I do a select I should get a different set of results. What is the best way to achieve this effect?

In Oracle there is a way to correct any mistakes in a query, by simply entering the edit command. And from there, a text editor is opened, to allow the corrections to be made to the query. This eleminates having to retype the whole query. Is this possible in MySQL?

I use the --all-databases switch to backup my entire database. Sometimes there's a need to restore individual databases or tables form the backup file. What command should I use for this? Thanks, Raffi

How can I convert a windows date stored in Mysql (ie 38397 for today) to something I can use in a where clause? Thnaks, Bart

Hi, I have setup a GigE LAN with 1 mysql server and another having the mysql client. the OS is slackware 10.1. the mysql is compiled from source and is ver 4.1.9. How do I measure throughput and latency between mysqlclient and server ? Thanks

Is there a way to recover a lost password in Mysql 4.1. I have seen many articles and howto's on how to kill the Mysql process and then restart using skip grant tables option. I am not trying to reset the password but rather recover it. Resetting the password to something else would cause a problem some of the underlying programs that rely...

I inadvertantly named a field "in" mysql> select * from guestbook; +----+-------+-------+-----------------+----------------+ | id | fname | lname | comments | in | +----+-------+-------+-----------------+----------------+ | 1 | Mick | White | Test 123 | 20050208000000 | | 2 | Ann | White | Hello World |...

Has anyone ever accomplished a mass update off all databases, tables and columns for collation? If I try to change the collation/character set for the mysql daemon it breaks all of our queries because they conflict with the swedish default that they have been created with. The problem is we have about 90 databases with hundreds of tables....

I have a table that has values of variables for certain entities. The columns of interest are targetID, variableID, and valueID. A row (1, 5, 9) means that target number 1 has a value of 9 for variable 5. Being denormalized, target number one will have many possible rows in this table, one for each variable for which it has a value. My...

Does anyone know how to GET (not search the filesystem yourself) the path to any database, as in, where on the filesystem it lives? Is it a query? Is it in a debug log? TIA The Bunny

i have a stored procedure consisting of several delete statements and i want to be able to return the "Query OK, 0 rows affected" such that the total number of rows deleted are summed up rather than returning the number of affected rows of the last statement. the number of rows deleted can be obtained through the ROW_COUNT() and i can add...

this is one way of creating a stored procedure in mysql: CREATE PROCEDURE some_procedure (IN value1, OUT value2) BEGIN SELECT ... INTO value2 FROM .... END// and if called from another procedure, i can access the variable this way:

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head> <title>HermineLINE</title> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> </head> <body bgcolor="#FFFFFF"> <p><span class="style11"><strong><font color="#FF0000" size="4" face="Arial, Helvetica, sans-serif">Is your women satisfied with...