select

Incredible new wallpapers for your Linux or Windows machine.

by

Some nice wallpapers to improve your desktop. Bern, 3840×2160: https://www.reddit.com/r/wallpapers/comments/4lql1n/bern_3840x2160/. Forest Path. [3840×2160]: https://www.reddit.com/r/wallpapers/comments/4lp77g/forest_path_3840x2160/. Chicago [3840×2400]: https://www.reddit.com/r/wallpapers/comments/4lhiwv/chicago_3840x2400/. Amanita Muscaria [4160×3120]: https://www.reddit.com/r/wallpapers/comments/4l1hij/spring_has_sprung/. The Great Blue Hole [1920×1200]: https://www.reddit.com/r/wallpapers/comments/4kujhu/the_great_blue_hole_1920x1200/. Portland sunrise: https://interfacelift.com/wallpaper/details/4053/portland_sunrise.html. View out the window of the Space Shuttle: https://www.desktoppr.co/wallpapers/726988. Fort Worth gardens: https://www.desktoppr.co/wallpapers/726924. Sewage pond 1440×900: https://4walled.cc/show-102573. Amish buggy on country road: https://4walled.cc/show-467432. Running track … Read more

How to list the indexes in a MySQL database table.

by

How to list the indexes in a MySQL database table. Easily done using the show command. mysql> show index from customer; +———-+————+——————-+————–+——————–+———–+————-+———-+——–+——+————+———+—————+ | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment | +———-+————+——————-+————–+——————–+———–+————-+———-+——–+——+————+———+—————+ | customer | 0 | … Read more

using the MySQL SELECT statement to only select certain records.

by

We are taking another look at our database table and we are wanting to only view records that match certain criteria. This is easy with the SELECT statement. mysql> select * from operatingsystems where vendor in ("Microsoft","Mint"); +——+————————+———+———–+ | OsID | Name | Type | vendor | +——+————————+———+———–+ | 1 | Windows 3.0 | Windows … Read more

Using the MySQL SELECT statement to only show records that are a certain type.

by

Following on from my previous posting that covered setting up a MySQL database, here is a simple query that returns records that match a certain type. mysql> select * from operatingsystems where Type = "Windows"; +——+————-+———+———–+ | OsID | Name | Type | vendor | +——+————-+———+———–+ | 1 | Windows 3.0 | Windows | Microsoft … Read more