M6jwMxPq

1drop table if exists swar;
2
3CREATE TABLE swar ( swar_id int not null auto_increment, myswar varchar(100) NOT NULL default '', PRIMARY KEY (swar_id), 
4KEY (myswar) ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
5
6INSERT INTO swar (myswar) VALUES(''); INSERT INTO swar (myswar) VALUES('ा'); INSERT INTO swar (myswar) VALUES('ि'); INSERT INTO swar (myswar) VALUES('ी'); INSERT INTO swar (myswar) VALUES('ु'); INSERT INTO swar (myswar) VALUES('ू'); INSERT INTO swar (myswar) VALUES('े'); INSERT INTO swar (myswar) VALUES('ै'); INSERT INTO swar (myswar) VALUES('ो'); INSERT INTO swar (myswar) VALUES('ौ'); INSERT INTO swar (myswar) VALUES('ं'); INSERT INTO swar (myswar) VALUES('ः'); INSERT INTO swar (myswar) VALUES('ृ'); INSERT INTO swar (myswar) VALUES('ॄ'); INSERT INTO swar (myswar) VALUES('ॢ'); INSERT INTO swar (myswar) VALUES('ॣ');
7
8drop table if exists vyanjan;
9
10CREATE TABLE vyanjan ( vyanjan_id int not null auto_increment, akshar varchar(100) default NULL, primary key(vyanjan_id), key (akshar) ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
11
12INSERT INTO vyanjan (akshar) VALUES('क'); INSERT INTO vyanjan (akshar) VALUES('ख'); INSERT INTO vyanjan (akshar) VALUES('ग'); INSERT INTO vyanjan (akshar) VALUES('घ');
13
14INSERT INTO vyanjan (akshar) VALUES('च'); INSERT INTO vyanjan (akshar) VALUES('छ'); INSERT INTO vyanjan (akshar) VALUES('ज'); INSERT INTO vyanjan (akshar) VALUES('झ'); INSERT INTO vyanjan (akshar) VALUES('ञ');
15
16INSERT INTO vyanjan (akshar) VALUES('ट'); INSERT INTO vyanjan (akshar) VALUES('ठ'); INSERT INTO vyanjan (akshar) VALUES('ड'); INSERT INTO vyanjan (akshar) VALUES('ढ'); INSERT INTO vyanjan (akshar) VALUES('ण');
17
18INSERT INTO vyanjan (akshar) VALUES('त'); INSERT INTO vyanjan (akshar) VALUES('थ'); INSERT INTO vyanjan (akshar) VALUES('द'); INSERT INTO vyanjan (akshar) VALUES('ध'); INSERT INTO vyanjan (akshar) VALUES('न');
19
20INSERT INTO vyanjan (akshar) VALUES('प'); INSERT INTO vyanjan (akshar) VALUES('फ'); INSERT INTO vyanjan (akshar) VALUES('ब'); INSERT INTO vyanjan (akshar) VALUES('भ'); INSERT INTO vyanjan (akshar) VALUES('म');
21
22INSERT INTO vyanjan (akshar) VALUES('य'); INSERT INTO vyanjan (akshar) VALUES('र'); INSERT INTO vyanjan (akshar) VALUES('ल'); INSERT INTO vyanjan (akshar) VALUES('व'); INSERT INTO vyanjan (akshar) VALUES('श'); INSERT INTO vyanjan (akshar) VALUES('ष'); INSERT INTO vyanjan (akshar) VALUES('स'); INSERT INTO vyanjan (akshar) VALUES('ह'); INSERT INTO vyanjan (akshar) VALUES('ळ'); INSERT INTO vyanjan (akshar) VALUES('क्ष'); INSERT INTO vyanjan (akshar) VALUES('ज्ञ');
23
24SELECT b.akshar, a.myswar, concat( b.akshar, a.myswar ) AS mycharacter FROM vyanjan AS b INNER JOIN swar AS a ORDER BY vyanjan_id, swar_id;
25
26drop table devnagari_chars;
27create table devnagari_chars as 
28SELECT b.akshar as bakshar, c.akshar as cakshar, a.myswar, concat( b.akshar, '्', c.akshar, a.myswar ) AS mycharacter 
29FROM vyanjan AS b 
30INNER JOIN vyanjan as c
31INNER JOIN swar AS a ORDER BY b.vyanjan_id, c.vyanjan_id, a.swar_id