Try http://us2.php.net/manual/en/ref.mysql.php
---
** _/ ** David Logan
*** _/ *** ITO Delivery Specialist - Database
*_/* Hewlett-Packard Australia Ltd
_/_/_/
Thanks for your sugesstions. I tried to search this issue on
microsoft's website. and found that this problem is related with
timestamp fields. I have tried to connect from access 2k and 2003 to
mysql database. It works well for all the things. but gives above
error only when control jumps to
On 7/4/06, C K [EMAIL PROTECTED] wrote:
Thanks for your sugesstions. I tried to search this issue on
microsoft's website. and found that this problem is related with
timestamp fields. I have tried to connect from access 2k and 2003 to
mysql database. It works well for all the things. but gives
Hi everyone,
I have a couple of questions invovling using FOUND_ROWS() and UNION.
The manual states that:
The value of FOUND_ROWS() is exact only if UNION ALL is used. If
UNION without ALL
is used, duplicate removal occurs and the value of FOUND_ROWS() is
only approximate.
I am using UNION
Hi,
2006/6/29, Joerg Bruehe [EMAIL PROTECTED]:
Hi Pooly, all,
Pooly wrote:
Hi,
I stumbled on one issue yesterday which took me some time to figure out.
the table is :
create table tt ( PCname varchar(5) not null default '');
insert into tt values ('Centaure');
So, by mistake I
On Mon, Jul 03, 2006 at 01:55:26PM +0400, Timur Izhbulatov wrote:
I'm following the instructions [1] to convert character set. Unfortunately I
get
warnings about truncated data for some rows in several columns. All the
truncated columns are text type.
Assuming the `col' column is text type
On Tue, Jul 04, 2006 at 01:55:30PM +0400, Timur Izhbulatov wrote:
After some additional investigations I found the cause. It was some exotic
non-ASCII characters like '–' (long dash). At the same time Russian letters
don't cause any problems.
Sorry, I was wrong concerning Russian letters.
Its the same program, just Improved :-)
People hate things they do not understand.
You're probably right, and if I had memorized all the commands to be able to
edit text, and had gotten used to it, I may like it. I've just gotten used
to free-format editing w/o having to enter any commands
Hi Venu, all!
VenuGopal Papasani wrote:
Hi all,
I Have a table with followin structure where i have orgunit and parent
and value
orgunitparent value
12 10 x
15
I'm running into problems with both ASP.Net and ASP with this thing, and
it's driving me nutz. I have the same stored procedure which I'm calling
from my ASP app (some asp pages, some asp.net pages). Here is the
procedure:
CREATE PROCEDURE `sp_GetNextInv`(
in nChapterID Int,
out cInvNo
Tanner Postert wrote:
so i am doing a query on an enum field:
when i do this query:
select *, id as vid, user_id as uid from video where (file_complete =
'true') order by undt desc limit 0,10;
the results are 0.16 or 0.17 seconds.
instead of saying file_complete = 'true. if i say
I need to be able to do an UPDATE based on a relation. The following code
works in Microsoft SQL. What is the MySQL Equivalent?
UPDATE Chapters
SET MatSentDate='2006-07-04'
FROM Invoices I JOIN Chapters C ON C.ID=I.ChapterID
JOIN Schools S ON S.ID=C.SchoolID
WHERE I.InvoiceDate = '2006-01-06'
VB is not case sensitive, so changing the case didn't make any difference.
I'm still getting the same non-sensical error message.
Jesse
- Original Message -
From: DG @ NEFACOMP [EMAIL PROTECTED]
To: Jesse [EMAIL PROTECTED]; MySQL . Net List [EMAIL PROTECTED]
Sent: Tuesday, July 04,
Say I have the following tables;
siteID,name
--
site1, XYZ
site2, RSQ
ID,site,data
1, site1, M
2, site2, Q
3, site2, Y
4, site1, P
... etc.
And I want to create a view like this;
siteID,name,data
--
site1,
Hi,
Is it possible to create a table which has an array type in it?
For example, something like:
CREATE TABLE temp (id INT, email[] TINYTEXT);
Thanks
Nolan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
Search the Manual for CONCAT.
SELECT
/Peter
-Original Message-
From: z247 [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 04, 2006 10:02 PM
To: mysql@lists.mysql.com
Subject: Newbie - CREATE VIEW Question
Say I have the following tables;
siteID,name
--
mm.. I'm not sure what you're trying to achieve here?
Why do you want an array in there? I'm pretty sure it's not possible
(correct gang?), but I'm wondering why you'd want that.
What you *can* do is just store a serialized array in a textfield.
What i'm trying to do is dump a log file into
On Tuesday 04 July 2006 16:21, Nolan Rumble wrote:
SELECT COUNT(*) FROM temp GROUP BY recipient;
and it will list all the email addresses and how much email they
sent/received.
I suppose I can create another table which handles the variable length
recipients but I would like to avoid that
z247 schrieb:
Say I have the following tables;
siteID,name
--
site1, XYZ
site2, RSQ
ID,site,data
1, site1, M
2, site2, Q
3, site2, Y
4, site1, P
... etc.
And I want to create a view like this;
siteID,name,data
Nolan Rumble schrieb:
mm.. I'm not sure what you're trying to achieve here?
Why do you want an array in there? I'm pretty sure it's not possible
(correct gang?), but I'm wondering why you'd want that.
What you *can* do is just store a serialized array in a textfield.
What i'm trying to do
z247 schrieb:
Say I have the following tables;
siteID,name
--
site1, XYZ
site2, RSQ
ID,site,data
1, site1, M
2, site2, Q
3, site2, Y
4, site1, P
... etc.
And I want to create a view like this;
siteID,name,data
The parantheses come from a php function that is writing the statement. i
know they aren't needed.
I've seen the same results on another table with an enum with values like
'a','b','c','d', so although i haven't modified this specic query to not use
the reservered word true. i know the same
Hi,
Say I have the following tables;
siteID,name
--
site1, XYZ
site2, RSQ
ID,site,data
1, site1, M
2, site2, Q
3, site2, Y
4, site1, P
... etc.
And I want to create a view like this;
siteID,name,data
--
Hi,
both queries would have the limit on them, so they would only return 10
rows. but yes, there are probably about 10x as many records with true than
with anything else.
If there are only six possible values, and one values occurs ten times
as often as the other five values, that means it
Thank you!
--
View this message in context:
http://www.nabble.com/NewbieCREATE-VIEW-Question-tf1890326.html#a5171108
Sent from the MySQL - General forum at Nabble.com.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Hi, the GROUP_CONCAT worked. Thank you. However, I'm getting duplicates in
the all_data column. Is there a function like array_unique in PHP to
remove these duplicates?
I tried DISTINCT but that did not work.
Thank you.
--
View this message in context:
In an older mysql version there was a numerical thing called money
and it was supposed to round all things to just 2 numbers after the
decimal and maybe make sure the 2 numbers exist even if it's a zero. But
this function is not part of mysql version 4.1.
I tried INTEGER and CHAR and
C K wrote:
Thanks for your sugesstions. I tried to search this issue on
microsoft's website. and found that this problem is related with
timestamp fields. I have tried to connect from access 2k and 2003 to
mysql database. It works well for all the things. but gives above
error only when
Hi,
I'm running mysql 4.0.16 on RedHat Linux.
I tried shutting down mysql more than 2 hours ago, by executing
'mysqladmin shutdown', and it's still running. Here is the end of the
log file /var/log/mysqld.log:
060624 09:31:54 mysqld started
060624 9:31:55 InnoDB: Data file
Hello,
I have some question about InnoDB crash recovery.
Q: I understand transaction and write to disk sequence as following
figure. Is this correct?
w/
innodb_flush_log_at_trx_commit = 1
innodb_support_xa = on
sync_binlog = 1
skip-innodb_doublewrite
30 matches
Mail list logo