Unknown auto ROLLBACK
Hi all, I found out today that MySQL is adding a 'ROLLBACK' command to each session connecting to it, without explicitly ordering this. This is new since we never had this behavior before. Why is this happening, and how can I revert to the old beahvior (each command sent is carried out and performed instantly, with no rollback option.) Please CC me in your replies. Thanks in advance. Noor - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Compile error on Solaris
Getting the following error trying to build mysql-3.23.52 on a solaris 8 box. g++ -DMYSQL_SERVER -DDEFAULT_MYSQL_HOME=\/usr/local\ -DDATADIR=\/usr/local/var\ -DSHAREDIR=\/usr/local/share/mysql\ -DHAVE_CONFIG_H -I./../include -I./../regex -I. -I../include -I.. -I.-O3 -DDBUG_OFF -fno-implicit-templates -fno-exceptions -fno-rtti -DHAVE_CURSES_H -I/nfs2/home/akbeech/sinbad_software/secure_server/mysql-3.23.52/include -DHAVE_RWLOCK_T -c sql_lex.cc sql_lex.cc: In function `void lex_init()': sql_lex.cc:85: `symbols' undeclared (first use this function) sql_lex.cc:85: (Each undeclared identifier is reported only once sql_lex.cc:85: for each function it appears in.) sql_lex.cc:87: `sql_functions' undeclared (first use this function) sql_lex.cc: In function `int find_keyword(LEX *, unsigned int, bool)': sql_lex.cc:168: implicit declaration of function `int get_hash_symbol(...)' sql_lex.cc:168: initialization to `SYMBOL *' from `int' lacks a cast make[3]: *** [sql_lex.o] Error 1 make[3]: Leaving directory `/nfs2/home/akbeech/sinbad_software/secure_server/mysql-3.23.52/sql' make[2]: *** [all-recursive] Error 1 This is a new solaris and mysql install, am I missing a lib or something? Could use some help here, thanks in advance. Beech -- --- Beech Rintoul - SysAdmin - [EMAIL PROTECTED] /\ ASCII Ribbon Campaign | Sinbad Network Communications \ / - NO HTML/RTF in e-mail | 3101 Penland Parkway #K-38 X - NO Word docs in e-mail | Anchorage, AK 99508-1957 / \ - - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: automating import process
On Sun, 29 Sep 2002 [EMAIL PROTECTED] wrote: The script so far is like this: ./mysql -u 'root' -ppassword use import_test1; When it executes, it just waits at the mysql prompt. It does not seem to recognize that I want to input use import_test1; Can anyone help? Sure! You have to create a script file that contains the SQL statements you are about to run. ./mysqld -u root -ppassword myscript.sql Edit myscript.sql to contain your SQL code. Best regards, Iikka Thanks. Peter On Fri, 27 Sep 2002, [ISO-8859-1] Iikka Meriläinen wrote: Hi, use this: mysql -u root -ppassword It's important NOT to put a space between -p and the real password. Having a password in a script is unsafe at its best, though. I'm not sure if you have any other options than to put it that way or enter it manually each time you run the script. Regards, Iikka On Sat, 28 Sep 2002 [EMAIL PROTECTED] wrote: Hi Carl, Thanks for your reply. I have created a shell script but I get stuck on the part where it asks to input password. How do I get the script to input the password that I put in? So far my script looks like this: ./mysql -u 'root' -p echo abc The script executes, but it just waits for the password after it executes the line: ./mysql -u 'root' -p Can anyone help with this? Thanks. Peter On Mon, 5 Aug 2002, Carl McNamee wrote: I'm assuming that you are using some form of unix in this. From the system prompt type mysql -u root -ppassword import_test1. If this works just put it into a script (bash, perl, whatever) and run it either from the command line or via cron if you want it automated. Carl McNamee Systems Administrator Billing Concepts (210) 949-7282 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Saturday, August 03, 2002 11:58 PM To: [EMAIL PROTECTED] Subject: automating import process Hi, I want to try to automate a phonebook list import process into MySQL database. The phonebook was originally created with MS Access and exported into a text file. I upload that text file onto my server and I proceed with the following import process. Using Telnet I type: # ./mysql -u 'root' -p It then asks Enter password: I then select the database to use mysql use import_test1; I delete the previous phonebook list table because the import process does not know that it should replace the previous records even though there have been changes mysql use import_test1; mysql exit Bye I then import by doing the following: [root@ns2 bin]# ./mysqlimport --local -u root -p --fields-terminated-by=, import_test1 phone2.txt Enter password: import_test1.phone2: Records: 53 Deleted: 0 Skipped: 0 Warnings: 1 I was wondering is there anyway to automate this process in a script? I have never written a script in Linux before. If I can automate this process, what kind of script should I use? Thanks. Peter - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php ** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ** - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try:
Re: Copying to tmp table
Sender: [EMAIL PROTECTED] Date: Tue, 24 Sep 2002 08:21:20 +0200 From: Lars Heidieker [EMAIL PROTECTED] on solaris it probably a good idea to change the tmp directory from /var/tmp - /tmp I recalled this feature and decided to look into linux for it's parallel. It's called tmpfs and probably requires a kernel build for most users (I have no idea what RedHat does nowdays, nor any of the popular distributions for that matter). In a kernel 'make xconfig', select the 'Virtual memory file system support' under the File systems tab. Add a mount in /etc/fstab along the lines of : tmpfs /var/tmptmpfs size=100M In my.cnf, adjust tmpdir tmpdir = /var/tmp -- You want to avoid mounting at /tmp for reasons noted in the tmpfs docs. There are additional reasons to avoid /tmp, just ensure the permissions on /var/tmp match /tmp. sql,query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Problem on ALTER TABLE ... ADD CONSTRAINT FOREIGN KEY..
Jungsu, - Original Message - From: Heo, Jungsu [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Saturday, September 28, 2002 9:34 AM Subject: Problem on ALTER TABLE ... ADD CONSTRAINT FOREIGN KEY.. Hello. I have a problem on ALTER TABLE ... ADD FOREIGN KEY. I'm using InnoDBs, and I wanna create Foreign Key after table has been created. But, 'ALTER TABLE .. ADD FOREIGN KEY does not work. Manual says : The FOREIGN KEY, CHECK, and REFERENCES clauses don't actually do anything And in my test, 'ALTER ADD FOREIGN KEY' does not create FK. mysql CREATE TABLE `CONS_PARENT` ( - `A` int(11) NOT NULL default '0', - `B` int(11) NOT NULL default '0', - UNIQUE KEY `A` (`A`,`B`) ) Type=InnoDB ; Query OK, 0 rows affected (0.02 sec) mysql CREATE TABLE `CONS_CHILD` ( - `A` int(11) NOT NULL default '0', - `B` int(11) NOT NULL default '0', - KEY `A` (`A`,`B`) - ) TYPE=InnoDB ; Query OK, 0 rows affected (0.05 sec) mysql ALTER TABLE CONS_CHILD ADD CONSTRAINT FOREIGN KEY CONS_CHILD_FK ( A , B ) REFERENCES CONS_PARENT ON DELETE CASCADE ; Query OK, 0 rows affected (0.05 sec) Records: 0 Duplicates: 0 Warnings: 0 # See Below! FK does not EXIST mysql SHOW CREATE TABLE CONS_CHILD ; ++-- -+ | Table | Create Table | ++-- -+ | CONS_CHILD | CREATE TABLE `CONS_CHILD` ( `A` int(11) NOT NULL default '0', `B` int(11) NOT NULL default '0', KEY `A` (`A`,`B`) ) TYPE=InnoDB | ++-- -+ 1 row in set (0.00 sec) the problem above is that the syntax of the ALTER TABLE is wrong for InnoDB. InnoDB uses the syntax of SQL-1992 with the restriction that InnoDB always requires that also the columns in the referenced table are always explicitly named. No name can be given to the foreign key constraint. The MySQL parser approves the constraint, though, because the syntax in MySQL is less restrictive. Hmm... I have to add the extended foreign key syntax to InnoDB-4.0.x. InnoDB-4.0.5 will give a table handler error 150 if the syntax is not ok. That will warn the user. I will also update the MySQL-4.0 manual. http://www.innodb.com/ibman.html#InnoDB_foreign_keys Starting from version 3.23.50 InnoDB allows you to add a new foreign key constraint to a table through ALTER TABLE yourtablename ADD CONSTRAINT FOREIGN KEY (...) REFERENCES anothertablename(...) ... Remember to create the required indexes first, though. You can also add a self-referential foreign key constraint to a table using ALTER TABLE. From a SQL-1992 draft: 11.8 referential constraint definition Function Specify a referential constraint. Format referential constraint definition ::= FOREIGN KEY left paren referencing columns right paren references specification references specification ::= REFERENCES referenced table and columns [ MATCH match type ] [ referential triggered action ] match type ::= FULL | PARTIAL referencing columns ::= reference column list referenced table and columns ::= table name [ left paren reference column list right paren ] reference column list ::= column name list referential triggered action ::= update rule [ delete rule ] | delete rule [ update rule ] update rule ::= ON UPDATE referential action delete rule ::= ON DELETE referential action referential action ::= CASCADE | SET NULL | SET DEFAULT | NO ACTION Does any body know how can create FK after tables creates? I rewrote the ALTER TABLE in the InnoDB syntax and tested 4.0.4: mysql ALTER TABLE CONS_CHILD ADD CONSTRAINT FOREIGN KEY ( A , B ) - REFERENCES CONS_PARENT (A, B) ON DELETE CASCADE ; Query OK, 0 rows affected (0.00 sec) Records: 0 Duplicates: 0 Warnings: 0 mysql mysql SHOW CREATE TABLE CONS_CHILD ; ++-- --+ | Table | Create Table | ++--
Re: MySQL as a desktop DB
I don't think Access is crap at all. In fact I think it's a) the best RAD front end going for SQL Server and perhaps for MySQL too. I use Access 2000 and 2002 + MyODBC to create front ends to MySQL databases and the combination works great. In less than one morning I successfully ported the Northwind sample application to MyOBC+MySQL. I had to fix a couple of queries that wouldn't translate, but other than that it worked like a charm. And one of the best reasons to go with such a combination is that Access can save named queries, which can then be combined. For example: qryProductsList: SELECT products.ProductID, products.ProductName, products.UnitPrice, products.SupplierID FROM products ORDER BY products.ProductName; qrySuppliersList: SELECT suppliers.SupplierID, suppliers.CompanyName FROM suppliers ORDER BY suppliers.CompanyName; qryCombinedProductsAndSuppliersList: SELECT qryProductsList.ProductName, qryProductsList.UnitPrice, qrySuppliersList.CompanyName FROM qrySuppliersList INNER JOIN qryProductsList ON qrySuppliersList.SupplierID = qryProductsList.SupplierID; MySQL by itself doesn't provide this kind of capability. I find it enormously valuable. Just my $.02. Arthur - Original Message - From: David Lloyd [EMAIL PROTECTED] To: Adam Parker [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Tuesday, September 24, 2002 8:37 PM Subject: Re: MySQL as a desktop DB Adam, Obviously MySQL would have advantages if I intended to use it as a server database with concurrent users. But is it faster than Access in the single-user environment, when dealing with large databases? MySQL in a single user environment is a pain in the arse because of its lack of an Access Like front end that is actually useful and featureful (Access is crap, but it's a better database frontend than currently exists). (mysql, query) DSL -- I reniad lin ne mor, nuithannen In gwidh ristennin, i fae narchannen I lach Anor ed ardhon gwannen (Soundtrack LOTR - and it's not LATIN) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Runaway mysqld
Hi! We are operating several MySQL servers and most are running just fine even under high load. However we have one site (High traffic PHP based site) where we currently is experiencing problems with some strange lock up that causes MySQL to spawn new threads and have a huge number of threads in ready to run mode. The load goes from below 1 (on a dual PIII machine, running Slackware 8 with kernel 2.4.18 and MySQL 3.23.51-max (binary from mysql.com). From what I have read, this is most likely due to an internal error that can't be delt with as a result of a specific query. Here's a snip from vmstat 5: 38 0 0 0 5472912 294552 0 0 051 365 625 96 4 0 56 0 0 0 8016912 294588 0 0 026 519 805 96 4 0 36 0 1 0 8904912 294624 0 0 0 0 466 884 95 5 0 63 0 1 0 8672912 294656 0 0 0 0 433 867 97 3 0 And a mysqladmin processlist shows a bunch of connections in state locked: ...snip... | 5362 | public | localhost | onside1 | Query | 3| Locked | select id from banners_new where (id=131 OR parent_id=131) AND pic!='' | | 5363 | public | localhost | onside1 | Query | 0| System lock | select id from banners_new where (id=131 OR parent_id=131) AND pic!='' | | 5364 | public | localhost | onside1 | Query | 0| Locked | select id from banners_new where (id=131 OR parent_id=131) AND pic!='' | | 5365 | public | localhost | onside1 | Query | 0| Locked | select id,pic from banners_new where (id=110 OR parent_id=110) AND pic!='' limit 0,1 | ...snip... The config (mostly a my-huge.cnf file): [mysqld] datadir = /data/db user= mysqld port= 3306 socket = /tmp/mysql.sock skip-locking set-variable= max_connections=256 set-variable= key_buffer=256M set-variable= max_allowed_packet=1M set-variable= table_cache=256 set-variable= sort_buffer=1M set-variable= record_buffer=1M set-variable= myisam_sort_buffer_size=64M set-variable= thread_cache=8 # Try number of CPU's*2 for thread_concurrency set-variable= thread_concurrency=8 #log-bin server-id = 1 Any ideas on how to debug this? Logging all queries is almost not an option since the traffic (when the error occurs) is several hundred queries / second (according to mysqladmin status). Thanks in advance! Brgds /Stefan -- DISCUSSION, n. A method of confirming others in their errors. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Urgent!!
Hi, I have a certain task to be done, which is a Database Driven website based on MySQL operated on Linux, my Question is: Can I develope such a site using ASP (Active Server Pages)? So, I will avoid spending a lot of time in learning other technology instead of ASP. and also if there is special requirements in order to do it. Best Regards. I.M.A _ Send and receive Hotmail on your mobile device: http://mobile.msn.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Optimizing Configuring For Heavy Loads
Greetings Everyone, I am new to this list - I have lurked for awhile and have examined the archives - if I am out of form in my questions please let me know. My situation is this - I have acquired a red hat 7.3 server at a new pop. I am moving our MySQL driven web applications over to this new server over the coming week. It is not live, so I can mess around as required to make sure everything is 100% before doing so. The hardware is a dual x342 IBM rack mount with 1GB of RAM and 10,000 RPM drives. It will only be running apache / perl and MySQL. I have been referring to this document: http://www.mysql.com/doc/en/Linux.html I have made a post to the red hat users list to help me determine how my linuxthreads has been configured (I did not install the OS) and from there want to configure MySQL for the maximum load I can. Some performance hits under lower loads is acceptable. Currently, I have 3.23.49 installed which came pre-installed for me. I am hoping to get some ideas from some of the gurus towards how high I can up the settings for the above hardware configuration assuming my threading has been tweaked appropriately. Thank you in advance for any help you can offer. I am new to this level of system administration and have been reading till my eyes blur getting up to speed. Mitchell - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Urgent!!
Greetings... I believe that ASP works well with MySQL thru ODBC. As of learning other technologies it really depends what all you require. Still MySQL works best with PERL and PHP. Rgs Insane SQLyog ( http://www.webyog.com/sqlyog ) The Definative Front End for MySQL - Original Message - From: Ibrahim Al-Tawil [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, September 29, 2002 10:21 PM Subject: Urgent!! Hi, I have a certain task to be done, which is a Database Driven website based on MySQL operated on Linux, my Question is: Can I develope such a site using ASP (Active Server Pages)? So, I will avoid spending a lot of time in learning other technology instead of ASP. and also if there is special requirements in order to do it. Best Regards. I.M.A _ Send and receive Hotmail on your mobile device: http://mobile.msn.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Setting Permission For Column Level Only
Greetings... I want to create a user which will have only Select privileges in two columns a particular table. For that I creates a entry in the User table in MySQL and set it as default with N in all. Also I entered some rows in the Columns_Priv table. Now my question is - Do I have to enter records in db and tables_priv table with the user name and all privileges set to N or default to make the column privileges work or if I enter a row in the columns_priv table, that will do. Rgds Insane SQLyog ( http://www.webyog.com/sqlyog ) The Definative Front End for MySQL - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Retrieving Table Schema
Hello All, Suggestions Feedback Requested: I'm looking for a solution that will not lock a table, yet allow me to retrieve the: field name, field type as integer, field size, and other attributes of each column from a table. The Issue: When requesting the Table Schema from mySQL I have found an error that prevents me from deleting the table. This error was found while testing an interface DLL to mySQL. The test creates a dummy table, populates it with data, runs various counts and sums, updates data, and deletes the data. An important part of the test is to be able to retrieve the table's schema. I can't explain why without releasing proprietary corporate information, all I can say is that it's needed. What I can tell you is that when I retrieve it with a mixed case table name, it prevents me from deleting the table. The Cause: VB and VBS programmers usually retrieve table schema through the ADODB.Connection objects, by calling OpenSchema. I have found, though, that if OpenSchema is called with a mixed case table name, ie .. JunkA .. this will lock the table and prevent it from being deleted. I have also found that mySQL has the flag, lower_case_table_names. This flag is set to 1. I have not tested either work around below with this flag set to 0 or any other value at this time. Solutions found so far: I have found two work arounds for this. 1) The first is to force all table names to lower case. 2) The second work around is to use DESCRIBE [table] or SHOW COLUMNS FROM [table]. Option two requires more programming to accommodate the translation from string type names to integer type names, as used in ADOVBS. I am hoping, however, that I have missed something in the mySQL documentation that actually provides what I'm looking for. Again: I'm looking for a solution that will not lock a table, yet allow me to retrieve the: field name, field type as integer, field size, and other attributes of each column from a table. Code samples follow: ENetArch Code samples: === EXE - 1 Option Explicit Private cn As Object Private objStore As Object Private Const szODBC = UID=sa;PWD=sa;DSN=mySQL; Private szTableName As String Sub Main() Dim x Set cn = CreateObject(adodb.connection) cn.open (szODBC) Set objStore = CreateObject(navisstardet_mysql.store_mysql) Set objStore.Connect = cn szTableName = atest_A0 x = objStore.CreateTable(szTableName, Nothing) x = objStore.getStructure_SCF(szTableName) x = objStore.DropTable(szTableName) x = objStore.CreateTable(szTableName, Nothing) x = objStore.getStructure_OS(szTableName) x = objStore.DropTable(szTableName) Set objStore.Connect = cn End Sub === DLL - Store_mySQL Option Explicit ' Include ADOVBS Private cn As Object ' === Private Sub Class_Initialize() Set cn = Nothing End Sub ' === Public Property Set connect(ByVal objCn As Object) Set cn = objCn End Property ' === Public Function createTable _ (ByVal szTableName As String, _ ByVal objStr As Object) Dim szSQL As String szSQL = _ CREATE TABLE szTableName _ ( _ ID INTEGER AUTO_INCREMENT, _ PRIMARY KEY ( ID ) , _ Date_Created DATETIME , _ Closed BIT , _ Date_Closed DATETIME , _ SortBy VARCHAR (40), _ CompanyName VARCHAR (40), _ ContactName VARCHAR (40), _ Street1 VARCHAR (40), _ Street2 VARCHAR (40), _ City VARCHAR (20), _ State VARCHAR (2), _ Zip VARCHAR (10), _ Country VARCHAR (20), _ Tele VARCHAR (12), _ Email VARCHAR (250), _ WebSite VARCHAR (250) _ ) cn.execute (szSQL) End Function ' === Public Function dropTable(ByVal szTableName As String) Dim szSQL As String szSQL = _ DROP TABLE szTableName cn.execute (szSQL) End Function ' === Function getStructure_OS(ByVal szTableName As String) ' Method 1 ' Two methods of retrieving the tables schema are presented here. ' If you choose to use Method 1, make sure that the tables name is ' all lower case. Retrieving a table's schema, where the table name ' is mixed case presently (2002-09-29) causes a mySQL table to ' lock the table, and it's immediate deletion. ' This can be annoying during testing - of install and uninstall processes. ' Work Around 1 is to use LCASE () to change the table case before ' retrieving the schema. ' Work Around 2 is to issue a DESCRIBE [table] or ' SHOW COLUMN FROM [table] SQL command. '
MySQL a quotas?
Hi, I'm solving problem how to set up quota on MySQL db. I've look for that in mailing lists and docummentation but with no success. Can someone help me with this problem? Thanks -- jiri musil [EMAIL PROTECTED], icq# 125282227 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
4.0.3 executables problem on SCO 5.0.6
Sorry for the duplicate post - subject missing from initial post. I was finally able to get 3.23.52 successfully compiled and running on SCO 5.0.6 with the help of list members; gcc 2.95.2, FSU pthreads and the SCO assembler with libraries were used for the build. The server and client programs for 3.23.52 seem to function correctly on the SCO box, and Windows XP clients on the network can access the server with mysqlgui or MS Access using the myodbc 2.50 ODBC driver. I next tried to get 4.0.3 to compile and install (after removing 3.23.52), as an app I am developing may not be ready until one of the 4.x versions is considered production level. The source compiles without error, installs, and mysql_install_db runs without error. Mysqld_safe seems to load, but both mysqlgui and Access hang when trying to contact the server from the network, and both mysqladmin and mysql hang after loading. Using -enable-thread-safe-client for configuration didn't make any difference for the unix-based clients. I didn't expect the Windows clients to connect, as privileges couldn't be granted without functioning mysqladmin or mysql on the server box. However, they should have received the error host xyz is not allowed to connect to this MySQL server rather than hanging. I uninstalled 4.0.3 and rebuilt/installed 3.23.52 just to make sure that I hadn't made any system changes, and 3.23.52 (server and client programs) still runs without error. David P. Lurie Rheumatology Associates, P.C. 106 Woodlawn Drive Johnson City, TN 37604 (423) 929-3358 voice - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: MySQL as a desktop DB
Hi Arthur, Which version of MySQL / MyODBC are you using? I tried building an app with an Acc2000 frontend and a MySQL backend using MyODBC and kept running into a problem where the record being edited would become 'locked' and wouldn't allow me to update (from memory it was something along the lines of the table reporting it was busy performing another action or similar). This frustrated me enough that I finally gave it away and now use SQL Server as my 'big backend.' Regards, M. -Original Message- From: Arthur Fuller [mailto:[EMAIL PROTECTED]] Sent: Monday, 30 September 2002 12:12 AM To: David Lloyd; Adam Parker Cc: [EMAIL PROTECTED] Subject: Re: MySQL as a desktop DB I don't think Access is crap at all. In fact I think it's a) the best RAD front end going for SQL Server and perhaps for MySQL too. I use Access 2000 and 2002 + MyODBC to create front ends to MySQL databases and the combination works great. In less than one morning I successfully ported the Northwind sample application to MyOBC+MySQL. I had to fix a couple of queries that wouldn't translate, but other than that it worked like a charm. And one of the best reasons to go with such a combination is that Access can save named queries, which can then be combined. For example: qryProductsList: SELECT products.ProductID, products.ProductName, products.UnitPrice, products.SupplierID FROM products ORDER BY products.ProductName; qrySuppliersList: SELECT suppliers.SupplierID, suppliers.CompanyName FROM suppliers ORDER BY suppliers.CompanyName; qryCombinedProductsAndSuppliersList: SELECT qryProductsList.ProductName, qryProductsList.UnitPrice, qrySuppliersList.CompanyName FROM qrySuppliersList INNER JOIN qryProductsList ON qrySuppliersList.SupplierID = qryProductsList.SupplierID; MySQL by itself doesn't provide this kind of capability. I find it enormously valuable. Just my $.02. Arthur - Original Message - From: David Lloyd [EMAIL PROTECTED] To: Adam Parker [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Tuesday, September 24, 2002 8:37 PM Subject: Re: MySQL as a desktop DB Adam, Obviously MySQL would have advantages if I intended to use it as a server database with concurrent users. But is it faster than Access in the single-user environment, when dealing with large databases? MySQL in a single user environment is a pain in the arse because of its lack of an Access Like front end that is actually useful and featureful (Access is crap, but it's a better database frontend than currently exists). (mysql, query) DSL -- I reniad lin ne mor, nuithannen In gwidh ristennin, i fae narchannen I lach Anor ed ardhon gwannen (Soundtrack LOTR - and it's not LATIN) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re:Re: Problem on ALTER TABLE ... ADD CONSTRAINT FOREIGN KEY..
Hello, Heikki. Thank you very much for your reply!. I Found the problem. If I give FK name explicitly, ALTER TABLE FOREIGN KEY .. dose not works. Example 1 - give FK name explictly # mysql alter table CONS_CHILD ADD constraint foreign key CONS_CHILD_FK - ( A, B ) REFERENCES CONS_PARENT(A, B ) ; Query OK, 0 rows affected (0.04 sec) Records: 0 Duplicates: 0 Warnings: 0 mysql show create table CONS_CHILD ; ++-- -+ | Table | Create Table | ++-- -+ | CONS_CHILD | CREATE TABLE `CONS_CHILD` ( `A` int(11) NOT NULL default '0', `B` int(11) NOT NULL default '0', KEY `A` (`A`,`B`) ) TYPE=InnoDB | ++-- -+ 1 row in set (0.00 sec) # Example 2 - do not give FK name # mysql alter table CONS_CHILD ADD constraint foreign key - ( A, B ) REFERENCES CONS_PARENT(A, B ) ; Query OK, 0 rows affected (0.03 sec) Records: 0 Duplicates: 0 Warnings: 0 mysql show create table CONS_CHILD ; ++-- -+ | Table | Create Table | ++-- -+ | CONS_CHILD | CREATE TABLE `CONS_CHILD` ( `A` int(11) NOT NULL default '0', `B` int(11) NOT NULL default '0', KEY `A` (`A`,`B`), FOREIGN KEY (`A`, `B`) REFERENCES `scott.CONS_PARENT` (`A`, `B`) ) TYPE=InnoDB | ++-- -+ 1 row in set (0.00 sec) Another question. Is there any way to drop FK without DROP TABLE? i.e., is there ALTER TABLE .. DROP CONSTRAINT FOREIGN KEY..? Thanky for your advanced answer! - Original Message - From: Heikki Tuuri [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, September 29, 2002 10:24 PM Subject: Re: Problem on ALTER TABLE ... ADD CONSTRAINT FOREIGN KEY.. Jungsu, - Original Message - From: Heo, Jungsu [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Saturday, September 28, 2002 9:34 AM Subject: Problem on ALTER TABLE ... ADD CONSTRAINT FOREIGN KEY.. Hello. I have a problem on ALTER TABLE ... ADD FOREIGN KEY. I'm using InnoDBs, and I wanna create Foreign Key after table has been created. But, 'ALTER TABLE .. ADD FOREIGN KEY does not work. Manual says : The FOREIGN KEY, CHECK, and REFERENCES clauses don't actually do anything And in my test, 'ALTER ADD FOREIGN KEY' does not create FK. mysql CREATE TABLE `CONS_PARENT` ( - `A` int(11) NOT NULL default '0', - `B` int(11) NOT NULL default '0', - UNIQUE KEY `A` (`A`,`B`) ) Type=InnoDB ; Query OK, 0 rows affected (0.02 sec) mysql CREATE TABLE `CONS_CHILD` ( - `A` int(11) NOT NULL default '0', - `B` int(11) NOT NULL default '0', - KEY `A` (`A`,`B`) - ) TYPE=InnoDB ; Query OK, 0 rows affected (0.05 sec) mysql ALTER TABLE CONS_CHILD ADD CONSTRAINT FOREIGN KEY CONS_CHILD_FK ( A , B ) REFERENCES CONS_PARENT ON DELETE CASCADE ; Query OK, 0 rows affected (0.05 sec) Records: 0 Duplicates: 0 Warnings: 0 # See Below! FK does not EXIST mysql SHOW CREATE TABLE CONS_CHILD ; ++-- -+ | Table | Create Table | ++-- -+ | CONS_CHILD | CREATE TABLE `CONS_CHILD` ( `A` int(11) NOT NULL default '0', `B` int(11) NOT NULL default '0', KEY `A` (`A`,`B`) ) TYPE=InnoDB | ++-- -+ 1 row in set (0.00 sec) the problem above is that the syntax of the ALTER TABLE is wrong for InnoDB. InnoDB uses the syntax of SQL-1992 with the restriction that InnoDB always requires that also the columns in the referenced table are always explicitly named. No name can be given to the foreign key
ANN: DataDiff 0.1.0.
Please accept my apologies for consuming bandwidth with such a blatant plug. I just released a utility that will compare the rows of corresponding tables in two MySQL databases and return any rows which differ. In addition, it can optionally ignore any DATE/TIME/DATETIME/TIMESTAMP columns in comparisons. It's written in Perl and should work with both MySQL 3.23.x and 4.0.x (although it's only been tested on 4.0.2), and is released under the GNU GPL. http://www.mrjoy.com/datadiff.shtml -JF - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
ANN: DataDiff 0.1.0.
Please accept my apologies for consuming bandwidth with such a blatant plug. I just released a utility that will compare the rows of corresponding tables in two MySQL databases and return any rows which differ. In addition, it can optionally ignore any DATE/TIME/DATETIME/TIMESTAMP columns in comparisons. It's written in Perl and should work with both MySQL 3.23.x and 4.0.x (although it's only been tested on 4.0.2), and is released under the GNU GPL. http://www.mrjoy.com/datadiff.shtml -JF (sql, query) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Re: Replication
hi Victoria, The Master's server id is 1 while the slave's server id was set to 5. There is no problem for the slave to establish connection to the master. However, the slave complains that error reading packet from server, the reason is misconfigured-master, server id was not set and this messages keep on repeating. Any idea? Thanks, Chee Peng - Original Message - From: Victoria Reznichenko [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, September 27, 2002 9:16 PM Subject: Re: Re: Replication Hello CP, Friday, September 27, 2002, 3:11:14 AM, you wrote: C hi Victoria, thanks for the reply. I have set server id in the very C beginning, but its still not working. I don't understand why the MySQL would C not let me change its server id accordingly. The server id was set to 1. You must set up unique server-id for the master and for the slave. You said that server-id=1, but it's only one server id, what about another? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
A rookie question
Hello, and apologies for such a novice question... I have a need to find a method to allow a user to update information on members of our organization. The typical number of students' info that needs updated is 50-75. The info to be updated is grade change, and year of Latin change for each student. My initial thought (if I transfer the database to MySQL from FileMaker) is to set up the database as a relational database with students in one table, the schools in a second and the school name being the link. The real question is...if I use PHP to access MySQL, can I allow the user to edit the records (or portion of them) from one Web page with ONE submit button? Is this even possible? I want know I could do this with a submit button for each member, but that would not be too end user friendly! Thanks for putting up with a novice question, and any help you can offer! Paul J. Paul Romanic, R.A. State Chair Ohio Junior Classical League - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Setting Permission For Column Level Only
On Sunday, September 29, 2002, at 10:17 24h, Insanely Great wrote: Greetings... I want to create a user which will have only Select privileges in two columns a particular table. For that I creates a entry in the User table in MySQL and set it as default with N in all. Also I entered some rows in the Columns_Priv table. Now my question is - Do I have to enter records in db and tables_priv table with the user name and all privileges set to N or default to make the column privileges work or if I enter a row in the columns_priv table, that will do. You have to enter data into the tables_priv table, but NOT the db table. I believe all the fields in the tables_priv table need to be filled except Table_priv. -- Clayburn W. Juniel, III -- Effective Software Solutions Phone: (602) 326-7707Mobile: (602)326-7707 Email: [EMAIL PROTECTED] http://EffectiveSoftwareSolutions.com -- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysql server won't keep running
Hi, I am attempting to use mysql 3.23.52 on win2000pro. I have installed it and I believe everything went okay for that. At least I did get any errors. When I open services, mysql is set for automatic but it is not started. When I try to start it, I get an error 1067: the process terminated unexpectedly. I have tried the command line also. I CD to mysql\bin and run mysqld. I don't get any errors. Then I run mysql and get and error 2003: can't connect to mysql server on localhost (10061). Can anyone shed some light on my problem? David Gerler Gerler Enterprises PO Box 16357 Chesapeake VA 23328 (757) 410-0738 http://www.GerlerEnterprises.com/ Nationwide Dial-up from $12.45 /mo. http://www.EasySitesForLess.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql permanent connections
What are the advantages and disadvantages of permanent connections to mysql (using php mysql_pconnect())? I am developing a site where each users session will have a number of interactions with the database from different web pages. Should I use permanent connections? How can I close a permanent connection? (Documentation says mysql_close() does not close permanent connections) Do permanet connections die when the internet connection is broken? Thanks in advance for any help. Regards Peter Goggin - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Japanese Charset
Dawn, I'm going to give in to the temptation to be pedantic. Apologies in advance. Kirk Samuelson wrote: I've read lots of similar posts in the archives at http://lists.mysql.com/. Many suggestions to use a BLOB instead of a text field. But MySQL supports double-byte languages. Why not use an encoding it supports (SJIS or UJIS for Japanese) instead of this kludge? If I compile MySQL to support UJIS with --with-charset=sjis won't text fields then store ujis encoded text properly? I'd like to use Unicode too but if it's not supported yet... The idea is to be able to store Latin and Japanese in the same database (as well as Chinese Korean). Isn't that supported by MySQL? People on this list say they've done it successfully. If I compile MySQL using --with-charset=sjis , how will it handle the Latin, Chinese, and Korean characters? Multiple databases on multiple servers? But you still have the problem of needing to handle the escape characters correctly. (Sorry I wasn't able to get that page up over the weekend.) Go re-read the section of the manual on string literals. Ask yourself what is going to happen when you try to insert the text Our network switches are 100% standard! or You should store your preferences at c:\WINNT\bloopers\prefs.txt in your database. How would you set up the database queries to store those strings? Say, do you want a little utility program in Java or C that will print the hexadecimal values of the characters in a string? Basically, it would be a command-line utility, so you would copy the text and then paste it into the command line, after the name of the utility. You'd need a compiler, of course. -- Joel Rees [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
ÑûÇ뺯
¡îC.KÌåÓýÓéÀÖ»áԱͨѶ¡î ×ð¾´µÄmysql C.KÌåÓýÓéÀÖ¡ª·è¿ñ×ãÇòÍƳö´óÐÍÔÚÏßͶעÓÎÏ·£¬ÊµÊ±Ä£ÄâÑÇÖÞÅÌ¿Ú£¬C.KÌåÓýÊ׽첨ÍõÕù°ÔÈüÀ¿ªÐòÄ»£¬ÄúÏÖÔÚÖ»ÒªÃâ·Ñ×¢²áһϣ¬²Î¼Ó¾ºÈü£¬¾Í¿ÉÒԵõ½±Ê¼Ç±¾µçÄÔ£¬Ð¿îÊÖ»ú£¬ÃûÅÆÔ˶¯±í...¶à¶àÖؽ±£¬µÈÄãÀ´Äã¡ ͬʱ»¹¿ÉÒÔÃâ·Ñ²é¿´Ã¿ÌìËæ»úËͳöµÄ¶à¼ÒÍøÁÏ£¡ÕâÒ»ÇУ¬¶¼ÊÇÃâ·ÑµÄŶ£¡ »¹µÈʲô£¿Á¢¼´À´×¢²á°¡£¡http://www.crazykick.net/ C.KÌåÓýÓéÀÖ»áÔ±·þÎñ×é ÍøÕ¾µØÖ·£ºwww.crazykick.net www.crazykick.com Email:[EMAIL PROTECTED] QQ:59376023 TEL£º021-64601783 FAX£º021-64601783 ʹÓü«ÐÇÓʼþȺ·¢£¬ÎÞÐëͨ¹ýÓʼþ·þÎñÆ÷£¬Ö±´ï¶Ô·½ÓÊÏ䣬ËٶȾø¶ÔÒ»Á÷£¡ ÏÂÔØÍøÖ·£ºhttp://love2net.51.net/£¬¸ü¶àÃâ·ÑµÄ³¬¿áÈí¼þµÈÄãÀ´Ï¡¡ INFORMATION This message has been sent using a trial-run version of the TSmtpRelayServer Delphi Component. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
ÑûÇ뺯
¡îC.KÌåÓýÓéÀÖ»áԱͨѶ¡î ×ð¾´µÄmysql C.KÌåÓýÓéÀÖ¡ª·è¿ñ×ãÇòÍƳö´óÐÍÔÚÏßͶעÓÎÏ·£¬ÊµÊ±Ä£ÄâÑÇÖÞÅÌ¿Ú£¬C.KÌåÓýÊ׽첨ÍõÕù°ÔÈüÀ¿ªÐòÄ»£¬ÄúÏÖÔÚÖ»ÒªÃâ·Ñ×¢²áһϣ¬²Î¼Ó¾ºÈü£¬¾Í¿ÉÒԵõ½±Ê¼Ç±¾µçÄÔ£¬Ð¿îÊÖ»ú£¬ÃûÅÆÔ˶¯±í...¶à¶àÖؽ±£¬µÈÄãÀ´Äã¡ ͬʱ»¹¿ÉÒÔÃâ·Ñ²é¿´Ã¿ÌìËæ»úËͳöµÄ¶à¼ÒÍøÁÏ£¡ÕâÒ»ÇУ¬¶¼ÊÇÃâ·ÑµÄŶ£¡ »¹µÈʲô£¿Á¢¼´À´×¢²á°¡£¡http://www.crazykick.net/ C.KÌåÓýÓéÀÖ»áÔ±·þÎñ×é ÍøÕ¾µØÖ·£ºwww.crazykick.net www.crazykick.com Email:[EMAIL PROTECTED] QQ:59376023 TEL£º021-64601783 FAX£º021-64601783 ʹÓü«ÐÇÓʼþȺ·¢£¬ÎÞÐëͨ¹ýÓʼþ·þÎñÆ÷£¬Ö±´ï¶Ô·½ÓÊÏ䣬ËٶȾø¶ÔÒ»Á÷£¡ ÏÂÔØÍøÖ·£ºhttp://love2net.51.net/£¬¸ü¶àÃâ·ÑµÄ³¬¿áÈí¼þµÈÄãÀ´Ï¡¡ INFORMATION This message has been sent using a trial-run version of the TSmtpRelayServer Delphi Component. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: connecting to mysql via ODBC from asp.net
dear jay fields, pls try this, hope this can help u... dim objconn, objrs set objconn = server.createobject(adodb.connection) set objrs = server.createobject(adodb.recordset) objconn.connectionstring=server=192.168.0.1;driver=MySQL;db=[database_name] ;uid=[user_name];pwd=[user_password] objconn.open connectionstring dim find_text, delete_text, mxopr_cd, deletelog_text mxopr_cd = session(oprcd) find_text = select * from tcity where tcity_code = ' cd ' order by tcity_code asc delete_text = delete from tcity where tcity_code = upper(' cd '); objrs.open find_text, objconn if objrs.eof then objrs.close objconn.close set objrs = nothing set objconn = nothing response.redirect /source/err/err_recnotexist.html else objrs.close objconn.execute delete_text objconn.close set objrs = nothing set objconn = nothing response.redirect /source/city/result_city_dele_ok.html end if cheers, Ivan Paul Web Developer Mediate - Media Communications http://www.bhaktimedia.com - Original Message - From: Jay Fields [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, September 27, 2002 21:35 Subject: connecting to mysql via ODBC from asp.net I've installed the windows version of mysql. I configured nothing. This is the code I'm trying to use to access mysql from an asp web service (in vb): - WebMethod() Public Function dbConnect() As String Dim connString As String = DRIVER={MySQL ODBC 3.51 Driver}; _ SERVER=localhost; _ DATABASE=test; _ UID=test; _ PASSWORD=test; _ OPTION=3 Dim MyConnection As New OdbcConnection(connString) Try MyConnection.Open() MyConnection.Close() Return connString Catch e As Exception Return e.Message End Try End Function -- It's returning the following exception: ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified Any ideas? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: connecting to mysql via ODBC from asp.net
ops, sorry jay, i forgot this... do you install mysql in your web server? if you install it on your web server, so i think you should install the odbc driver for mysql in your web server... and after that u can use your asp script to make connection to your mysql database have a nice try :-) Ivan Paul Web Developer Mediate - Media Communications http://www.bhaktimedia.com - Original Message - From: Jay Fields [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, September 27, 2002 21:35 Subject: connecting to mysql via ODBC from asp.net I've installed the windows version of mysql. I configured nothing. This is the code I'm trying to use to access mysql from an asp web service (in vb): - WebMethod() Public Function dbConnect() As String Dim connString As String = DRIVER={MySQL ODBC 3.51 Driver}; _ SERVER=localhost; _ DATABASE=test; _ UID=test; _ PASSWORD=test; _ OPTION=3 Dim MyConnection As New OdbcConnection(connString) Try MyConnection.Open() MyConnection.Close() Return connString Catch e As Exception Return e.Message End Try End Function -- It's returning the following exception: ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified Any ideas? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Setting Permission For Column Level Only
Thx Well I have one more question What is the exact GRANT SQL statement for giving column level privilege. Whatever text I have read till now allow me to give table level privilege. I am unable to give a column level privilege. I have a db..product with tables prod_user and prod_detialsprod_user has three columns id, name, address. I want to give a user permission for select only on id, name and not on address ? Any ideas ? Insane SQLyog ( http://www.webyog.com/sqlyog ) The Definative Front End for MySQL - Original Message - From: Clayburn W. Juniel, III [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, September 30, 2002 7:00 AM Subject: Re: Setting Permission For Column Level Only On Sunday, September 29, 2002, at 10:17 24h, Insanely Great wrote: Greetings... I want to create a user which will have only Select privileges in two columns a particular table. For that I creates a entry in the User table in MySQL and set it as default with N in all. Also I entered some rows in the Columns_Priv table. Now my question is - Do I have to enter records in db and tables_priv table with the user name and all privileges set to N or default to make the column privileges work or if I enter a row in the columns_priv table, that will do. You have to enter data into the tables_priv table, but NOT the db table. I believe all the fields in the tables_priv table need to be filled except Table_priv. -- Clayburn W. Juniel, III -- Effective Software Solutions Phone: (602) 326-7707Mobile: (602)326-7707 Email: [EMAIL PROTECTED] http://EffectiveSoftwareSolutions.com -- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Setting Permission For Column Level Only
On Sunday, September 29, 2002, at 09:21 24h, Insanely Great wrote: Thx Well I have one more question What is the exact GRANT SQL statement for giving column level privilege. Whatever text I have read till now allow me to give table level privilege. I am unable to give a column level privilege. Grant Select (colum_name1), Select (Column_name2) on database_name.table_name to whoever@% identified by 'password' -- Clayburn W. Juniel, III -- Effective Software Solutions Phone: (602) 326-7707Mobile: (602)326-7707 Email: [EMAIL PROTECTED] http://EffectiveSoftwareSolutions.com -- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
InnoDb Question
I am new to InnoDb and was wondering what steps I would have to do to restore a table. Lets assume I am backing up the data by backing up the tablespaces. Thanks in advance (MySQL, query) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: export to .sql to other SQL platforms
I repeat my question to a diferent form : how is possible to export my MySQL data to a diferent SQL form? Makis -Original Message- From: Savaidis [mailto:[EMAIL PROTECTED]] Sent: Friday, September 27, 2002 1:38 PM To: [EMAIL PROTECTED] Subject: export to .sql to other SQL platforms I tried to import an .sql file from MySQL table (str+data) to interbase and I encountered many errors . Is there any utility to convert this .sql from MySQL to .sql suitable to feed SQL servers like interbase ecc? (these errors are : no quots to field names, no 'binary' , no int(3) but int no 'key' keyword ecc) Thanks Makis - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php