មាតិកា សេចក្តីផ្តើម គោលបំណង តម្រូវការ ការបង្កើត Database Syntax ក្នុងការសរសេរ Cursor របៀបសរសេរនិងប្រើប្រាស់ Cursors ឯកសារយោង.. 1. សេចក្តីផ្តើម Cursor គឺជាdatabase object មួយ ដែលអនុញ្ញាតអោយយើងអាច Process នូវ row របស់ Data នីមួយៗ។ ខាងក្រោមនេះគឺជា Basic ក្នុងការបង្កើត Cursor និងរបៀបក្នុងការសរសេរព្រមទាំងហៅ cursor មកប្រើតែប៉ុណ្ណោះ។ 2. គោលបំណង ក្រោយពីសិក្សាតាម Tutorial នេះ លោកអ្នកនឹងយល់អំពី ចេះបង្កើត Database ចេះបង្កើត Table ចេះសរសេរ Script ដើម្បី Insert data របៀបប្រើប្រាស់ cursor នៅក្នុង SQL Server ដឹងពី Syntax ក្នុងការសរសេរ…
Category: Database
Categories
SQL: Insert Statement with Examples
Another technique beside selection queries in previous post, here are some of the insertion statement with example using MS SQL syntax that may help you to get understand clearer. Insert Statement –Subqueries help in situations when its not easy to express –all the rows that need to be selected …… especially for –INSERTS, UPDATES and…
Categories
Basic SQL Statements with Example
SQL or T-SQL Statement/syntax are quite important for the database developer, here are some selected basic statements with example using SQL Server that may help you to get started with sql query. Basic SELECT statement, * means all columns SELECT * FROM Customers Basic SELECT statement, specifying which columns to display SELECT FirstName, LastName FROM…
Categories
Import file size limit in PHPMyAdmin
Performance tuning is very important and there are still a lot of question around, here our tips to help base on our experience. Import file size limit in PHPMyAdmin For uploading large files through PHPMyAdmin, follow these steps: Step 1: Open your php.ini file. Step 2: Upgrading Memory Limit: memory_limit = 750M Step 3: Upgrading…
On My SQL Workbench 5.x or 6.x, to manage the administration stuff such as import/export. Somehow, you could face an error when click on those admin tool: Current Profile Has no WMI enable Solution To solve this, it’s simply : On MySQL Workbench: Server Administration (on the right column) Click Manage Server Instances Select…
pgAdmin 4 is a new version of PostgreSQL administration tool. It’s interface looks so cool and of course, more features would come with that. Any way, here is the first error I faced and I think people might need to know it when such as we try to backup/restore from the pgAdmin 4 (rc1) received…
In case, you have executed some request as following example UPDATE `td_invoice_zzz` zi, ts_zone zo SET `zzz_com_zon_id` = zo.zon_id WHERE zzz_com_zon_code = zo.zon_code; And you receive the error about illegal mix of collations as: Error Code: 1267. Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '=' You are trying to compare two fields that…
I posted some posts about drupal since I started to implement things with drupal. Issue with “Maximum execution time“ Issue with “MySQL server has gone away“ And still with memory “The InnoDB memory heap“ Here is my own recommendation for Drupal or some heavy PHP/MySQL application. php.ini max_execution_time=5000 memory_limit=1024M my.ini [mysqld] max_allowed_packet = 128m sort_buffer_size…
Categories
MySQL: The InnoDB memory heap is disabled
When you start your MySQL server, check in the log, you might found this warning message: [Note] InnoDB: The InnoDB memory heap is disabled The memory heap is related to performance of the MySQL with engine of InnoDB Solutions The issue would be solved by provide the setting in my.cnf/my.ini as [mysqld] # Comment the…
MySQL server has gone away, issue on drupal, drupal ecommerce kickstart gives me alot of headache since I do not first aware that the issue because of there are so many packets execution on mysql with drupal. The full error is (or similar): Additional uncaught exception thrown while handling exception. Original PDOException: SQLSTATE[HY000]: General error:…