Preface Introduction The Testimony of the three witnesses The Testimony of the eight witnesses Testimony of the prophet Joseph Smith A brief explanation about the Book of Mormonġ Nephi 2 Nephi Jacob Enos Jarom Omni Words of Mormon Mosiah Alma Helaman 3 Nephi 4 Nephi Mormon Ether Moroni The main table of contents contains Nook quick links to every book and chapter in the Bible as well as the The Book of Mormon, The Doctrine and Covenants and The Pearl of Great Price.
#Lds scriptures quad full#
This NOOK edition comes with a fully interactive table of contents and over 20 full color and black/white illustrations and photographs. The NOOK edition of the LDS Complete Scriptures "Quadruple Combination" contains the full, unabridged text of the King James Holy Bible and the complete and unabridged versions of The Book of Mormon, The Doctrine and Covenants and The Pearl of Great Price. This NOOK edition comes with a fully interactive table of contents and over 20 full color and black/white illu OVERVIEW: INSERT INTO table_one SELECT * FROM table_two ORDER BY table_two.OVERVIEW: The NOOK edition of the LDS Complete Scriptures "Quadruple Combination" contains the full, unabridged text of the King James Holy Bible and the complete and unabridged versions of The Book of Mormon, The Doctrine and Covenants and The Pearl of Great Price.
Pg_dump -t tablename -a -f table.sql -O -x -d database
#Lds scriptures quad update#
UPDATE table_name SET column_name = REPLACE(column_name, 'old_text', 'new_text') ĬREATE TABLE new_table AS SELECT * FROM old_table ĬREATE UNIQUE INDEX index_name ON table_name (column1) Show databases, tables, table description:ĪLTER TABLE table_name RENAME TO new_table_name $ 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 UPDATE 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')
CREATE TABLE new_table SELECT * FROM old_table ĪLTER TABLE table_name CHANGE column_old column_new (TYPE)
0 kommentar(er)
