Here is more from Anatoliy's Mysql Cheatsheet
- Add a column column_name to table table_name
- > alter table table_name add column_name column_type
- Modify column
- > alter table table_name modify column_name int unsigned NOT NULL auto_increment; > alter table comments change date date datetime;
- Delete column
- > alter table table_name drop column_name;
- Rename a column
- > alter table table_name change column_old_name column_new_name tinyint(3) unsigned;
- Add column as key index
- > alter table table_name add key(column_nam
- Set auto_increment for column column_name:
- > alter table table_name add key(column_name); > alter table table_name modify column_name int unsigned NOT NULL auto_increment;
- Set a column as primary key:
- alter table table_name add primary key(column_name);
- Inner join* with cartesian effect elimination
- > select * from table_name1, table_name2 where table_name1.column = table_name2.column; *inner join – only the entries which exist in both tables are included in the resulting table.
- Left (outer) join*
- > select * from table1 left outer join table2 ON table1.column = table2.column; *Left join – includes ALL the table entries in the left tables and then matches entries in the right table if they exist. An INNER JOIN will retrieve all records from both tables that have matching values for whatever column you're joining them on. Records from either table that don't match will not be retrieved. A LEFT JOIN will retrieve all records from the left (first) table, and only the records from the second table with matching values for the joining column, filling in any empty spaces with NULL values.
- Group by – sampling of results and getting the first result out of several repeating.
- DISTINCT ensures that only unique column values will be shown.
- WHERE cannot be used with a group column function, like count(). In such cases HAVING should be used. Example:
- > select tc.chapter,tc.chapter_name,count(ct.topic) from table_of_contents as tc LEFT OUTER JOIN chapter_topics as ct ON tc.chapter = ct.chapter GROUP BY tc.chapter HAVING count(ct.topic) >= 2 ;
- Using the ORDER BY clause on the column topic, the results were automatically sorted. SQL's ordering of a column depends on its type, so since topic is of a string type, SQL knew to sort in alphabetical order, rather than numerically or by date.
- LIMIT x[, y] – x represents the desired starting row in your results, y is optional and represents the number of rows to display.
Recent Comments by admin
What is rather fun is during the anti-protest organized by Metropolitan Nikolay (with people only from the Plovdiv eparchy just like in the good old times of communism was financed by the unwilling people to go to the event). It was lied that the reason for Nikolay people to protest is because this is a protest in front of the Synod against the accepting of gay marriages (what a lie !!!). Besides that there is a many people from village called Krepost (if not mistaken the village) who were (protestants!) and came to protest in favour of the new anti people legislation (even though not orthodox christians), because they were mislead the protests are against the gays!
Metropolitan Nikolay has publicly asked priests in his eparchy to sign a document they're going to be present on the protests that should support the New Synodal "order". Those who were unwilling to cooperate of course can always be sent by their Metropolitan to a very distant village or even taken away their profession as priests so there was a lot of pressure put on those people.
От архива: Христовата любов побеждава дори смъртта, твърдеше приживе патриарх Неофит
Българският Патриарх Неофит в Москва на 8 Март 2016 г. ЧАСТ 2
Christ is Risen Eastern Orthodox Resurrection Paschal Greeting in Different Languages
Hi Stan,
I guess you cannot read the writtings on the icon as it is in cyrillic.
This is not Saint Mary and Saint Peter but Adam and Eve written in cyrillic on top of the icon.
Actually in orthodoxy it is a requirement for the depicted personalities, especially saints to have
written on the names of the saint and have the Halo. If you look closely at the picture you will notice
the two Adam and Eve are missing a Halo. The only person with a Halo in the icon is Saint John the Baptist.
Best Regards
Georgi
Install and configure rkhunter for improved security on a PCI DSS Linux / BSD servers with no access to Internet
–rwo, –report-warnings-only
This option causes only warning messages to be displayed. This can be useful when rkhunter is run via cron. Other options may
be used to force other items of information to be displayed.
–sk, –skip-keypress
When the –check command option is used, after certain sections of tests, the user will be prompted to press the return key
in order to continue. This option disables that feature, and rkhunter will run until all the tests have completed.
