Not Null doesn't run on Delphi

I wonder why even I already sey NOT NULL in Mysql field but Delphi (with MyODBC 3.51.06) still enable to save to the Table! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Mysql 4.0.16 stop working

Today, Mysql 4.0.16 for WinXP stop working. I try to restart my PC and run mysqld-nt, also try Start Service from WinMysqlAdmin, but nothing happen. I download Mysql for Windows but not purchase the Commercial Licence yet. Is there a time based restriction here? -- MySQL General Mailing List F

Re: Delphi & MySQL

> Briefly: > The project connects with TADOConnection, TADOTable and TDataSource, and > consists of two tab sheets, one with a DBGrid and DBNavigator1 (Read only), > and the other with an assortment of DBEdits, a DBMemo and a DbNavigator2, > this with full read/write options. > > Attempts to write

MySQL vs .NET

I am using Delphi 7 and MySql 4.0.16, since MS release .Net technology and also Delphi 8 .Net to provide web services application, I want to know how to make a web services application using Mysql? Or is there similiar technology like .Net but using Mysql? -- MySQL General Mailing List For list

How to know that user already login?

Dear All, How do I know that User "USER1" already login to Mysql? I am creating multiuser program and need to set only one User Name uses at same time. If there is 3 users that my login as User1, User2 and User3. William -- MySQL General Mailing List For list archives: http://lists.mysql.com/

Re: upgrading

to upgrade: rpm -U rpm_package_name but you must read mysql upgrading topic in mysql manual reference to avoid any problem. - Original Message - From: "Robert Morgan" <[EMAIL PROTECTED]> To: "mysqllist" <[EMAIL PROTECTED]> Sent: Friday, October 31, 2003 5:45 AM Subject: upgrading Hi, a

Multiuser Programming

I am doing transfer from MS SQL. In MS SQL while I connect as "USER1" my table will be create as User1.TableName. This will avoid conlict with other user. Now, how do I do that in Mysql? Or, maybe there is such system in Mysql. Is there any Mysql reference talk about this matter?

Update from other table

Does MySQL support update from other table? I run this query and get error: UPDATE TableA SET Division=TableB.Division FROM TableB WHERE TableA.Code=TableB.Code Thanks. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.m

How to update from other table?

I try convert this MS SQL Statement but an error occurs: UPDATE a SET a.ACCOUNT_CODE=b.ACCOUNT_CODE FROM a,b WHERE a.ACCODE=b.ACCOUNT_OLD Is there any syntax doing same as above? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysq

Install MySQL and MS SQL on Same Server

Will be any problem if I install MySQL 4.0.15 for Win on the Server that already has MS SQL 2K under W2K Server? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Copy database to another Server

I do mysqlamin shutdown and copy all /var/lib/mysql file from another MySQL server. And then run: chmod -R 660 * chown -R mysql:mysql * shutdown now -r But I can't logon to Mysql. What's wrong? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:htt

How to make Cascade Update?

I just migeate from MS SQL to MySQL but have problem on "Cascade Update". Suppose I have BOOK and LIST_TYPE tables like this: BOOK, field: Book_Name, Book_Type LIST_TYPE, field: Book_Type If I already define Cascade Update between BOOK and LIST_TYPE, then when I update the content of Book_Type (

SQLyog can not insert/update Table w/o Primary Key

Why SQLyog can not insert/update Table w/o Primary Key? Is there additional setting to enable this?