backslash and Update

I have 290 records in the database with backslashes. I want to remove the backslashes. Why the query below doesn't remove backslashes? update name set first_name = REPLACE(first_name,'','') where first_name like '%%';

How to start mysql on linux?

I have sudo access to Linux box. How to start mysql 4.0.14. TH

Reset root password to mysql?

How to reset mysql password to mysql? mysql -u root ERROR 1045 (0): Access denied for user: '[EMAIL PROTECTED]' (Using password: NO)

Re: Reset root password to mysql?

Frome Street, Adelaide 5000 Australia +61 8 8408 4273 - Work +61 417 268 665 - Mobile +61 8 8408 4259 - Fax -Original Message- From: Jerry Swanson [mailto:[EMAIL PROTECTED] Sent: Wednesday, 23 November 2005 12:11 PM To: mysql@lists.mysql.com Subject: Reset root password to mysql

Re: SSH tunnel for Mysql

Both Linux computers. On 11/21/05, Gleb Paharenko [EMAIL PROTECTED] wrote: Hello. You have not specified what operating system you're using. MySQL manual has some notes for Windows: http://dev.mysql.com/doc/refman/5.0/en/windows-and-ssh.html Jerry Swanson wrote: How to create

SSH tunnel for Mysql

How to create ssh tunnel for Mysql? TH

How to write this query?

How to write the query? table1: order (order can have more than 1 item) table2: item (has order_id). table3: item_status (has item_status_id and item_id) table4: status (has item_status_id). Status can be 'complete', 'pending'. I need to get all orders that have ONLY completed items. Examples: if

Re: How to write this query?

and c.item_status_id = d.item_status_id where d.status = 'completed' It isn´t tunned but I think that it works for that you want -Mensaje original- De: Jerry Swanson [mailto:[EMAIL PROTECTED] Enviado el: Jueves, 10 de Noviembre de 2005 06:23 a.m. Para: mysql@lists.mysql.com

Re: Delete all but the newest 100 records?

If you have auto_incremnt id in the table you can do the following: delete from table a where id start_id and id = end_id Or you can delete by timestamp. delete from table a where date between 'start_date' and 'end_date'. On 11/6/05, Brian Dunning [EMAIL PROTECTED] wrote: I'd like to delete

Differnce between fields of int type

What is the difference between these two fields? Both fields hold number 5, but for some query marked_id field gives result. marked_id | int(11) | | | 0 | id | int(11) | YES | | NULL | Where you can see difference between these fields? TH

float comparison?

Why when I do select from database and try to compare float field with float number, I have no results amount --- type float select * from price where amount = 3.45 // doesn't work select * from price where amount = '3.45' //doesn't work select * from price where amoun like '3.45' //work My

float size?

I have field in database type float. When I insert number like 12345.27 , number is inserted 12345.3 Why it happened?

Group by Month

I have query that pulls data between to dates. How to group the data by month? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

LIke

How to make this work? field like '%DATA_FORMAT(now(), '%m%d%y') %' -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Install Mysql 4 on Fedora Core 2

I want to install MySQL 4 on Fedora Core 2. Questions: #1. Do I need to uninstall MySQL 3 from the server first? #2. Where I can get source for MySQL 4? Thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

mysql: varchar and case sensitive

Column type is username varchar(100). When I do select from database: select * from user where username='John'; //returns one row select * from user where username='john'; //returns one row The records in the database has username 'John'. Why it isn't case sensitive? 'John and

View

Does Mysql 4 supports views? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: varchar(10) to decimal

decimal(6,2) On 5/18/05, Philippe Poelvoorde [EMAIL PROTECTED] wrote: Jerry Swanson wrote: I need to change format from varchar(10) to decimal. When I alter the table the data is trimmed. What I'm doing wrrong? TH ALTER TABLE your_table MODIFY your_column double NOT NULL

varchar(10) to decimal

I need to change format from varchar(10) to decimal. When I alter the table the data is trimmed. What I'm doing wrrong? TH -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

write query question

How to select 5 records(including username, first_name, last_name, contact) for each user in the database? table user( id, username, first_name, last_name ) contact( id id_user //id from user table name ) -- MySQL General Mailing List For

Re: write query question

I need 5 records per user. On 5/11/05, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Hi, try this, select username, first_name,last_name, name as contact from user,contact where user.id=contact.user_id order by username; Mathias Selon Jerry Swanson [EMAIL PROTECTED]: How to select

Re: write query question

query runs for 5 min... kill query id. On 12 May 2005 00:29:56 +0200, Harald Fuchs [EMAIL PROTECTED] wrote: In article [EMAIL PROTECTED], Eric Jensen [EMAIL PROTECTED] writes: So you want 5 contacts for every user? Try this: SELECT COUNT(c.id) AS count, u.username, u.first_name,

REPLACE function

I have field varchar(20) that stores phone numbers. Phone number can be in different format. So I need only digits from the field. How I can do such replacement? TH -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

update random date

How to update randomly field date of datetime? I need to update randomly on 300 records Thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Query question

I want to get everything from user than if record exist in admin so user has admin(administrator) in table user with user.id = admin.admin_id, so I need to get 'admin' first_name and last_name If there is no record in table admin with adin.user_id = user.id , than I need at least all records from

Fedora Core 2: upgrade mysql 3 to mysql 4

I want to upgrade mysql 3 to mysql 4. Operating System is Fedore Core 2. Is there any package dependency? How to remove mysql3 and install mysql 4? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: how to write this query?

:01:05 +, Jerry Swanson [EMAIL PROTECTED] wrote: I have two dates (start_date, end_date). Datediff() function returns difference in days. I need the difference but not including Satuday and Sunday. Any ideas? C:\Program Files\MySQL\MySQL Server 4.1\binmysql -utest -ptest test

how to write this query?

I have two dates (start_date, end_date). Datediff() function returns difference in days. I need the difference but not including Satuday and Sunday. Any ideas? TH -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

UNIX_TIMESTAMP function

How to select datetime using UNIX_TIMESTAMP excluding Saturday and Sunday? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Daily Incremental Backups on Mysql

Does binary logs are avaialbe in Mysql 4 or only in Mysql 5? Thanks On Thu, 10 Feb 2005 10:28:56 +1100, Daniel Kasak [EMAIL PROTECTED] wrote: Jerry Swanson wrote: Is it possible to do daily incremental backups on mysql? Thanks Yes. mysqldump will give you a starting point

Daily Incremental Backups on Mysql

Is it possible to do daily incremental backups on mysql? Thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Elegant way: select last record from table

I'm interesting to know what is the best way to select last inserted record. This can do it ORDER BY id desc limit 5 .. but .. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

mysql store queries?

Does mysql stores queries? If so where? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: select count

This is what I was looking for. Why the query is call cross-tab? TH On Thu, 13 Jan 2005 02:09:45 +, Ian Sales [EMAIL PROTECTED] wrote: Jerry Swanson wrote: | Field| Type | Null | Key | Default | Extra

Re: select count

What query suppose to be faster? Jan or Dave? Jan Solution: SELECT date, SUM(IF(CONCAT(status,id) LIKE 'received%',1,0)) as received, SUM(IF(CONCAT(status,id) LIKE 'send%',1,0)) as send, SUM(IF(CONCAT(status,id) LIKE 'cancelled%',1,0)) as cancelled FROM account GROUP BY date; On Wed, 12 Jan

Re: select count

Database Administrator Unimin Corporation - Spruce Pine Jerry Swanson [EMAIL PROTECTED] wrote on 01/13/2005 07:56:18 AM: What query suppose to be faster? Jan or Dave? Jan Solution: SELECT date, SUM(IF(CONCAT(status,id) LIKE 'received%',1,0)) as received, SUM(IF(CONCAT(status,id

subquery, returns more than one filed?

Can subquery return more than one column in Mysql 4.1.7? SELECT (select user.last_name, user.first_name from actor where user.id=6) as last_name, first_name (select count(*) from account where account.status = 'progress') as progress_count, ERROR 1241 (21000): Operand should contain 1

select count

| Field| Type | Null | Key | Default | Extra | +--+--+--+-+-++ | id | int(10)

Mysql upgrade problem 3.23 to 4.1

I upgraded mysql mysql-3.23.58-1 to mysql4.1 In mysql-3.23 ( I have this field) password | varbinary(45) | YES | | NULL | I inserted data into this field as password('pass'). I have php script that checks if login valid. mysql-3.23 and mysql-4.1 have identical

String function

I need to make query that adds numbers. The fields are varchar format so I have some value 12121 and some values 121212,121212. I think I need string replace function that replace comma. What function can do this? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To

How many rows?

This is my query select id, status from sale where user_id = 1 GROUP BY id; I need to know how many rows or how many entries this query returns. I tried to use count and sum. But the result is wrong. I want to be able to make select and know how many rows this query returns. Now, I use

MySQL logs and restore data

I deleted some data in mysql. Is it possible to restore the data. Maybe using MYSQL logs? Thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

MySQL logs and restore data

I deleted some data in mysql. Is it possible to restore the data. Maybe using MYSQL logs? Thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

ORDER by date: reverse order

I want to sort by date but the last date appears first. How to write such query? TH -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Redirect output to the file

I want to redirect output of the query to the file in tab delimited format. Can this be done? Thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

MySQL Control Center and Linux box connection

I have Linux box running Red Hat and 3.23. I install MySQL Contorl Center and trying connect to the mysql on Linux box. When I try to connect I receive the error message. ERROR: HOST 'ip address' is not allowed to connect to this MySQL server. What I'm doing wrong here? TH -- MySQL General

Re: mysql 3.23 store large data

How many characters can Longblob hold? What is the size of longblob? Why I don't need to specify the size (i.e varchar(200) )? On Wed, 27 Oct 2004 20:09:37 +0300, Gleb Paharenko [EMAIL PROTECTED] wrote: Hi. Use LONGBLOB. Jerry Swanson [EMAIL PROTECTED] wrote: What type I

mysql 3.23 store large data

What type I should use in MySQL 3.23.58 to store large data file? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

date type select

I have comlumn in mysql type datetime. I need to get the date in DATE format. select DATE(reg_date) as test from a1; It gives me an error. How to select date in different date format? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Delete data from more than one table

I can delete data for one table with no problem: delete from table; I need to delete data for more than one table. I tried to run this query: delete from account, survey; //But the query crashes. Any ideas how to delete data for more than one query. TH -- MySQL General Mailing List For list

Modify type

I have field date type of datetime. I need to modify to timestamp. If I alter the table and mofiy the field will this crash the data in the field. TH -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]