At 7:28 pm +0100 14/3/06, Martijn Tonies wrote:
>Given that NULLs basically means the absence of a value (eg: unknown), you
>shouldn't be storing NULLs.
At 1:49 pm -0500 14/3/06, Rhino wrote:
>A null means "unknown or not applicable" and is a perfectly valid value to use
>in many, many situation
Nelson:
Thanks a lot.
I found that sprintf(s,"%llu\n",ull.id); works with gcc but not with VC6.0 .
Thanks.
Regards,
Gu Lei
- Original Message -
From: "Dan Nelson" <[EMAIL PROTECTED]>
To: "??" <[EMAIL PROTECTED]>
Cc:
Sent: Wednesday, March 15, 2006 11:27 PM
Subject: Re: insert my
Dear Sir,
MySQL-4.1.12 on RedHat Linux EL4:
mysql> update TABLE1 set FIELD1=(select FIELD2 from TABLE2 where COLUMN2=
'[EMAIL PROTECTED]') where COLUMN1='[EMAIL PROTECTED]';
ERROR 1064: You have an error in your SQL syntax. Check the manual that corresp
onds to your MySQL server version for t
A commonly used example (at least at my last 3 jobs) would be a table of
demographics for people (whether they be employees, clients, whatever).
You can have one table and allow NULLs for some of the fields (id,
LastName, FirstName, MiddleInitial, Title, NameSuffix, AddressLine1,
AddressLine2,
Hi folks! I'm asking in a web form for clients, those clients I have to
search them into OFAC SDN lists(
http://www.ustreas.gov/offices/enforcement/ofac/sdn/delimit/index.shtml), if
they are into that list they wont be able to do transactions in my system.
My problem is to perform a good search of
Hi,
I installed this version of browser but it's not working properly. For
example, I don't see the command window on the top of the browser to type my
command. Do you have the same problem?
Also I noticed that when I go to mysql.mysql.com to download the commercial
version of MySQL, I am on
Martijn Tonies wrote:
Connie,
I have a database for ASN information in which I save asn information for
reference by other scripts (asn lookup can be expensive).
CREATE TABLE `ASNINFO` (
`asnInfoID` int(11) NOT NULL auto_increment,
`asNumber` int(11) NOT NULL default '0',
`description` va
Connie,
> I have a database for ASN information in which I save asn information for
reference by other scripts (asn lookup can be expensive).
>
> CREATE TABLE `ASNINFO` (
> `asnInfoID` int(11) NOT NULL auto_increment,
> `asNumber` int(11) NOT NULL default '0',
> `description` varchar(255) default
I have a database for ASN information in which I save asn information for
reference by other scripts (asn lookup can be expensive).
CREATE TABLE `ASNINFO` (
`asnInfoID` int(11) NOT NULL auto_increment,
`asNumber` int(11) NOT NULL default '0',
`description` varchar(255) default NULL,
`comment`
On Wed, Mar 15, 2006 at 05:42:40PM +0100, Mechain Marc wrote:
> I have a Mysql Server (4.1.8) where some sessions stay connected for a
> value greater than "Interactive timeout" value.
>
> Here is an abstract of the "show processlist" command:
>
> | 129996 | fret | mtt04.back:33598 | fret | Sle
- Original Message -
From: "Martijn Tonies" <[EMAIL PROTECTED]>
To:
Sent: Wednesday, March 15, 2006 10:47 AM
Subject: Re: Accountability with MySQL
Hello,
(please read all before replying)
>> >> > Basics of database design: store what you know.
>> >> >
>> >> > Given that NULLs ba
fbsd_user wrote:
Thank you Gabriel, more background information may result in a
better concept, so here it is.
The web based application I am writing deals with people who have an
a home for rent. They can sign up for small fee and enter their
rental property into the application so its searcha
> My current thinking is to break the entering of the property
> info into 3 separate forms, the first with the mandatory info
> does a insert to create the row with the remaining 100
> columns being seeded with $t=''. Group 2 & 3 will them be a
> update to the row using the 'set' keyword just touc
under the particular confinements you have set yourself, i would use the
session id to create a temporary table that you can update when each stage of
the form is complete. At the end you can present the user with all the data
they have entered so far and give them the option of editing or confir
I have a Mysql Server (4.1.8) where some sessions stay connected for a
value greater than "Interactive timeout" value.
Here is an abstract of the "show processlist" command:
| 129996 | fret | mtt04.back:33598 | fret | Sleep | 61756 |
| 129998 | fret | mtt04.back:33599 | fret |
A power bar is what they call the bar at the bottom and on the right
side of the browsers window when the content being showed in the
window is larger than the window. By sliding the bars around you
bring the content into view.
-Original Message-
From: James Harvard [mailto:[EMAIL PROTECT
Thank you Gabriel, more background information may result in a
better concept, so here it is.
The web based application I am writing deals with people who have an
a home for rent. They can sign up for small fee and enter their
rental property into the application so its searchable and viewable
by
you can add --old-password when starting MySQL manually or
try adding the following to the my.cnf file
[mysqld]
old-password
regards
Pure Web Solution
http://www.purewebsolution.co.uk
PHP, MYSQL, Web Design & Web Services
My /etc/my.cnf does not have this option? Is this something I can add?
W
Hello,
(please read all before replying)
> >> >> > Basics of database design: store what you know.
> >> >> >
> >> >> > Given that NULLs basically means the absence of a value
> >> >> > (eg: unknown), you shouldn't be storing NULLs.
> >> >> >
> >> >> Nonsense!!
> >> >
> >> > That's a bold statemen
In the last episode (Mar 15), ?? said:
> Thanks a lot! But my test is not successful. Please help me. This is
> my test code:
>
> #ifdef WIN32
> #include
> #endif
>
> #include "mysql.h"
> #include
> main()
> {
> union ull {
> unsigned char a[8];
> my_ulonglong id;
> } ull;
> for(int
- Original Message -
From: "Martijn Tonies" <[EMAIL PROTECTED]>
To:
Sent: Wednesday, March 15, 2006 2:53 AM
Subject: Re: Accountability with MySQL
>> > Basics of database design: store what you know.
>> >
>> > Given that NULLs basically means the absence of a value
>> > (eg: unknown
My /etc/my.cnf does not have this option? Is this something I can add?
What is the correct syntax?
Best regards,
Michael
Dominik Klein <[EMAIL PROTECTED]>
03/15/2006 09:33 AM
Please respond to
[EMAIL PROTECTED]
To
mysql@lists.mysql.com
cc
Subject
Re: How to build a client?
> I get
I have mysql-max-5.0.19-solaris10-sparc-64bit installed and running fine.
I have at times used the OLD PASSWORD ro resolve some issues but during my
build of php-5.1.2, no luck.
Here is the last part of the config.log with the errors.
"config.log" 639 lines, 31250 characters
ld: warning: file /
[addon to my previous mail]
I have not found
instructions on where to get the client software to build or upgrade a
client.
just use an up-to-date binary mysql distribution for your OS.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://l
I get various errors from my php based applications and php building that
all refer to the need to upgrade my mysqlclient.
Did you try "old-passwords" in /etc/my.cnf ?
Old clients use an old authentication protocol, which is not the default
on modern mysql servers. For compatibility, "old-pass
I get various errors from my php based applications and php building that
all refer to the need to upgrade my mysqlclient. I have not found
instructions on where to get the client software to build or upgrade a
client.
This system is a Solaris 10 SPARC system.
Best regards,
Michael
The info
You could also use a temp table, put data into it page-by-page and
insert the complete row after a last check into the "real" table.
This temp table might have an additional timestamp field according to
which evth. older than 1h(or some other time period) could easily be
deleted by a cronjob.
Look at mysql's error log ($MYSQL_DATA_DIR/$HOSTNAME.err). Do you see
anything strange there?
Anton Krall wrote:
No crons that would delete the tmp directory.. In fact, all the other files
stay there... Just mysql.sock goes away...
|-Original Message-
|From: Logan, David (SST - Ade
The message cannot be represented in 7-bit ASCII encoding and has been sent as
a binary attachment.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hmmm...
Let me say some thoughts...
First *fbsd_user* said that he has *100 input fields plus 40 different drop
downs.*
And everybody is arguing that they prefer "*one single insert*".
Is it just me... or are you thinking at a table with 140 columns ?
Thinking at such a monster... all the above di
Hi Sean,
I used to have similar problems with different character sets and my
solution is:
1) dump all data using mysql dump utility
2) check if data are OK - view your data with viewer which suports correct
character set
3) if data are not OK try to dump data in different character set
4) you
Hi,
2006/3/15, 古雷 <[EMAIL PROTECTED]>:
> Thanks a lot!
> But my test is not successful. Please help me.
> This is my test code:
>
> #ifdef WIN32
> #include
> #endif
>
> #include "mysql.h"
> #include
> main()
> {
> union ull {
> unsigned char a[8];
> my_ulonglong id;
> } ull;
> for(int i=
Thanks a lot!
But my test is not successful. Please help me.
This is my test code:
#ifdef WIN32
#include
#endif
#include "mysql.h"
#include
main()
{
union ull {
unsigned char a[8];
my_ulonglong id;
} ull;
for(int i=0;i<8;i++) ull.a[i]=(unsigned char)255;
char s[200];
sprintf(s,"%llu\
33 matches
Mail list logo
