Search for a command to run...
Articles tagged with #mysql
Raw Query Output With Bindings is Coming to Laravel 10 User::where(...)->ddRawSql(); // Using the new `toRawSql()` method User::where('email', 'mandeep@example.com')->toRawSql(); // "SELECT * FROM users WHERE email = 'mandeep@example.com'" There is...
Designing a database structure for managing subscribers for email newsletters and automation involves considering various aspects like subscriber information, subscription status, email campaigns, and automation workflows. Here's a suggested structur...
Discover an array of efficient methods for managing related data in Laravel using Eloquent relationships. From simple create and update operations to advanced techniques like updateOrCreate and sync, this comprehensive guide explores various approach...
1 – Invisible Database Columns The invisible column is a new concept in MySQL 8. What it does: when you run a select * query it won't retrieve any invisible column. If you need an invisible column's value you have to specify it explicitly in the sele...
UPDATE pages SET icon_image = REPLACE(icon_image, 'https://example.com', 'https://tools.example.com') WHERE icon_image LIKE 'https://example.com%'; here you change all the link like https://example.com/assets/img/nastuh.jpg https://example.com/assets...
create backup sudo mysqldump -u root -p dbname > backup.sql I believe the format is: mysql -u username -p database_name < /path/to/file.sql From within mysql: mysql> use db_name; mysql> source backup-file.sql;