Hi,
Here is a tutorial:
=>
/*1. Kill the mysqld that may be running (not with -9):
kill `cat /var/lib/mysql/hostname.pid`
2. Restart MySQL in safe mode:
/usr/bin/safe_mysqld --skip-grant-tables&
3. Connect to MySQL:
/usr/bin/mysql
4. Use the mysql database:
use mysql;
5. Run the upda
Hi,
You can use select group_concat(segfees) from fsf;
The information bellow is from mysql manual, but you have to have mysql
4.1.x
=>
*
|GROUP_CONCAT(/|expr|/)|
This function returns a string result with the concatenated
non-|NULL| values from a group. It returns |N
Hi,
I would like to know if there is a way to do a full join in MySQL
and if yes, what version should I use or if there is any other way to
get the same result as a full join.
I am curently using 4.0.24 on linux.
Best regards,
Cristian Stoica
--
MySQL General Mailing List
For list arc
roblem is how can I get all the data in one big table ?
With the data you originally described, one big table looks like a bad
idea.
PB
inferno wrote:
Hi,
I have the data from MS Access to MySQL, half imported by now,
that is not the problem, the same with importing from excel files.
ike DbTools, which is freeware. Or (perhaps the
most complex method), you can create the target MySQL table, use
ODBCAdmin to create a DSN for it, and export to that.
Is that the info you are looking for?
PB
-
inferno wrote:
Hi,
First of all thank you for your reply.
The table na
customer_id
customer_type (whatever values you want corresponding to cp2 etc)
(5) populate customer_type from joins on
customer and cp2
customer and cp3
customer and cp4
using old_id
(6) drop the old_id column from customers
PB
-
inferno wrote:
H
Hi,
I have the following tables: ( some in Microsoft Access and some in
Excel ) and I want to migrate the data into MySQL and develop an
interface in PHP for easy administration and control.
*1) Sales Representative Code
*sr_id INTEGER ( unique )
sr_user VARCHAR
sr_name VARCHAR
sr_email
Hi,
Yes I want only 24 hours of business program, and like you've said I
do not want to include Saturday and Sunday, since nobody is working in
the week-end.
Thank you very much for the help.
Best regards and have a nice week-end,
Cristi Stoica
Michael Stassen wrote:
inferno
1 row in set (0.01 sec)
So your query should be similar to :
Select * from tbl where status='2' and date <= DATE_ADD(now(), INTERVAL -1 DAY)
and date_format(date, '%a') in ('Mon', 'Tue', ...,'Fri');
Hope that helps
Mathias
-Original Messag
Hi,
I have a problem: I need to make a select for data that was entered
more than 24 hours ago, but in that 24 hours I have to count only Monday
- Friday since that is the working program, and does not have the status
= '2' ( Solved ) and the problem is that I sincerly do not know how.
An
Hi,
I had to do the same thing on a project and the problem was that if
you use CSV you will not be able to make a formated excel document.
I am using now *Spreadsheet_Excel_Writer
(
*http://pear.php.net/package/Spreadsheet_Excel_Writer ) and it does
everything I need, including format
Hi,
Thank you very much that was what I looking for.
Best regards,
Cristi
Harald Fuchs wrote:
In article <[EMAIL PROTECTED]>,
iNFERNo <[EMAIL PROTECTED]> writes:
Hi,
First of all thank you all for the quick replys.
Now here's:
select * fro
nal Message -
From: "Michael J. Pawlowsky" <[EMAIL PROTECTED]>
To: "Rhino" <[EMAIL PROTECTED]>;
Sent: Wednesday, April 06, 2005 7:51 PM
Subject: Re: I need some help
Rhino wrote:
- Original Message -
From: "iNFERNo" <[EMAIL PROTE
Hi,
I have a problem: I am using mysql 4.0.24 and I need to make
some reports from a database:
mysql> describe events;
+-+--+--+-+-++
| Field | Type | Null | Key | Default | Extra |
+-+--
14 matches
Mail list logo
