Recent questions tagged Mysql

0 votes

575 views

1 answer

mysql - How can I implement single table inheritance using Laravel's Eloquent?

Currently I have a model class named Post. class Post extends Eloquent { protected $table = 'posts'; protected ... this and where to start? See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

571 views

1 answer

mysql - Insert data into table with result from another select query

I am seeking help on the following issue: I have two tables Table_1 columns are itemid, locationid, ... locationid = Table_2.locationid ) See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

794 views

1 answer

mysql - SQL query to check if a name begins and ends with a vowel

I want to query the list of CITY names from the table STATION(id, city, longitude, latitude) which have vowels as ... a better way to do it? See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

463 views

1 answer

mysql - Is there a way to "limit" the result with ELOQUENT ORM of Laravel?

Is there a way to "limit" the result with ELOQUENT ORM of Laravel? SELECT * FROM `games` LIMIT 30 , 30 And with Eloquent ? See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

594 views

1 answer

mysql - When is a timestamp (auto) updated?

If I have a column in a table of type TIMESTAMP and has as default: CURRENT_TIMESTAMP does this column get ... the value it should have]2 See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

500 views

1 answer

mysql - Does a UNIQUE constraint automatically create an INDEX on the field(s)?

Should I define a separate index on the email column (for searching purposes), or is the index is "automatically ... 257 const 1 Using where See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

811 views

1 answer

mysql - How to unblock with mysqladmin flush hosts

I have gone through similar cases listed here but it doesn't seem to work. I was using MySQL Workbench ... with 'mysqladmin flush-hosts' See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

812 views

1 answer

mysql - Find Point in polygon PHP

i have a typical question with the Geometric datatype of mysql, polygon. I have the polygon data, in the form of an ... can i do this in php ? See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

627 views

1 answer

mysql - Can't import database through phpmyadmin file size too large

I have been trying to import Database through phpMyAdmin. My database file is a.sql and it's size is 1.2 GB ... I really need this to work. See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

650 views

1 answer

mysql - How to drop all tables from the database with manage.py CLI in Django?

How can I drop all tables from a database using manage.py and command line? Is there any way to do that ... execute it from a .NET application? See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

491 views

1 answer

mysql - Adding a new SQL column with a default value

I am looking for the syntax to add a column to a MySQL database with a default value of 0 Reference See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

634 views

1 answer

mysql - Import CSV to Update only one column in table

I have a table that looks like this: products -------- id, product, sku, department, quantity There ... single line but this seems inefficient. See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

436 views

1 answer

mysql - what is the difference between GROUP BY and ORDER BY in sql

When do you use which in general? Examples are highly encouraged! I am referring so MySql, but can't ... being different on another DBMS See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

805 views

1 answer

mysql - SQL: deleting tables with prefix

How to delete my tables who all have the prefix myprefix_? Note: need to execute it in phpMyAdmin See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

926 views

1 answer

mysql - How to find nearest location using latitude and longitude from SQL database?

I want to find a nearest location from following database table Address Latitude longitude Kathmandu 44600, Nepal 27 ... from the place Surkhet. See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

416 views

1 answer

mysql - How do you manage databases in development, test, and production?

I've had a hard time trying to find good examples of how to manage database schemas and data between development ... if there's interest). See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

615 views

1 answer

mysql - How to change the default collation of a table?

create table check2(f1 varchar(20),f2 varchar(20)); creates a table with the default collation latin1_general_ci; ... the alter table command? See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

656 views

1 answer

mysql - #1273 – Unknown collation: ‘utf8mb4_unicode_520_ci’

I have a WordPress website on my local WAMP server. But when I upload its database to live server, I get ... ' Any help would be appreciated! See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

582 views

1 answer

mysql - Foreign key constraints: When to use ON UPDATE and ON DELETE

I'm designing my database schema using MySQL Workbench, which is pretty cool because you can do diagrams and ... these could be useful? Thanks See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

456 views

1 answer

mysql - Are SELECT type queries the only type that can be nested?

Is it possible to have an non-select query (update, insert, delete) embedded into another query? Something like (an ... . insert into .... ; See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

469 views

1 answer

mysql - Sum results of a few queries and then find top 5 in SQL

I have 3 queries: table: pageview SELECT event_id, count(*) AS pageviews FROM pageview GROUP BY event_id ORDER BY ... sum(amount) DESC LIMIT 5; See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

757 views

1 answer

mysql - How to transpose rows to columns with large amount of the data in BigQuery/SQL?

I have a problem in transposing a large amount of data table in BigQuery (1.5 billion rows) from rows to columns ... or SQL? Thanks in advance. See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.3k views

1 answer

mysql - How to pass parameter to mssql query in node js

I am changing my application's database from MySQL to MSSQL. I send parameters like below for MySQL database ... string in mysql automatically)? See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

473 views

1 answer

mysql - How to run the PHP script at scheduled time

I need to run a php script at the scheduled time daily to update some fields in database and to send ... MySQL running in Linux Server. See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.2k views

1 answer

mysql - Finding number position in string

Below is what I have in table myTable +++++++++++++++ + id + myWord + +++++++++++++++ + 1 + AB123 ... ++++++++ Any Idea how I can achieve this? See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

672 views

1 answer

mysql - Using reserved words in column names

this is some simple code but I just don't know why I can't use this word as the entity of the table CREATE TABLE ... 's a way to get it work. See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

450 views

1 answer

mysql - Difference between two table structure

I am very confuse about the two structure. What are the advantage and disadvantage of this two table? ... somedata3 somedata3 address somedata3 See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

795 views

1 answer

mysql - How to format number with "." as thousand separator, and "," as decimal separator?

how to format number with "." as thousand separator, and "," as decimal separator in MySql? I'm using Format ... How to do in MySQL ? Thanks See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

Categories

Just Browsing Browsing

Most popular tags