lumn. Is there a way to assign default value to a DateTime
> > column, since I couldn't find that in the documentation?
_
From: Rhino [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 02, 2006 3:50 PM
To: [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com; rtroiana
Subje
Hi All,
I have recently noticed in the MySQL 5.0 documentation in section 11.3.1.
The DATETIME, DATE, and TIMESTAMP Types, it's mentioned that
"TIMESTAMP values cannot be earlier than 1970 or later than 2037. This means
that a date such as '1968-01-01', while legal as a DATETIME or DATE va
sql
string embedded in C# code?
Thanks,
Reema
-Original Message-
From: James Black [mailto:[EMAIL PROTECTED]
Sent: Tuesday, February 28, 2006 10:54 AM
To: rtroiana
Subject: Re: Dynamic queries v/s Stored Procs
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
rtroiana wrote:
> Al
I'm in a process of transitioning from dynamic queries that were generated
in C# code to using Stored Procedures. Although i haven't done any analysis
of time difference between the two. But i do have few reasons to move to
stored procedures:
1) I work on a security application and i heard of S
Hi All,
I'm trying to take scheduled backup from mysql administrator and it always
gives me a popup with this message.
"Enter user name and password for the account under which the task will be
executed."
it shows me username and password for my windows account and when I click
"ok" on the po
Hi All,
I had posted a query few days back that I couldn't connect to mysql database
from a network machine. So for that I added two entries in my firewall
exceptions.
I added the Port 3306 and mysqld, so firewall should allow any connection to
database from external computer. My problem wa
Thanks Gleb. I just had to manually make changes in my firewall. I allowed
requests to port 3306 & mysqld.exe in exceptions tab and it solved the
problem. The only reason I didn't think about firewall setting before since
whenever I try to run new service, I wud get a pop up from Firewall asking
to
Hi All,
I'm trying to connect to MySql server from MySql Administrator on a network
machine. I specify the Server host as IP of the machine where DB server is
running and Port as 3306.
Username as 'root' and the password
I have tried with other usernames and specifying machine name inst
lied,
Reema
-Original Message-
From: Gordon [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 01, 2005 8:39 AM
To: 'rtroiana'
Subject: RE: Database design query
I know what you are trying to do and I can see the logic advantage of having
a single table that defines the the gr
Hi All,
I'm trying to get data from Active Directory and storing in database. So I
have the following tables with their corresponding primary keys:
Group (GroupID)
Host (HostID)
User (UserID)
GroupMember(GroupID, MemberID)
The relatio
10 matches
Mail list logo