Jijo K Jose

Personal Website

Author Archive

May 30th, 2020

Database, MYSQL

No Comments »

How to convert MySQL to MySQLi procedural methods

These are nothing but the APIs of PHP that is used to access the MySQL databases and tables. The developers can choose either one of them for their project, however, the use of MySQL extension is deprecated and will not be available in future versions. It is recommended to use the MySQLi extension with PHP 5.5 and above.

Let’s have some more information about each of them:

MySQL: This was the main extension that was designed to help PHP applications send and receive data from the MySQL database. However, the use of MySQL has been deprecated and removed as of PHP 7 and its newer versions. This is why it is not recommended for new projects, and that’s the reason why MySQLi extensions are used more nowadays.
MySQLi: The ‘i’ in MySQLi stands for Improved. Therefore, this is also known as the improved version of MySQL. It has many useful features.

An Object-oriented interface
Support for prepared statements
Support for multiple statements
Support for transactions
Enhanced debugging capabilities
Embedded server support.

Create a shortcut to open an FTP site in Windows Explorer

Open My Computer by clicking the Start button, and then clicking Computer.
Right-click anywhere in the folder, and then click Add a Network Location.
This displays the Add Network Connection wizard. Click Next.
In the wizard, select Choose a custom network location, and then click Next.
Enter the name of the FTP site, with the full FTP:// in front of it, and then click Next.
To use a name and password, clear the Log on anonymously check box. Type a user name, and then click Next.
By default, the name of the shortcut is the same as the FTP address. If you want to give the shortcut a different name, type it in the Type a name for this network location box. Click Next.
If you do not want the FTP site to open after you're done setting up the shortcut, clear the Open this network location when I click Finish check box. Click Finish. A shortcut to the FTP site appears in the Computer folder. You can drag that shortcut to your desktop so that it's easy to find later.

DROP multiple TABLE / TRIGGER / FUNCTON in oracle using PL SQL

To drop more than one tables having a matching criteria then we should use a PL SQL statement, in oracle there is a table called USER_OBJECTS having name of all the tables for that particular user.

DROP TABLE is a DDL statement so that we need EXECUTE IMMEDIATE privilege for dropping table from a script, more easy way to drop table is to generate DROP TABLE command using a script and run that command.

The following PL SQL script generate drop table command for all tables having table name contains word 'test'

SET SERVEROUTPUT ON;

DECLARE
object_name varchar2(100);
cursor cur1 is SELECT object_name FROM user_objects WHERE object_type='TABLE' AND object_name LIKE '%test%';
BEGIN

open cur1;
loop
       fetch cur1 into object_name;
       exit when cur1%notfound;
      dbms_output.put_line('DROP TABLE ' || object_name || ';' );
   end loop;
   close cur1;

END ;

Output

anonymous block completed

DROP TABLE USER_TEST;

S	M	T	W	T	F	S
1	2	3	4	5	6	7
8	9	10	11	12	13	14
15	16	17	18	19	20	21
22	23	24	25	26	27	28
29	30	31

Jijo K Jose

Personal Website

Author Archive

How to convert MySQL to MySQLi procedural methods

Create a shortcut to open an FTP site in Windows Explorer

DROP multiple TABLE / TRIGGER / FUNCTON in oracle using PL SQL

Calendar

Categories

Archives

Login