We have just moved to a new web server where we are running mysql
version: 5.0.45
On the old machine, when we gave the following command:
update table1 set passwd = password('xx') where user_name=xx;
Here you're updating 'table1'...
and then gave the following command,
SELECT user_name
i have list where I would like make a select, this list look like this
id Properties Others
*
11 sss
22 sss
32 a etc...
42
52
61
72
82
91
This is actually a PHP issue and nothing to do with MySQL.
You're correct in that since you renamed the directory, the scripts can't
find their includes. Ideally, they should be using relative path names
and/or setting the include_path php.ini variable to avoid this.
The quick however, answer is
Hello i use this query:
select i.item_id
from orders o
INNER JOIN item i ON i.nr=i.nr
Should the line above not be
... ON i.nr = o.nr ?
INNER JOIN user_cart u ON u.nr=i.nr
where (i.count !=0 or i.count!=NULL) and i.isactive=1 and i.kolWo0
order by i.count DESC
LIMIT 5
It works
I have two datasets that I wish to relate together using the company name.
The problem is the same company may have a slightly different name in each
the two datasets.
What I want to do is for each company name in dataset A, find the 'nearest'
n matches to it in dataset B.
e.g. If I have 'Alkool
hi listers
we have a mysql based application, wherein phone numbers may be stored
and searched for. it is not the primary goal of this application to
handle phone numbers.
phone numbers usually are entered in a form like 099 999 99 99 or
099-999-99-99, or substings thereof. actually, the
Hi.
Using mySQL 4.1.22, I'd like to carry out an SQL query to find a
string containing acute vowels.
mytable:
- item1:
--- firstname: Antonio
--- lastname: Fernández
--- comments: he's from Spain
My SQL query:
--
SELECT id FROM mytable WHERE MATCH(firstname, lastname, comments)
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: 13 September 2007 15:32
To: mysql@lists.mysql.com
Subject: MySQL DateTime Source on CentOS 5
I'm running Apache/MySQL/PHP5 on a CentOS 5 server and have
started to get
some strange date and time
Christoph Boget wrote:
I did a search and couldn't find anything like what I'm looking for and
though I doubt something like this does exist, I figured I'd ask anyway. Is
there a client (not phpMyAdmin) that can connect to a server (that is
running MySQL) using SSH and connect to the database
what steps do you recommend to do the tables update on the production
database?
When I work on our site DB, I follow the following steps:
1. Trash the existing dev DB and replace with the current live version
2. Develop!
3. Dump all the tables I have changed (structure and/or data) using
I would like to import data from a utf8-coded comma seperated file. I
created my database with DEFAULT CHARACTER SET utf8 COLLATE
utf8_general_ci and I started my mysql-client with the
--default-character-set=utf8 option. Nevertheless, when I input primary
key fields, which differ only in one
-Original Message-
From: Jason Pruim [mailto:[EMAIL PROTECTED]
Sent: 09 August 2007 14:16
To: Gary Josack
Cc: mysql@lists.mysql.com
Subject: Re: Import file into MySQL Database..
On Aug 8, 2007, at 5:19 PM, Gary Josack wrote:
Try:
|load data local infile
-Original Message-
From: Clyde Lewis - DBA [mailto:[EMAIL PROTECTED]
Sent: 03 August 2007 16:55
To: MySQL List
Subject: Re: MySQL in read-only mode
The idea here is to perform this change without restarting the
server. Is that possible? I know that by updating the config file,
hi
i am experimenting with sql for getting lists of friends.
select friend.*
from user
left join link on user.id=link.id and user.id = $MYID
right join user friend on link.friend_id = friend.id
where user.name is null;
on my local windows machine running mysql 5 it works
-Original Message-
From: Baron Schwartz [mailto:[EMAIL PROTECTED]
Dan Nelson wrote:
In the last episode (Jun 18), Edward Kay said:
From: Dan Nelson [mailto:[EMAIL PROTECTED]
snip
At the moment, I have this and it works:
select * from contact_address
group
-Original Message-
From: Dan Nelson [mailto:[EMAIL PROTECTED]
Sent: 15 June 2007 19:24
To: Edward Kay
Cc: MySQL List
Subject: Re: Hiding columns used in GROUP BY and HAVING clauses
In the last episode (Jun 15), Edward Kay said:
I have a table of addresses. Each address
-Original Message-
From: Dan Nelson [mailto:[EMAIL PROTECTED]
Sent: 18 June 2007 15:11
snip
At the moment, I have this and it works:
select * from contact_address
group by primary_entity_id
having count(primary_entity_id) = 1
-Original Message-
From: Baron Schwartz [mailto:[EMAIL PROTECTED]
Sent: 18 June 2007 15:53
Sent: 18 June 2007 15:11
snip
At the moment, I have this and it works:
select * from contact_address
group by primary_entity_id
having
I have a table of addresses. Each address is associated with a primary
entity and a primary entity can have n different addresses. For each primary
entity, one address is marked as the main address.
I need a query to return all addresses that are the only address associated
with the primary
Check out http://www.sqlmanager.net/en/products/mysql
http://www.sqlmanager.net/en/products/mysql
AndrewMcHorney wrote:
Hello
I am looking for the tools that I would use to be able to do
administrative duties and to be able to create and update databases
(tables, indexes and
SELECT * FROM news WHERE display='yes' ORDER BY id desc limit 1
Think this would get the lastest article that is to be displayed
but how do I get the second one.
Just add an offset to the LIMIT clause:
SELECT * FROM news WHERE display='yes' ORDER BY id desc limit 1,1
Edward
--
MySQL
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: 22 May 2007 15:47
To: mysql@lists.mysql.com
Subject: a function to convert a uk date to and from mysql date
Hi,
My UK dates are this format DD/MM/ I want it reversed and
then the seperator changed
-Original Message-
From: js [mailto:[EMAIL PROTECTED]
Sent: 15 May 2007 15:31
To: MySQL List
Subject: Network address functions in MySQL?
Hi.
Today I found postgresql's neat feature, inet operators,
which allows you to do
inet '192.168.1/24' inet '192.168.1.5'
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: 10 May 2007 10:08
To: mysql@lists.mysql.com
Subject: adding 3 values
Hi,
I have 3 integer values in the table single_rooms, double_rooms,
twin _ooms but want to add them all up to do a comparison
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: 10 May 2007 10:08
To: mysql@lists.mysql.com
Subject: adding 3 values
Hi,
I have 3 integer values in the table single_rooms, double_rooms,
twin _ooms but want to add them all up to do a
Is it possible to enforce data formatting in fields using
something like
a regular expression?
varchar is great but does not stop someone putting in the wrong
reference number.
Dates should be in a DATE column, not a varchar.
The OP says 'data' not 'date' :) He is talking about a
-Original Message-
From: Mogens Melander [mailto:[EMAIL PROTECTED]
Sent: 01 May 2007 21:44
On Tue, May 1, 2007 21:36, Afan Pasalic wrote:
Hi,
I'm looking for database modeling tool form MySQL. Anybody used the
MySQL Workbench? I know the Workbench is in Alpha production, though
How can I change character_set_xxx variables in MySQL 4.1.x in Linux?
SET NAMES 'charset'
http://dev.mysql.com/doc/refman/4.1/en/charset-connection.html
Edward
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
Hi,
I have a query that returns data from a join of two tables, person and
company. The results look like:
FIRST_NAME | LAST_NAME | COMPANY_NAME
-
NULL | NULL | Toy Co
Mark | Smith | NULL
NULL | NULL | Big Corp
NULL | NULL
From: Baron Schwartz
Hi Edward,
Edward Kay wrote:
Hi,
I have a query that returns data from a join of two tables, person and
company. The results look like:
FIRST_NAME | LAST_NAME | COMPANY_NAME
-
NULL | NULL | Toy Co
Mark
30 matches
Mail list logo