MySQL

The most popular open-source database that is currently available is mySql, made by the company of the same name. It is free to download so the therer is not cost involved and is used across the globe by numerous commercial companies.

yes

A char is a time, a turn or an occasion, an odd job, or a woman employed to do housework.

You have several options:

* copy the database files from mysql/data/<database_name> to a new mysql Installation

* use mysqldump utility to export the data from your database and load it into the new mysql installation

* setup replication

This can be done with any Database system as the clever part is within the PHP.

There are two ways of doing this. The first method is having each record as a new selection. The second is having one field of the selection.

I'm going to use 'DATABASE {' and '} DATABASE' in order to show you where to put your 'Database {' and your closing '}' for the query.

Each Record

Assuming that you have at least two fields. One called value one called text then the following would work. (If your value is always the same as the Text shown to the user then you can change the set of text to value)

Echo '<select name="myselect">';

#DATABASE {

$current_value = $DATABASE['value'];

$current_text = $DATABASE['text'];

$myarray[] = '<option value="' . $current_value . '">' . $current_text . '</option>'; #A*

} DATABASE

Foreach($myarray as $key => $value){

Echo $value;

}

Echo '</select>';

Of course in this method you do not require an array as such. Due to the fact that on line A* could echo the value there and then.

One Field

This would be used more in the cases in which the table is built for forms and works like a Content Management System (CMS).

Firstly set out your record contents as: (I'm assuming here that the field is called dropdown)

I am a value[nowtext]I am some text[nextopt]I am a second Value[nowtext]I am some more text

Now let me explain. If you split this up in to [nextopt] there are two options. If you then split each again by [nowtext] you'll find 2 in between the [nextopt].

In this case, the first item set is the value of the Dropdown. The second is then the text and is split using [nowtext].

There are two functions in PHP which will help us. The first is called explode(); and this works like myfeild.split(); in Javascript. The second is implode();. Explode() is making an array. Think of it as, Explode the information into smaller chunks. Implode is the opposite, this takes an Array and turns it in to a String. (I've added two links to W3schools for reference on these tags)

Fairly simple when you understand how they work. Here's an example:

Echo '<select name="myselect">';

#Database {

$current_dropdown = $DATABASE['dropdown'];

$dropdown_array_a = explode('[nextopt]',$current_dropdown); #Makes an array

Foreach($dropdown_array_a as $key => $value){ #Runs for each item in array and loads in the key and the value of the array.

$dropdown_array_b = explode('[nowtext]',$value

Echo '<option value="' . $dropdown_array_b[0] . '">' . $dropdown_array_b[1] . '</option>';

}

# } DATABASE

Echo '</select>';

That was two of the many ways to perform this task. A link to the reference of Explode, Implode, Arrays and Foreach has been added to the Question.

Here is a simple script that you can do to run a MySQL query after you have set a database up.

<?php

// Database Settings

$db['hostname'] = "localhost";

$db['username'] = "<db username>";

$db['password'] = "<db password>";

$db['database'] = "<db name>";

// Connect to MySQL

$connect = mysql_connect($db['hostname'], $db['username'], $db['password']);

// Select Database

mysql_select_db($db['database'], $connect);

// Do MySQL Query

mysql_query("INSERT INTO table_name SET field_name = '1234567890'");

// Close MySQL

mysql_close($connect);

?>

Obviously you will need to use your own MySQL settings and database details, but this gives you a general overview of how you can do it.

In MySQL, "unsigned" is a data type. When we put an unsigned in a column, it says you can't put negative integers in there. With unsigned int, the maximum range is 4294967295. Note: Inserting a negative value will result in a MySQL error.

To learn more about data science please visit- Learnbay.co

Unless you want to drop (delete) the entire database, you will must delete tables individually.

To delete tables individually, execute the query "SHOW TABLES" in your database which will return a list of all table names. Iterate through that resultset and execute "DROP TABLE {$table_name}"

SELECT char_length (...) FROM ...

There are two types of End user
1.Native User
2.Sophisticated User (Technical User)

employee management system bhaneko management of employee

No they can not

is called specialization and generalization.

Yes

You would need to go to their website intro page for more information.

My ISP is comcast so I don't know if you get a different page if you're not (i.e. the page I see has a 'start now' button).

If not, try searching for "comcast personal web host" and you will get the link I used before being redirected to the above page.

Ypu can use file handling function to read XML

file_get_contents()

file()

fopen()

Use SimpleXML Library

simplexml_load_string - Interprets a string of XML into an object

simplexml_load_file - Interprets an XML file into an object

key picture

An entity set that does not possess sufficient attributes to form a primary key is called a weak entity set. One that does have a primary key is called a strong entity set.

The discriminator (or partial key) of a weak entity set is the set of attributes that distinguishes among all the entities of a weak entity set

The existence of a weak entity set depends on the existence of a identifying entity set. It must relate to the identifying entity set via a total, one-to-many relationship set from the identifying to the weak entity set

We depict a weak entity set by double rectangles in E-R diagram. We underline the discriminator of a weak entity set with a dashed line in E-R diagram.

How do you validate and retrieve data from database?" How do you validate and retrieve data from database?"

· Data duplication can be occurred by repeating the same thing over and over.

· Lack of security

· Lack of storage common errors.

· Too much paper wastage.Paper takes up a massive amount of room in the site. If a computer system was bought the paper could all go and there would lots more free space which could be used for other purposes.

· Poor Data Storage - All the data is stored in filing cabinets. Data could be misplaced due to human error. Data could be stolen very easily.

· Unavailability of Information

· Slow Retrieval of Data - The information is stored in different parts and takes a long time to retrieve the data.

· In a manual library system if you are not able to find a book of your choice have to spend a lot of time and effort in trying to find a particular book.

· Manual systems are also slow to operate. Instead of using a computer to issue and take back books, locating and updating a card index is slow and laborious

· With manual systems staff spends a lot of their time on mechanical, clerical tasks rather than liaising with library visitors.

· Librarians find it difficult to offer a wider range of new services with a manual library system. For example, a library can put its catalog on the Web allowing readers to access it remotely; with a manual system members have to visit or telephone the library to find this information.

· Not more than one person can access data at the same time but in Computerized Information system many people can access the same data on the same time through networking.

· Time consuming

· It results in need of lot of space to keep the data.

· Possibility of data duplication as there's no repetition check like in computer software's e.g. Microsoft Access.

· Often the books are lost and the librarian is not aware of this.

· No proper records for the workers, members and books transaction.

· If manual record book is lost data will be completely lost.

· Lots of Manual labor is required for record keeping.

· Many a times duplication occurs as workers are find it hard to keep track in the bundles of registers.

· Data is not always reliable as it is hand written and some human errors might have occurred example wrong telephone number.

It's picking up an old password from c:\documents and settings\all users\application data\mysql

This may be a hidden folder...unhide it..

The uninstall doesn't remove this directory. Your old password is there, so if you want to re-install w/ a new password, you either need to reset or remove this data directory)

1.what cursor type do you use to retrieve multiple recordsets?

2.What are two methods of retrieving SQL?