The DELETE command is used to remove rows from a table. A WHERE clause can be used to only remove some rows. If no WHERE condition is specified, all rows will be removed. After performing a DELETE operation you need to
COMMIT or ROLLBACK the transaction to make the change permanent or to undo it.
TRUNCATE removes all rows from a table. The operation cannot be rolled back. As such, TRUCATE is faster and doesn’t use as much undo space as a DELETE.
The DROP command removes a table from the database. All the tables’ rows, indexes and privileges will also be removed. The operation cannot be rolled back.
- What is PHP ?
- What is the difference between PHP session and cookie?
- How can we create a file using php script ?
- How can we change the first letters to capital letter of “first name” and “last name” from single name string using PHP ?
- What is the differences between GET and POST methods ?
- What is the differences between require() and include() in PHP ? )
- What is the use of header() function in php ?
- What is the use of htaccess?
- What is the difference Between array_merge() and array_combine()
- What is the default time of a user session in php ?
- How do I remove the first element from an array? Please write a piece of code.
- I want to invert my array, can I do this? If Yes then please write a piece of code.
- How to find Browsers information in PHP?
- How to give permissions for files in php?
- What’s the default port for MySQL Server?
- What is hook [WordPress] ?
- What is DDL, DML and DCL?
- What is the difference between inner, outer, left and right joins?
- What is the use of ob_start()?
- What is the difference between COPY and MOVE_UPLOAD_FILE function in php?
- Which is the configuration file of php?
- Which is the configuration file of Apache?
- What is magic methods in php?
- What is stored procedure?
- What is the difference between Drop,Delete and Truncate?
- What is PHP ini_set() ?
- What is the difference between GROUP bY and ORDER BY?
- What is the difference between primary and unique key?
- What does a special set of tags do in PHP?
- What’s the difference between include and require?
- I am trying to assign a variable the value of 0123, but it keeps coming up with a different number, what’s the problem?
- May I use print “$a dollars” or “{$a} dollars” to print out the amount of dollars in this example?
- How do you define a constant?
- How do you pass a variable by value?
- When are you supposed to use endif to end the conditional statement?
- Explain the ternary conditional operator in PHP?
- How do I find out the number of parameters passed into function?
- What’s the difference between accessing a class method via -> and via ::?
- What’s the special meaning of __sleep and __wakeup?
- Would you initialize your strings with single quotes or double quotes?
- How come the code works, but doesn’t for two-dimensional array of mine?
- What’s the difference between htmlentities() and htmlspecialchars()?
- What’s the difference between md5(), crc32() and sha1() crypto on PHP?
- What is meant by PEAR in php?
- How can we repair a MySQL table?
- What is the difference between $message and $$message?
- What is the difference between urlencode and urldecode in php ?
- How to get the uploaded file Information in the receiving Script?
- How can I execute a PHP script using command line?
- What are the different tables present in MySQL? Which type of table is generated when we are creating a table in the following syntax: create table employee(eno int(2),ename varchar(10))?
- how to create a table in mysql using php
- How do you pass a variable by value?
- What is the functionality of the functions STRSTR() and STRISTR()?
- What is the difference between ereg_replace() and eregi_replace()?
- How do I find out the number of parameters passed into function. ?
- What is the purpose of the following files having extensions: frm, myd, and myi? What these files contain?
- what are the different types of errors in php?
- What is the difference between the functions unlink and unset?
- What is the difference between characters \023 and \x23?
- How can we create a database using PHP and mysql?
- For printing out strings, there are echo, print and printf. Explain the differences.
- I am writing an application in PHP that outputs a printable version of driving directions. It contains some long sentences, and I am a neat freak, and would like to make sure that no line exceeds 50 characters. How do I accomplish that with PHP?
- What’s the output of the ucwords function in this example?
- How can we destroy the session, how can we unset the variable of a session?
- What are the different functions in sorting an array?
- How can we know the count/number of elements of an array?
- How many ways we can pass the variable through the navigation between the pages?
- What is the maximum length of a table name, a database name, or a field name in MySQL?
- How many values can the SET function of MySQL take?
- What are the other commands to know the structure of a table using MySQL commands except EXPLAIN command?
- How can we find the number of rows in a table using MySQL?
- How can we find the number of rows in a result set using PHP?
- How many ways we can we find the current date using MySQL?
- Give the syntax of GRANT commands?
- Give the syntax of REVOKE commands?
- What is the difference between CHAR and VARCHAR data types?
- How can we encrypt and decrypt a data present in a mysql table using mysql?
- What is the functionality of MD5 function in PHP?
- How can I load data from a text file into a table?
- How can we know the number of days between two given dates using MySQL?
- How can we change the name of a column of a table?
- What is meant by MIME?
- What are the differences between mysql_fetch_array(), mysql_fetch_object(), mysql_fetch_row()?
- If we login more than one browser windows at the same time with same user and after that we close one window, then is the session is exist to other windows or not? And if yes then why? If no then why?
- What are the MySQL database files stored in system ?
- What is the difference between PHP4 and PHP5?
- Can we use include(abc.php) two times in a PHP page bcd.php”?
- What is meant by nl2br()?
- How can I retrieve values from one database server and store them in other database server using PHP?
- In how many ways we can retrieve data in the result set of MYSQL using PHP?
- What are the encryption functions in PHP?
- How can we get the properties (size, width, height) of an image using php image functions?
- How can we increase the execution time of a php script?
- How to set cookie in php ?
- How to reset/destroy a cookie ?
- How can we find in which image types are supported by the current PHP installation ?
- How many ways can we get the value of current session id?
- What are the reasons for selecting LAMP (Linux, Apache, MySQL, Php) instead of combination of other software programs, servers and operating systems?
- What are the features and advantages of Object oriented programming?
- How can we get second of the current time using date function?
- What are the advantages of stored procedures, triggers, indexes?
- What is the maximum size of a database in mysql ?
- Explain normalization concept?
- What type of inheritance that php supports?
- How can we increase the performance of MySQL select query?
- How can we change the name of a column of a table?
- When viewing an HTML page in a Browser, the Browser often keeps this page in its cache. What can be possible advantages/disadvantages of page caching? How can you prevent caching of a certain page (please give several alternate solutions)?
- What are the different ways to login to a remote server? Explain the means, advantages and disadvantages?
- How many ways we can give the output to a browser?
- What is the default session time in php and how can I change it?
- Steps for the payment gateway processing?
- How can we redirect a PHP page?
- List out different arguments in PHP header function?
- What type of headers have to be added in the mail function to attach a file?
- What is the difference between Reply-to and Return-path in the headers of a mail function?
- How to store the uploaded file to the final location?
- What is type juggling in php?
- What is the difference between array_merge and array_combine ?
- Who is the father of PHP ?
- What is the difference between unset() and unlink() in PHP ?
- How can we declare cookie in PHP and then how can we expire it ?
- What is the use of var_dump in PHP ?
- What is str_replace()
- What is Final Keyword in PHP ?
- What is difference between abstract class and interface ?
- What is difference between die(); and exit(); in PHP
- What is the difference between explode (); and split(); methods ?
- How to get the two max salary of an organization using MySQL Query ?
- What is difference between single quotes and double quotes in php ?
- How to get the student name got maximum marks in a class?
- Is PHP an interpreted language or compiler language ?
- What is the difference between compiler language and interpreted language ?
- What is difference between TRUNCATE and DELETE in mysql ?
- What is MYSQL storage engines ?
- What is array_multisort() in PHP ?
- How can we get the first element of an array in php ?
- What is end function in php ?
- Why we use strpos() in PHP ?
- What is difference between mysql_connect() and mysql_pconnect() ?
- How to get the number of elements in an array using PHP ?
- Why we use str_split function in PHP ?
- What is the use of array_slice() in PHP ?
- What things we keep in mind to write an optimize MySQL Query ?
- How can we get all the properties of browser in PHP
- How to read the contents of a file in PHP ?
- How can we change the time zones using PHP ?
- How can we destroy a session in PHP ?
- What is PHP filter ?
- What is the use of error_reporting(-1); ?
- How we can create a zip file using PHP ?
- What purpose we using $_SERVER[‘SCRIPT_FILENAME’] ?
- What is the use of ob_start() in PHP ?
- What is the use of “echo” in PHP?
- How to include a file to a PHP page?
- How to declare an array in PHP?
- What is the use of ‘print’ in php?
- What is use of in_array() function in PHP ?
- How to create a mysql connection in PHP ?
- How to select a database in PHP ?
- What is PEAR in PHP ?
- How to find the position of the first occurrence of a substring in a string using PHP ?
- What is sql injection ? Please explain it.
- How to delete a file from the system using PHP ?
- What is the use of the function htmlentities in PHP ?
- Is it possible to decrypt md5 hashes in PHP ?
- What is the difference between $var and $$var?
- What is the use of “ksort” in php?
- User has defined an array with $arr[0]=0, $arr[1]=1, $arr[2]=2 and $arr[true]=3 then what is the result of $arr[1] ?
