MorkaLork Development

Interesting stuff I've picked up over the years...

Articles with keyword: SQL

C#/MySql 1: Installing

The specifics of working with MySql in Csharp

2009-05-16 16:17:30 | 368 views | csharp mysql database dataconnection connector data source control panel fill

C#/MySql 3: Create database

How to communicate with a database

2009-04-17 07:27:51 | 240 views | csharp class method tutorial communicate database sql commands properties

C#/MySql 4: Create table

How to create a table with mysql and csharp

2009-04-17 07:28:31 | 369 views | csharp class method tutorial mysql create table connection

C#/MySql 5: Insert into table

How to insert into a table using csharp and mysql

2009-04-17 07:29:18 | 865 views | csharp class method tutorial chsarp mysql security insert

C#/MySql 6: Reading from table

How read from a table using csharp and mysql

2009-04-17 07:30:01 | 256 views | csharp class method tutorial table mysql command database records return

C#/MySql 7: Index of Terms

A list of mysql methods in csharp

2009-04-17 07:30:51 | 221 views | csharp class method tutorial csharp list classes links link mysql

Mysql 6.1: INNER JOIN

How the inner join works

2009-04-16 21:13:26 | 154 views | inner join mysql sql table primary foreign key

Mysql 1: CREATE

How to use the various create commands in SQL

2009-04-16 18:06:01 | 318 views | sql create database table command

Mysql 3: INSERT

How the insert command work

2009-04-16 21:13:57 | 161 views | insert into sql mysql table command

Mysql 7.1: WHERE ... IN

How the where in command works

2009-04-16 21:15:21 | 132 views | sql mysql table where in

Mysql 7: WHERE

How the where command works

2009-04-16 21:15:08 | 152 views | sql mysql table where search

Mysql 7.2: WHERE ... LIKE

How the where like command works

2009-04-16 21:15:47 | 145 views | sql mysql table where like

Mysql 7.3: WHERE ... BETWEEN

How the where between command works

2009-04-16 21:16:17 | 602 views | sql mysql table where between search

Mysql 8: ORDER BY

How the order by command works

2009-04-16 21:16:45 | 315 views | sql mysql table order by ascending descending

Mysql 9: Functions

How the functions work

2009-04-16 21:17:35 | 141 views | sql mysql table function inserting average max count min sum

Mysql 10: GROUP BY

How the group by command works

2009-04-16 21:18:08 | 151 views | sql mysql table group by sum function together records

Mysql 11: HAVING

How having works

2009-04-16 21:18:51 | 161 views | sql mysql table having select from group by limit

Mysql 6: JOIN

How join works

2009-04-16 21:19:21 | 123 views | sql mysql table join database

Mysql 12: ALIAS

How alias works

2009-04-16 21:19:52 | 150 views | sql mysql table alias header keyword

Mysql 6.2: LEFT/RIGHT JOIN

how left and right joins work

2009-04-16 21:20:27 | 138 views | sql mysql table left right join exception matches

Mysql 13: Concatenate

How to use concatenate

2009-04-16 21:21:07 | 341 views | sql mysql table concatenate columns

UPDATE examples

Some sql update examples

2009-04-16 21:21:52 | 234 views | sql mysql table update examples

Mysql 14: Primary key

How the primary key works

2009-04-16 21:22:35 | 276 views | sql mysql table primary key field unique

Mysql 15: Foreign key

How the foreign key works

2009-04-16 21:23:01 | 298 views | sql mysql table foreign key id primary key

Mysql 5: Safety handling

Secure datahandling with SQL

2009-04-16 18:08:30 | 295 views | transaction safe safety working tables acid a.c.i.d. sql server mysql atomicity consistency isolation durability start transaction commit backup

PHP/MySql part 1

How to access mysql with php

2009-04-16 18:09:44 | 261 views | php mysql interact database common server webhotel connection

PHP/MySql part 4: Data types

list of sql datatypes

2009-04-17 07:32:18 | 265 views | sql data types datatypes char int table blob enum long

PHP/MySql part 2: Connection

How to create a mysql connection with php

2009-04-17 07:32:52 | 178 views | sql mysql php connection database

PHP/MySql part 3: Create Database

How to create a database with php and mysql

2009-04-17 07:33:25 | 261 views | php mysql create database result sql

ConnectDB()

Create a connection file

2009-04-16 18:11:19 | 186 views | connect connectdb mysql php function

PHP/Visit Counter

How to create a php visit counter

2009-04-16 18:13:38 | 181 views | php create visit counter visitors tutorial mysql

mysql_error()

How to output the mysql error code and message

2009-03-15 14:18:45 | 202 views | mysql php mysql_error mysql_error() mysql_errno mysql_errno()

mysql_insert_id()

How get auto incremented value from database

2009-04-17 07:35:57 | 197 views | mysql_insert_id mysql_insert_id() id get id auto_increment identity

Mysql 16: Using DATETIME

Various useful ways to handle the annoying DATETIME type

2009-11-01 10:02:49 | 187 views | select sql datetime table

A MySql scenario

From CREATE to JOIN

2010-02-12 07:12:56 | 484 views | SQL create insert table