Recent questions tagged MySQL

0 votes

580 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

575 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

801 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

469 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

599 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

505 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

817 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

818 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

632 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

655 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

496 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

638 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

442 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

809 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

931 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

421 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

621 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

662 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

587 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

461 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

474 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

762 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

480 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

677 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

455 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

800 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