Peng Yi-fan wrote:
> Does anyone know where to download the 'Err Nr. Description'? pdf is best.
>
> Peng
Hello Peng
try
http://dev.mysql.com/doc/refman/5.0/en/error-handling.html
or perror in a terminal
cheers
yvan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysq
Does anyone know where to download the 'Err Nr. Description'? pdf is best.
Peng
Thanks Rhino, Johan, Melvin,
In my application I don't have stuff like "A.b. Mcdonald" etc.
But descriptions like "SUGARS AND SUGAR CONFECTIONERY".
This data is loaded as uppercase from a CSV textfile into a MySQL table.
Currently I use the MS Access function StrConv(Description,3) to set
proper
I have a very simple table that looks like this:
CREATE TABLE `contacts` (
`id` int(11) NOT NULL auto_increment,
`fullname` varchar(100) default NULL,
`user_id` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `user_id` (`user_id`),
KEY `user_id_2` (`user_id`,`fullname`),
CONSTRAINT `contacts_ibfk_1` FO
Parang Saraf wrote:
hello,
I am relatively new in this field. I am designing a database to store
the
events extracted from the oceans. This project later demands of
publishing
data on web. I am not able to decide which database to use. Mysql with
spatial extension or the postgis
There used to be a page at the MySQL site which showed comparison between
MySQL and its competitors. For example, one page contrasted MySQL with DB2.
These pages were lengthy and compared the product feature for feature.
I just had a look but I'm having trouble finding the comparison pages. I'm
On Tue, May 09, 2006 at 12:13:41PM -0400, Rhino wrote:
>
> - Original Message -
> From: "Mohammed Sameer" <[EMAIL PROTECTED]>
> To:
> Sent: Tuesday, May 09, 2006 9:56 AM
> Subject: Order by leads to an empty set.
>
>
> >Hi all,
> >
> >I have a strange problem and I can't really underst
It looks like today is my day! :)
I FULLTEXT indexed my table "products":
CREATE TABLE `products` (
`prod_id` int(8) unsigned NOT NULL auto_increment,
`prod_no` varchar(50) NOT NULL default '',
`prod_name` varchar(255) NOT NULL default '',
`prod_description` text,
`prod_colors` text,
hello,
I am relatively new in this field. I am designing a database to store the
events extracted from the oceans. This project later demands of publishing
data on web. I am not able to decide which database to use. Mysql with
spatial extension or the postgis one. I would prefer to use windows pl
Thanks Daniel!
-afan
> On 5/9/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
>> found this:
>> /etc/rc.d/init.d/mysqld restart
>> /etc/rc.d/init.d/httpd2 restart
>>
>> I think it should work?
>>
>
> Yeah, different systems, different locations, but the same purpose...
>
> --
> Daniel da Veiga
On 5/9/06, Edward Vermillion <[EMAIL PROTECTED]> wrote:
On May 9, 2006, at 1:50 PM, Daniel da Veiga wrote:
> On 5/9/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
>> hi again,
>> I have to restart as soon as possible mysql and apache on our web
>> server
>> (mandrake cooker 10) - since our ad
On 5/9/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
found this:
/etc/rc.d/init.d/mysqld restart
/etc/rc.d/init.d/httpd2 restart
I think it should work?
Yeah, different systems, different locations, but the same purpose...
--
Daniel da Veiga
Computer Operator - RS - Brazil
-BEGIN GEEK
On 5/9/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
hi again,
I have to restart as soon as possible mysql and apache on our web server
(mandrake cooker 10) - since our admin is "out of office" for today.
Are you sure you MUST restart those services? AFAIK you run Linux
exactly because you d
found this:
/etc/rc.d/init.d/mysqld restart
/etc/rc.d/init.d/httpd2 restart
I think it should work?
-afan
> On 5/9/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
>>
>> hi again,
>> I have to restart as soon as possible mysql and apache on our web server
>> (mandrake cooker 10) - since our adm
Thanks guys,
It worked - thank you all so very much.
At 13:28 -0400 9/5/06, Rhino wrote:
The reason you are getting so many rows has nothing to do with the
way you are using the count(*) function and adding the different
count() results together. The problem is that you are doing your
joins incorrectly... In your case, I think you need to change
hi again,
I have to restart as soon as possible mysql and apache on our web server
(mandrake cooker 10) - since our admin is "out of office" for today.
if someone can ive me some instructions, please?
1. what I have to restart first apaceh or mysql - or desn't matter?
2. I have sudo access (if I
hi again,
I have to restart as soon as possible mysql and apache on our web server
(mandrake cooker 10) - since our admin is "out of office" for today.
if someone can ive me some instructions, please?
1. what I have to restart first apaceh or mysql - or desn't matter?
2. I have sudo access (if I
- Original Message -
From: "Chris Sansom" <[EMAIL PROTECTED]>
To: "MySQL List"
Sent: Tuesday, May 09, 2006 11:47 AM
Subject: Sum of counts
Here comes a newbie question...
I want to get a total of entries from four tables which all match a
particular id. The result for the id I'm t
I don't know what your application is like, but I generally recommend
keeping your old table structure in tact as much as you can as to not
break application functionality. If the old ID field was never referenced
from within your application, then this might not be a problem. But to
avoid major
The now() function would be used in the INSERT/UPDATE statement, not the
form field.
$query = "INSERT INTO staffs (firstname, lastname, signin) VALUES
('$firstname', '$lastname', now())";
mysql_query($query) or die('Error, insert query failed');
See the change to your variable $signin. Change tha
$query = "INSERT INTO staffs (firstname, lastname, signin) VALUES
('$firstname', '$lastname', NOW())";
I think if you alter the table and set a default value on signin to
NOW()
ALTER TABLE staffs CHANGE signin signin DATETIME DEFAULT 'now()' not
null';
then you could just to :
$query = "INSE
Yup! Got it..
Thanks guys, to all of you, for REALLY fast help!
:)
-afan
> Yeah, pretty much, but I would keep cust_id around and start over with a
> true autoincrement from 1.
>
> On 5/9/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
>>
>> and this would be, in other words, the solution 2,
Thanks for your help,
How can I capture this information from a php form into a mysql table.
This is what I did:
1. I created the table and the user to access the database the table is in
create table staffs (
id int not null auto_increment primary key,
firstname varchar(20) not null,
lastname
Yeah, pretty much, but I would keep cust_id around and start over with a
true autoincrement from 1.
On 5/9/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
and this would be, in other words, the solution 2, right?
> If you really want to change the customer ID, then you can always copy
the
>
and this would be, in other words, the solution 2, right?
> If you really want to change the customer ID, then you can always copy the
> entire table to another table with a primary key set. Then simply
> reference that primary key field and forget the prior one.
>
> --
> Steve - Web Applicatio
Hi John,
right the problem boils down to this:
sitetable tasktable
ID taskidtaskid Changes
----
11010100
21110120
SELECT sitetable.siteid, tasktable.prices FROM sitetable,tasktable WHERE
In the last episode (May 09), Alla-amin said:
> I am trying to capture my server time automatically using php and
> insert it in a mysql table.
>
> Can the timestamp or time data type capture this information
> automatically without having me code anything else?
You can use the 'timestamp' type t
I would drop the primary key off of your cust_id and add a new field like
customer_id and relink using the old fk.
I'd probably do this by creating a new table and doing an INSERT INTO SELECT
FROM to populate the autoincrement and rename the table.. From there, add
the fk's to your other tables a
On 5/9/06, balaraju mandala <[EMAIL PROTECTED]> wrote:
Thank you Daniel for reply.
Just in curiocity i want ask u, how u r taking daily backups, just using
'mysqldump' or using any Tools.
I'm using mysqldump plus bzip2 to compress data for about 2 years now.
Tried many tools, mysqldump script
Well whatever you do to fix the problem, I would practice on
a copy of the database first, just to make sure that any
alterations to the tables are exactly what you want to
happen.
When you are 100% sure you know how to solve the problem,
then you know it is safe to make the changes to the liv
- Original Message -
From: "Mohammed Sameer" <[EMAIL PROTECTED]>
To:
Sent: Tuesday, May 09, 2006 9:56 AM
Subject: Order by leads to an empty set.
Hi all,
I have a strange problem and I can't really understand what's going on!
mysql> SELECT n.nid, n.sticky, n.created FROM node n WH
Here comes a newbie question...
I want to get a total of entries from four tables which all match a
particular id. The result for the id I'm testing (21) should be 233.
In my naivety, I thought something like this would work:
select count(a.id) + count(b.id) + count(c.id) + count(d.guide_id)
Thank you Daniel for reply.
Just in curiocity i want ask u, how u r taking daily backups, just using
'mysqldump' or using any Tools.
regards,
bala
If you really want to change the customer ID, then you can always copy the
entire table to another table with a primary key set. Then simply
reference that primary key field and forget the prior one.
--
Steve - Web Applications Developer
http://www.sdwebsystems.com
On Tue, May 9, 2006 9:33 am,
Hi everyone,
I am trying to capture my server time automatically using php and insert it in
a mysql table.
Can the timestamp or time data type capture this information automatically
without having me code anything else?
On 5/9/06, balaraju mandala <[EMAIL PROTECTED]> wrote:
Hi Dilip,
I got two binary logs in Server. I don't know how to find server uptime?
mysql> show master logs;
+--+
| Log_name |
+--+
| localhost-bin.08 |
| localhost-bin.09 |
+--
Marcus,
I just noticed that a key field (emailaddress) in my db is case
sensitive when it should not have been, so now I've got a bunch of
what are effectively duplicate records. I'm having trouble picking
them out so I can manually merge/delete them before changing the
collation on the field
Has anyone implemented connection pooling in C# .NET?
On 5/8/06, romyd misc <[EMAIL PROTECTED]> wrote:
What i meant by implementing connection pooling i meant if i need to do
any code changes other than changes in connection string.
Thanks,
Romy
On 5/8/06, Tim Lucia <[EMAIL PROTECTED]> wro
Hi all,
I have a strange problem and I can't really understand what's going on!
mysql> SELECT n.nid, n.sticky, n.created FROM node n WHERE n.type='image' AND
(n.uid = 1 OR n.status = 1) ORDER BY n.created desc;
Empty set (0.00 sec)
mysql> SELECT n.nid, n.sticky, n.created FROM node n WHERE n.ty
My God!
Rhino, that was a very long and very good answer!!
Impressive!!
/Johan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I'd be surprised if things actually turned out to be quite as simple as you
describe. For example, let's say that your column actually contained book
titles or names of people. Would you really want to see any of the following
in your column:
- A Diplomatic History Of The Un? (more likely: A D
First I would advice you to take a closer look at:
http://dev.mysql.com/doc/refman/5.0/en/join.html
It will answer your question.
/Johan
??? wrote:
Hi
There is a schema example below: (From "A first course in database system")
Product (maker, model,type)
Pc (model, speed, ram, hd, rd, price
Marcus Bointon wrote:
On 9 May 2006, at 14:27, Wolfram Kraus wrote:
WHERE concated_field LIKE '%87682%'
No, because that would also match numbers that contain that sequence
like '18768232876825'.
WHERE concated_field LIKE '87682<%' OR concated_field LIKE '%>87682'
Still poor performanc
Marcus Bointon schrieb:
On 9 May 2006, at 14:27, Wolfram Kraus wrote:
WHERE concated_field LIKE '%87682%'
No, because that would also match numbers that contain that sequence
like '18768232876825'.
2. This doesn't sound like a good DB-Design, why don't you use two
seperated fields for bo
Hi Cor,
Don't know if that function exists in MySQL...
If you by any chance is using PHP you can do it by using ucfirst(str)
But I quote the User Comment at
http://dev.mysql.com/doc/refman/5.0/en/string-functions.html from Tom
O'Malley:
Posted by Tom O'Malley on April 18 2006 1:16am
An exa
彭一凡 schrieb:
> Hi
>
> There is a schema example below: (From "A first course in database system")
>
> Product (maker, model,type)
> Pc (model, speed, ram, hd, rd, price)
> Laptop (model, speed, ram, hd, screen, price)
> Printer (model, color, type, price)
>
> The statement below seems wrong base
On 9 May 2006, at 14:27, Wolfram Kraus wrote:
WHERE concated_field LIKE '%87682%'
No, because that would also match numbers that contain that sequence
like '18768232876825'.
2. This doesn't sound like a good DB-Design, why don't you use two
seperated fields for both numbers, or a m:n ta
hi to all,
I have to redo a web site of one company and the structure of the current
db is a little mess.
one of them is customer id number. right now, customer table use as
primary key cust_id column varchar(50) PRIMARY KEY (no auto increment). I
really have no idea why previous developer made cus
彭一凡 schrieb:
> try this:
> WHERE concated_field LIKE '87682%'
> or
> WHERE concated_field LIKE '87682_'
>
would give me 876825 what i am not looking for.
And i were also looking for 87682.
So this doesn't work.
But thanks anyway :)
--
Smileys rule (cX.x)C --o(^_^o)
Dance for me! ^(^_^)o (o
Wolfram Kraus schrieb:
Barry wrote:
Hello everyone!
I have a slight problem matching rows.
My problem is the Value in a textfield is: "8768239857"
I created that with concat.
Is there a way to match one specific number out of that field?
like WHERE SUPERFUNCTION(concated_field) = 87682
WHER
try this:
WHERE concated_field LIKE '87682%'
or
WHERE concated_field LIKE '87682_'
it is based on SQL-99, not using PHP
- Original Message -
From: "Barry" <[EMAIL PROTECTED]>
To:
Sent: Tuesday, May 09, 2006 8:49 PM
Subject: Matching problem
> Hello everyone!
>
> I have a slight
Barry wrote:
Hello everyone!
I have a slight problem matching rows.
My problem is the Value in a textfield is: "8768239857"
I created that with concat.
Is there a way to match one specific number out of that field?
like WHERE SUPERFUNCTION(concated_field) = 87682
WHERE concated_field LIKE '%
Though I do not know what your schema is, I think you may try to decompose it
into several BCNFs
which can erase the redundancy of emailaddress.
- Original Message -
From: "Marcus Bointon" <[EMAIL PROTECTED]>
To:
Cc: "Chris" <[EMAIL PROTECTED]>
Sent: Tuesday, May 09, 2006 8:12 PM
Sub
Barry schrieb:
Hello everyone!
I have a slight problem matching rows.
My problem is the Value in a textfield is: "8768239857"
I created that with concat.
Is there a way to match one specific number out of that field?
like WHERE SUPERFUNCTION(concated_field) = 87682
Is something like that poss
On 9 May 2006, at 13:12, Marcus Bointon wrote:
I'm giving it a go, but it's been running for about 4 hours at 60%
CPU so far! Would it be quicker to tell it to use a case
insensitive collation to locate the duplicates?
I managed to come up with a variation on my original attempt that got
Hello everyone!
I have a slight problem matching rows.
My problem is the Value in a textfield is: "8768239857"
I created that with concat.
Is there a way to match one specific number out of that field?
like WHERE SUPERFUNCTION(concated_field) = 87682
Is something like that possible in any way?
On 9 May 2006, at 02:22, Chris wrote:
I would run this query:
SELECT
*
FROM mytable
WHERE LOWER(emailaddress) IN
(SELECT
LOWER(emailaddress)
FROM mytable
GROUP BY 1
HAVING COUNT(emailaddress) > 1)
This would show all duplicate emails, I would use the info this
displays to c
Hi
I have bought the MySQL certification study guide (v 5.0) and am almost
ready for the exams, does anyone know if the questions in the self study
guide are very similar to the ones that you get in the exam? and is
there anywhere else that i can get more questions like this for practice
pur
> I believe the answer is that there isn't a way to
fix the syntax for 3.23,
> because 3.23 simply doesn't support multi-table
deletes. An alternative
> solution is needed.
>
> One option would be to do this programmatically.
Collect the sectionids
> with a SELECT, then delete them with a sepa
60 matches
Mail list logo
