Mysql Programming Tutorials, Guides & Best Practices

No preview available for this content.

Orders Table:

public function up()
{
    Schema::create('orders', function (Blueprint $table) {
        $table->id();
        $table->unsignedBigInteger('product_id');
        $table->foreign('product_id')->references('id')->on('products')->onDelete('cascade');
        $table->integer('quantity');
        $table->decimal('total_price', 8, 2);
        $table->timestamps();
    });
}

• On Windows:

Restart the MySQL service from the Services management console.

SELECT preferences->'$.languages' AS languages
FROM users
WHERE name = 'Jane Smith';

To retrieve a specific element in the array:

• Create the comments table with commentable_id and commentable_type columns.

• In Comment.php: