MYSQL COMMANDS AND USE
PHP 4 version of the mysql commands and short descriptions
PHP 4 version of MySQL, and short descriptions of all commands that can be used for communication.
mysql_affected_rows
The number of rows affected by a previous transaction.
mysql_close
Closes the specified mysql connection.
mysql_connect
Opens a database connection to the server.
mysql_create_db
Opens in MySQL database.
mysql_data_seek
The result is the order line.
mysql_db_query
Sends the query to MySQL.
mysql_drop_db
Deletes the database server.
mysql_errno
MySQL gives the error number in the previous process.
mysql_error
MySQL gives the error message, the previous process.
mysql_fetch_array
The results of the array variable is.
mysql_fetch_field
As a result, the table is the name of the object.
mysql_fetch_lenghts
The result is the length of the array variable table.
mysql_fetch_object
Gets a result row as an object.
mysql_fetch_row
Variable table, you get a result.
mysql_field_name
The result of the name of the table gives the result table.
mysql_field_seek
Index that takes place as a result table.
mysql_field_table
The domain name of the table gives the result.
mysql_field_type
The resulting field indicates what type.
mysql_field_flags
The resulting space is defined which specifies the type of extra parameters.
mysql_field_len
Field gives the length of the resulting database.
mysql_free_result
Frees the memory assigned to the results.
mysql_insert_id
Returns the value of the automated data placement to the previous data.
mysql_list_fields
The resulting lists of all the table fields.
mysql_list_dbs
Lists all the databases on the server.
mysql_list_tables
Lists all the tables in the database.
mysql_num_fields
The resulting field gives the number.
mysql_num_rows
Returns the number of rows in result.
mysql_pconnect
Defines a permanent connection to the server.
mysql_query
Sends the query to the database.
mysql_result
The results of the query are returned.
mysql_select_db
Select from the server database.
mysql_tablename
To belong to the given name of the table gives the area.
SQL COMMANDS
Database Created
Database_ismi CREATE DATABASE;
EX: CREATE DATABASE, Mersin;
Created in the database table
CREATE TABLE database_ismi;
EX: CREATE DATABASE students;
Adding Data to SQL in the command
INSERT INTO table_name VALUES (‘Data1’, ‘veri2’, ‘veri3’,…..);
Crafts table command to add a new profession
EX: INSERT INTO jobs VALUES (’11 ‘,’ Teacher ‘, ’12’, ’20 ‘);
eg: INSERT INTO Students VALUES (23, ‘Length’, ‘GULER’);
Getting Data from the table command (list command)
SELECT kolon1, kolon2, kolon3 colony …. FROM table_name;
SELECT * FROM table_name (to take all);
eg: SELECT id, kayitno FROM Students;
eg: SELECT id, meslekno, meslekismi, girissaati, cikissaati FROM professions;
eg: SELECT name, surname, address FROM staff;
Ranking of the captured data from a table
ORDER BY domain, ASC; (ASC)
Domain, an ORDER BY DESC; (DESC)
EX: SELECT id, meslekno, meslekismi, girissaati, cikissaati FROM jobs ORDER BY ASC meslekismi;
EX: SELECT id, meslekno, meslekismi, girissaati, cikissaati FROM jobs ORDER BY DESC meslekismi;
Dates of birth of the same name, last name, sorted according to the shape of a data
eg: SELECT id, name, last name, dtarihi DTARİH FROM staff ORDER BY DESC, name, surname, ASC;
Any SQL command that operate according to a Contingent (Required Instruction)
WHERE condition şart_alanı şart_ifadesi (=,<,>)
eg: SELECT id, name, last name, dtarihi FROM staff WHERE name = ‘bob’;
eg: SELECT id, name, last name, dtarihi FROM staff WHERE dtarihi <’01 .01.1967 ‘ORDER BY DESC BASE;
TABLE
id name salary meslekid meslekadi address Sayad dtarihi Dyer
eg: SELECT id, name, Sayad, dtarihi, salaries, meslekid, meslekadi the address s, Dyer Dyer FROM WHERE costs plus = ‘London’;
eg: SELECT id, name, Sayad, dtarihi, salaries, meslekid, meslekadi the address s, Dyer FROM WHERE salary costs plus> 300 ORDER BY salary DESC;
eg: SELECT id, name, Sayad, dtarihi, salaries, meslekid, meslekadi the address s, Dyer Dyer FROM WHERE costs plus = ‘London’ AND meslekadi = ‘doctor’ ORDER BY NAME ASC;
eg: SELECT id, name, Sayad, dtarihi, salaries, meslekid, meslekadi the address s, Dyer FROM WHERE salary costs plus <250 OR meslekadi = ‘servant’ ORDER BY NAME ASC;
Between the two Vari Processing Command
bakilacak_alan BETWEEN value1 AND value2
eg: SELECT id, name, Sayad, dtarihi, salaries, meslekid, meslekadi the address s, Dyer FROM WHERE salary costs plus BETWEEN 200 AND 300 ORDER BY NAME, LASTNAME DESC;
eg: SELECT id, name, Sayad, dtarihi, salaries, meslekid, meslekadi the address s, Dyer FROM WHERE costs plus dtarihi BETWEEN ’06 .05.1989 ‘AND ’01 .01.2000’;
IN COMMAND
bakilacak_alan IN (value1, value2, …., the value of value)
teknikservis IT purchase accounting
eg: SELECT * FROM WHERE meslekadi costs plus IN (‘IT’, ‘accounting’, ‘purchase’, ‘teknkservi s’)
eg: SELECT * FROM WHERE costs plus meslekadi = ‘IT’ OR meslekadi = ‘accounting’ OR meslekadi = ‘purchase’ OR meslekadi = ‘teknkservis’;
Search within the command
LIKE bakilacak_alan bakilacak_deger note (not important where the bay%)
eg: SELECT * FROM WHERE ıcretler address LIKE ‘% host%’
eg: SELECT * FROM WHERE ıcretler address LIKE ‘% Turkey’
Relational Tables
personnel
id, name, surname, address, birthplace, sicilno, isebaslama, with sex, medenidurumu, dtarih
costs plus
id, per_sicil_no, aylikucret, sigortaprimi, yemekyardi, yakityardimi
==========================================
eg: SELECT name, surname, aylikucret FROM staff, fees WHERE sicilno = per_sicil_no;
eg: SELECT name, last name, salary FROM staff, fees sicilno = per_sicil_no AND WHERE Birthplace = ‘London’ AND address LIKE ‘% istanbul’;
ie: more than 300 salary and insurance of the underlying
SELECT name, surname, sigortapirimi FROM staff, fees AND WHERE per_sicil_no aylikucret sicilno => 300 AND sigortaprimi> 0;
eg: for 15 years, the employee’s salary under 200 YTL firstname.lastname yenimahallede based staff, and address lists pprogram
SELECT name, surname, address FROM staff, fees sicilno = per_sicil_no AND WHERE aylikucret <200 AND address LIKE ‘% host%’ AND isebaslama BETWEEN (’07 .05.1991 ‘AND ’06 .05.1992’);
EX: NAME AND E accounting and computing unmarried women 30 years of age working in any of buying a small salary that more than 100 YTL
SELECT * FROM staff, fees
WHERE sicilno = per_sicil_no
AND meslekadi = ‘accounting’ OR meslekadi = ‘IT’ OR meslekadi = ‘purchase’
AND name LIKE ‘E%’ AND sex = ‘Sex’
AND medenidurumu = ‘single’
AND dtarih> ’01 .011977 ‘
AND aylikucret> 100;
Data Delete command from the table
DELETE FROM table_name WHERE condition
DELETE FROM wages, staff WHERE AND aylikucret per_sicil_no sicilno = <100;
eg registration number 123 that deletes the record from the database program
DELETE FROM wages, staff WHERE per_sicil_no = ‘123 ‘AND sicilno = ‘123’;
Data update command
UPDATE table_name SET value1 = domain1, domain2 = value2 … FieldName = value;
A neighborhood W of the street address of 123 registration number of the personnel of Ankara Yenimahalle
UPDATE staff SET address = ‘A street Yenimahalle Ankara neighborhood W’ WHERE sicilno = ‘123 ‘;
Costs plus aylikucret * UPDATE SET aylikucret = 1.2;
UPDATE wages, staff SET ylikucret = aylikucret-100 WHERE meslekadi = ‘IT’ AND sicilno = per_sicil_no;
Grouping Commands
The largest command:
SELECT MAX (field_name) FROM table_name
the maximum salary of the staff:
SELECT MAX (aylikucret) FROM costs plus
ie, the more fuel-assistance program, showing the salary of the staff and the registration number
SELECT aylikucret, per_sicil_no, MAX (yakityardimi) FROM costs plus
Least-Command:
SELECT MIN (field_name) FROM table_name
TOTAL ACQUISITION COMMAND:
SELECT SUM (field_name) FROM table_name
the total fuel subsidy:
SELECT SUM (yakityardimi) FROM Fees;
Average command:
SELECT AVG (field_name) FROM table_name
SELECT AVG (aylikucret) FROM wages, staff WHERE meslekadi = ‘IT’;
SELECT AVG (yakiyyardimi) FROM wages, staff WHERE meslekadi = ‘accounting’ AND gender = ‘Female’;
RECORD NUMBER OF COMMAND
SELECT COUNT (*) FROM table_name
SELECT COUNT (*) FROM staff;
SINGLE RECORD NUMBER OF COMMAND
SELECT COUNT (Distict field_name) FROM table_name
There are many different family group working with us
SELECT COUNT (Distict Sayad) FROM staff
Our company has several different departments.
SELECT COUNT (Distict meslekadi) FROM staff