Category archive
Explore every article in Mysql, with preserved WordPress-friendly URLs.
How to reorder table rows using drag and drop and automatically save the sequence in database. Sample Table code start <table class=”table table-bordered” id=”tbl_1″> <thead> <tr> <th width=”25%”>Column1 Label</th> <th width=”25%”>Column2 Label</th> <th width=”25%”>Column3 Label</th> <th width=”25%”>Column4 Label</th>
Read articleWhen you have access to the command line and you have the export large database, you will not be able to export from phpmyadmin. Hence mysql provide you handy method to export the database from the command line. Below are various options, you can use while exporting the database. ——databases – This allows you to [&hell
Read articleWe can get the SQL query from DB sql query in Laravel 5 $dataQuery = DB::table(‘sometable’) ->select(‘sometable.column1′, ‘sometable.column2′, ‘sometable.column3′, ‘sometable.column4′, ‘sometable.column5′); $dataQuery->toSql(); // this will give you the actual query but this will not give the result with actual data va
Read article$markers = $this->Post->find(‘all’, array( ‘joins’ => array( array( ‘table’ => ‘cp_user’, ‘alias’ => ‘users’, ‘type’ => ‘left’, ‘foreignKey’ => false, ‘conditions’=> array(‘Post.postauthor = users.id’) ) ), ‘conditions’=>’Post.poststatus = 1’, ‘fields’=>array(‘Post.postid’, ‘Post.postdate’, ‘Post.posttitle’, ‘Post.post
Read articleThe basic purpose of this post is to guide you all about fetching multilingual content from database. I mean to say that, if you have stored japanese text in your database, So in order to fetch the japanese content , you need to set the character encoding to UTF-8 format, while communication with the database […
Read articleOpen your shell prompt navigate to the mysql directory (default is /var/lib/mysql) cd /pathToYourMysqlDirectory/ then type the below command $ mysql -u mysqlUserName -p Password -h HostName DatabaseName < /loactionOfYourSqlFile/yourSqlFileName.sql Where mysqlUserName = Mysql User Name Password = Mysql User Password Hos
Read article