{"action":"created","issue":{"url":"https://api.github.com/repos/tgriesser/knex/issues/1426","repository_url":"https://api.github.com/repos/tgriesser/knex","labels_url":"https://api.github.com/repos/tgriesser/knex/issues/1426/labels{/name}","comments_url":"https://api.github.com/repos/tgriesser/knex/issues/1426/comments","events_url":"https://api.github.com/repos/tgriesser/knex/issues/1426/events","html_url":"https://github.com/tgriesser/knex/issues/1426","id":155654923,"number":1426,"title":"Support prefix attribute","user":{"login":"code-artisan","id":5195218,"avatar_url":"https://avatars.githubusercontent.com/u/5195218?v=3","gravatar_id":"","url":"https://api.github.com/users/code-artisan","html_url":"https://github.com/code-artisan","followers_url":"https://api.github.com/users/code-artisan/followers","following_url":"https://api.github.com/users/code-artisan/following{/other_user}","gists_url":"https://api.github.com/users/code-artisan/gists{/gist_id}","starred_url":"https://api.github.com/users/code-artisan/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/code-artisan/subscriptions","organizations_url":"https://api.github.com/users/code-artisan/orgs","repos_url":"https://api.github.com/users/code-artisan/repos","events_url":"https://api.github.com/users/code-artisan/events{/privacy}","received_events_url":"https://api.github.com/users/code-artisan/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":2,"created_at":"2016-05-19T05:05:58Z","updated_at":"2016-05-19T09:32:13Z","closed_at":"2016-05-19T09:32:13Z","body":"Hi there, Can you support `prefix` in mysql ? Look like this:\r\n\r\n```js\r\nvar knex = require('knex')({\r\n  client: 'mysql',\r\n  connection: {\r\n    ...\r\n    prefix: 'knex_'\r\n  }\r\n});\r\n```\r\n\r\n```js\r\nknex.select('title', 'author', 'year').from('books')\r\n\r\n// Outputs:\r\n// If prefix attribute is a string, then:\r\nselect `title`, `author`, `year` from `knex_books`\r\n\r\n// otherwise\r\nselect `title`, `author`, `year` from `books`\r\n```"},"comment":{"url":"https://api.github.com/repos/tgriesser/knex/issues/comments/220274260","html_url":"https://github.com/tgriesser/knex/issues/1426#issuecomment-220274260","issue_url":"https://api.github.com/repos/tgriesser/knex/issues/1426","id":220274260,"user":{"login":"code-artisan","id":5195218,"avatar_url":"https://avatars.githubusercontent.com/u/5195218?v=3","gravatar_id":"","url":"https://api.github.com/users/code-artisan","html_url":"https://github.com/code-artisan","followers_url":"https://api.github.com/users/code-artisan/followers","following_url":"https://api.github.com/users/code-artisan/following{/other_user}","gists_url":"https://api.github.com/users/code-artisan/gists{/gist_id}","starred_url":"https://api.github.com/users/code-artisan/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/code-artisan/subscriptions","organizations_url":"https://api.github.com/users/code-artisan/orgs","repos_url":"https://api.github.com/users/code-artisan/repos","events_url":"https://api.github.com/users/code-artisan/events{/privacy}","received_events_url":"https://api.github.com/users/code-artisan/received_events","type":"User","site_admin":false},"created_at":"2016-05-19T09:32:13Z","updated_at":"2016-05-19T09:32:13Z","body":"Thanks"}}