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,
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
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,
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
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
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
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
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.
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
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,
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,
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 |
+-+--
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,
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
14 matches
Mail list logo
