$ mysqldump -tables lds_scriptures_books lds_scriptures_verses lds_scriptures_volumes -c -t -r lds_scriptures_mysql.sql SQLite Convert the data to a binary string before running case sensitive matches: SELECT BINARY text REGEXP '' Ĭreate an `lds_scriptures` table in MySQL for CSVĬREATE TABLE lds_scriptures AS SELECT verses.verse_id, verses.volume_id, verses.book_id, verses.chapter, verses.verse, verses.verse_scripture, verses.verse_title, verses.verse_title_short, books.book_title, books.book_title_long, books.book_title_short, books.book_title_jst, books.book_subtitle, books.lds_org AS books_lds_org, volumes.volume_title, volumes.volume_title_long, volumes.volume_subtitle, volumes.lds_org AS volumes_lds_org FROM lds_scriptures_verses verses, lds_scriptures_books books, lds_scriptures_volumes volumes WHERE verses.volume_id = volumes.volume_id AND verses.book_id = books.book_id ORDER BY verses.verse_id MySQL's regular expression function (REGEXP) is case INsensitive on non-binary strings. Set the pager (less) so it quits if the display is less than one screen (like psql) Select concat(lds_scriptures_books.book_title, ' ', lds_scriptures_verses.chapter, ':', lds_scriptures_verses.verse ) as test from lds_scriptures_books, lds_scriptures_verses where lds_scriptures_verses.book_id = lds_scriptures_books.book_id limit 10 Mysqldump database_name -tables table1 table2 table3ĪLTER TABLE table_name ADD COLUMN new_column mediumint(8) not null FIRST / AFTER column1 ĪLTER TABLE table_name ADD PRIMARY KEY(colname) ĪLTER TABLE tablename ADD PRIMARY KEY(column) ĪLTER TABLE tablename CHANGE column column tinyint(3) unsigned auto_increment LDS SCRIPTURES CASE UPDATEUPDATE table_name SET column = CONCAT('value: ', column_two) ĪLTER TABLE table_name RENAME new_table_name INSERT INTO table_name SELECT * FROM table_two UPDATE table_name SET field = REPLACE(field, 'old', 'new') Herald G.CREATE TABLE new_table SELECT * FROM old_table ĪLTER TABLE table_name CHANGE column_old column_new (TYPE) “Wherever He Leads Us” – Pioneers in Every Land “ That They May Know“, Church News Article January 1966 With sincere respect and deep affection, Gordon B. May it go forth among them as a witness of the Son of God, the Savior of the world. The Book of Mormon is now available in the language which is the mother tongue of more people than any other on earth. Cannon, in the “Forbidden City” of Peking dedicated and consecrated and set apart “the Chinese realm for the preaching of the Gospel of Jesus Christ as restored in this dispensation through the Prophet Smith.” McKay, who 45 years ago on January 9, 1921, accompanied by Elder Hugh J. This copy of the first edition of the Book of Mormon in Chinese presented to President David O. Inside the cover was typed the following text: Hinkley presented a copy of the first edition to President David o. The translation was finished that July and Hu Wei-I was quoted saying, “It took me seven months Joseph Smith only needed two.” Publication was on December 20th, 1965 with 3,000 copies and was published in hard and softbound. Hinckley and began translation in January of 1964. Browning were set apart to translate the Book of Mormon on the 5th of November 1963 by Elder Gordon B. Hu Wei-I joined the church in 1959 and quickly started translating church material into Chinese. It wasn’t until Hu Wei-I was called in 1962 to translate 3rd Nephi. He was released as mission President and the work on the translation stopped. The translation was mostly finished by 1959, but President Heaton felt it still needed work. Translation of the Book of Mormon proved difficult and the work was slow. President Grant Heaton, hired a few people to translate portions of the Book of Mormon and then had formed a committee to review the translations. Work on a Chinese translation of the Book of Mormon started shortly after missionaries arrived in 1955 to Hong Kong. Illustration of Early Chinese Book of Mormon
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |