Did you mean to write CREATE TABLE catsub1…, without the $? Is the table name catsub1, or are you trying to insert the value of the $catsub1 variable as the table name? In this case, you need to set the value of $catsub1 properly because apparently it is now 0. $catsub1 = “your_table_name”; $sql = … Read more
You want to get the rank in MySQL. Here is one approach: SELECT id, name, @rn := @rn+1 as `rank` from `users` cross join (select @rn := 0) const ORDER BY points desc
Change your query to say you want an id greater than the number you’re looking for – “SELECT * FROM category WHERE id > ’10′”
You can’t use not like directly in a show tables statement, but you could put it in a where clause: SHOW TABLES WHERE tables_in_db NOT LIKE ‘wp_2_%’;
Your current query structure cannot work! Your query returns when you have customers.total_orders = 1 because none of the left joins returns a set. As an example take one customer with 10 orders but only one containing the desired product. 1st three tables return 1 row, 1st LEFT JOIN returns 9 rows, 2nd 8 rows, … Read more
Practically any database should be able to run such queries. In the case of SQL, using a simple WHERE … LIKE … condition with wildcards should be sufficient for simple cases. The interesting question will be how to scale this once you are dealing with much larger amounts of data, think YouTube for video portals. … Read more
\DB::table(‘cars’) ->join(‘garage’, ‘garage.id’, ‘=’, ‘cars.garage’) ->where(‘garage.name’, ‘main’) The above solves the garage and cars part, but you never specified what is aliased to p. If p is a different table then you need to add another call to join() and making the following \DB::table(‘cars’) ->join(‘garage’, ‘garage.id’, ‘=’, ‘cars.garage’) //<Other table join goes here for table … Read more
For each operator (ie < or > ) there must be a distinct right and left side. When you write datedebut < 20181109 < datefin it is parsed as datedebut < 20181109 and the result of that comparison is sent to the next operator. You need to think differently when writing SQL than when writing … Read more
Options AFAIK are mainly based around getting the replication to be be ROW based rather then STATEMENT based. Set the default to ROW (which is a brute force method, and has its drawbacks). You can set the SESSION binlog_format to ROW, but it requires the SUPER privilege which the user probably hasn’t and will not … Read more
SAVEPOINT name– Marks a savepoint within the current transaction, there can be multiple savepoints in a transaction. ROLLBACK TO SAVEPOINT name -ROLLBACK TO SAVEPOINT rolls back the current transaction to the specified savepoint, so it discards any changes and or savepoints created after the savepoint to which you are rolling back. So in your problem, … Read more