Re: ISP and users
On Fri, 2004-01-16 at 17:05, Bryan Koschmann - GKT wrote: Hello, I run an ISP where our web customers have access to the MySQL server. When they want a database, they request it through me and I add it. I was just curious if this is the common way it is done, or if there is a safe way they can add their own? Thanks, Bryan That's the way my ISP does it. Of course, that doesn't make it right. :-) Don Henson -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Mysql by itself?
On Thu, 2004-01-08 at 21:23, EP wrote: OK, I need to ask a stupid question. I normally run MySQL on Apache. I have a second machine [a laptop] which I can't get Apache to run on [the ports are restricted/closed]. Is there a way to run MySQL without a server like Apache underneath it? I see MySQL coined a database server; have I overlooked that it really is a server by itself? EP asking for a friend, I'm much smarter than this Yes, MySQL is a server and will run without Apache. Don Henson -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: web hosting quesiong (slightly off topic)
On Wed, 2004-01-07 at 07:09, Chris W wrote: I was wondering if anyone could recommend a good web hosting company for an Apache - php - MySQL project. I don't need much bandwidth or disk space to start out, but may need more if the site gets big. I would also like to have ssh access to the server, preferably a linux server. Chris W Check out colossus.net (http://www.colossus.net). I've used them for years. They have options available from sharing a server with several other people up to having your own dedicated server. The last time I checked, they had two T-3, one T-1, and some kind of Ethernet connection. They also have good tech support. They are running Linux (not sure which distro), Apache, PHP, MySQL, ssh, etc. I highly recommend them. Don Henson -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: insert: auto increment field
Please post your table schema. As to why bignbr rather than zero, I'll have to defer to the experts. Don Henson On Sun, 2004-01-04 at 16:52, Mike Mapsnac wrote: I use both metods and they works But when I make another insert I receive a message ERROR: 1062 Duplicate entry '2147483647' for key 1. Why id (primaty , and auto_increment) start from 2147483647 and not from 0 or 1 Thanks From: Donald Henson [EMAIL PROTECTED] To: MySQL List [EMAIL PROTECTED] Subject: Re: insert: auto increment field Date: Sun, 04 Jan 2004 08:44:56 -0700 On Sun, 2004-01-04 at 08:09, Mike Mapsnac wrote: I have table with 7 fields. First field is id (auto increment). As I understand the value should start from 0 and next value will auto increment. And I shouldn't add insert the value. So the insert statemens below gives me an error. ERROR 1136:Column count doesn't match value count at row 1 insert into product values('456789','t1', 'new', 2, 2, 10); Try using NULL for the id field, thusly: insert into product values (NULL,'456789','t1','new',2,2,10); I didn't actually try this but it should work. Don Henson -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] _ Get reliable dial-up Internet access now with our limited-time introductory offer. http://join.msn.com/?page=dept/dialup -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: The Future of MySQL with .NET Plataform
On Mon, 2004-01-05 at 07:31, Carlos J Souza wrote: Hello for all, Please i need comments about future of MySQL with .NET Plataform introduction. Regards for all Carlos Souza I don't know if you're going to get an answer to that query. .NET is not a very popular subject around here. If you discover the answer somewhere else, I would appreciate it if you could post a summary to the list. Thanks. Don Henson -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Inserting Dates
On Mon, 2004-01-05 at 12:46, Ian O'Rourke wrote: I'm very new to MySql and I'm having problems inserting dates into my tables (via the Web using Coldfusion). The user can put the following in the field: 12/09/2003 But the data returned from the database is: 2012-09-20 03:00:00.0 So I'm a bit confused about what I need to do in the insert statement so the user can just add the date (without a time). It's probably something really easy, but it;'s driving me nuts. Dates must be inserted in the mmdd format. For example, your entry above should be inserted as 20031209, assuming you meant 9 Dec 2003. Also note that the date must be inserted as a string which means enclosed in double quotation marks. Don Henson -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: insert: auto increment field
On Sun, 2004-01-04 at 08:09, Mike Mapsnac wrote: I have table with 7 fields. First field is id (auto increment). As I understand the value should start from 0 and next value will auto increment. And I shouldn't add insert the value. So the insert statemens below gives me an error. ERROR 1136:Column count doesn't match value count at row 1 insert into product values('456789','t1', 'new', 2, 2, 10); Try using NULL for the id field, thusly: insert into product values (NULL,'456789','t1','new',2,2,10); I didn't actually try this but it should work. Don Henson -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: insert: auto increment field
(You forgot to post this to the list.) Check to make sure you have the ID field set as autoincrement. By the way, duplicate entry is not the same thing as column count not matching. Also check to see if you have any other fields set as unique. On Sun, 2004-01-04 at 09:12, Mike Mapsnac wrote: I just tried.. Same problem with Duplicate Entry From: Donald Henson [EMAIL PROTECTED] To: MySQL List [EMAIL PROTECTED] Subject: Re: insert: auto increment field Date: Sun, 04 Jan 2004 08:44:56 -0700 On Sun, 2004-01-04 at 08:09, Mike Mapsnac wrote: I have table with 7 fields. First field is id (auto increment). As I understand the value should start from 0 and next value will auto increment. And I shouldn't add insert the value. So the insert statemens below gives me an error. ERROR 1136:Column count doesn't match value count at row 1 insert into product values('456789','t1', 'new', 2, 2, 10); Try using NULL for the id field, thusly: insert into product values (NULL,'456789','t1','new',2,2,10); I didn't actually try this but it should work. Don Henson -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] _ Take advantage of our limited-time introductory offer for dial-up Internet access. http://join.msn.com/?page=dept/dialup -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]