Recent questions tagged MySQL

0 votes

1.1k views

1 answer

mysql - using excel dates for importing into phpmyadmin sql

I have a table in excel (CSV) which I am importing into phpmyadmin. the cells show the date fine such as ... convert them to the correct format? See Question&Answers more detail:os...

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

0 votes

933 views

1 answer

mysql - php access to remote database

Help! I have a PHP (PHP 5.2.5) script on HOST1 trying to connect to an MySql database HOST2. Both hosts are ... the PHP script is trying to use. See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

mysql - laravel having: Column not found

my following code is like this: $places = DivePlace::selectRaw("*,(st_distance_sphere( POINT(".$lon.",".$lat." ... distance < 300) Any solution? See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

mysql - Week of the year for weeks starting with Saturday

We have customers that currently have defined weeks starting either on Sat, Sun or Monday. Came across these ... first day of the week See Question&Answers more detail:os...

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

0 votes

942 views

1 answer

mysql - PHP - fetching prepared stmt into class: Fatal Error "class not found"

I want to fetch the result of a query into a class (into an array of instances of a class). But I get the ... $_Mode == 1 works fine Any ideas? See Question&Answers more detail:os...

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

0 votes

793 views

1 answer

mysql - issue in installing mysql2 gem with rails3 on mac

Installing mysql2 (0.2.6) with native extensions /Library/Ruby/Site/1.8/rubygems/installer.rb:483:in ` ... was not starting.. Screenshot See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

mysql - Error Code: 1136 Column count doesn't match value count at row 1) inside sp

i have some troubles filling a predefined table with a stored procedure. mytable has 6 fields: uid,testrun,exp1 ... any suggestions in advance! See Question&Answers more detail:os...

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

0 votes

1.0k views

1 answer

mysql - SQL - WHERE Condition on SUM()

Is it possible to do something like this: SELECT `e`.*, `rt`.`review_id`, (SUM(vt.percent) / ... where condition on the division result value See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

mysql - Using Amazon RDS with android application

Background I have a EC2 instance with a RDS instance(MYSQL) associated with it. I want to use a ... android application without sdk support? See Question&Answers more detail:os...

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

0 votes

1.7k views

1 answer

mysql - how to resolve General error: 2014 Cannot execute queries while other unbuffered queries are active. using PDO connection

While i am executing second Stored procedure with same connection statement(Using PDO), getting the below error. ====== ... ; } Help me on this. See Question&Answers more detail:os...

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

0 votes

892 views

1 answer

mysql - Convert an Object to a String in PHP

I want to convert an Object into a String in PHP. Specifically, I'm trying to take a mysql query response, ... a home-brewed caching project :) See Question&Answers more detail:os...

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

0 votes

1.0k views

1 answer

mysql - How to suppress output and check whether or not a command is successful?

I am trying to write a powershell script that tests if a MySQL login is successful by using $? to check if ... ever prints "Boo!" like before. See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

mysql - Automatically add letters in front of an auto-increment fieild

Is it possible to attach a letter in front of an auto-increment in MySQL. I have several tables in my ... just help making small tasks easy. See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

mysql - JDBC returns wrong number of affected rows

If we have a table with 10 rows and we execute this query twice we get the wrong number of affected rows ... of rows that are actually updated? See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

mysql - specifying classpath for standalone jython

I am trying to run a python script via jython on a server that I won't be able to install anything. I can ... org.gjt.mm.mysql.Driver] not found See Question&Answers more detail:os...

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

0 votes

891 views

1 answer

mysql - Merging 3 tables/queries using MS Access Union Query

I have built a MySQL database to store bill payments. Everyone in my office has MS Access, so I am building a ... in 3 tables. Thoughts? Thanks! See Question&Answers more detail:os...

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

0 votes

833 views

1 answer

mysql - SQL multiple rows as columns (optimizing)

I have a SQL query which gives the correct result, but performs too slow. The query operates on the following ... do I optimize this query? See Question&Answers more detail:os...

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

0 votes

969 views

1 answer

mysql - What is the easiest way to extract sprint start and end dates from the JIRA db?

I'm trying to extract the start and end days of my sprints from the Jira database. This would seem like a ... to find my sprint starting dates? See Question&Answers more detail:os...

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

0 votes

841 views

1 answer

mysql - Aggregating data by date in a date range without date gaps in result set

I have a table with sell orders and I want to list the COUNT of sell orders per day, between two dates, without ... . 5 Jun 15 Is that possible? See Question&Answers more detail:os...

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

0 votes

822 views

1 answer

mysql - Can I use the same foreign key constraint in two different tables?

I am trying to create a database for work. I have two different types of users: internal and external. Each ... are appreciated, Thanks! :) See Question&Answers more detail:os...

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

0 votes

921 views

1 answer

mysql - Using SQL keyword in title of table or column

I want to name one of my tables as ORDER. Can I to use in SQL keywords as names? How bad is this practice ... SELECT * FROM ORDER ORDER BY NAME; See Question&Answers more detail:os...

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

0 votes

803 views

1 answer

mysql - Does mysqli class in PHP protect 100% against sql injections?

I've seen lots of articles and questions about mysqli, and all of them claim that it protects against sql ... , then is it foolproof? See Question&Answers more detail:os...

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

0 votes

979 views

1 answer

mysql - (My)SQL full join with three tables

I have tree tables ID A ----------- 1 10 ID B ----------- 1 20 2 30 ID C ----------- 2 40 3 50 ... 2 0 30 40 -10 3 0 0 50 -50 Thanks in advance. See Question&Answers more detail:os...

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

0 votes

999 views

1 answer

mysql - Timestamp without change on update

In mysql I have a timestamp with the field name added_on. I created that for a table of leads for a crm. ... updated whenever I update the row? See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

mysql - SQL nested order by?

I'm sure that this has been asked before, but I don't know what to call it exactly to find the answer. ... to use multiple queries Thanks, Brad See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

mysql - How to sort time ( In AM / PM ) in SQL?

I am facing problem with sorting according to AM / PM. Here is my table data login_time 1:30 PM 2:00 AM 8:00 AM ... 10:00 PM How can I do this? See Question&Answers more detail:os...

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

0 votes

956 views

1 answer

mysql - Select a row and rows around it

Ok, let's say I have a table with photos. What I want to do is on a page display the photo based on ... - Incorrect usage of UNION and ORDER BY See Question&Answers more detail:os...

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

0 votes

939 views

1 answer

mysql - Unable to install mysql2 gem OS X Mountain Lion

I'm new with RoR and I'm trying to install Mysql2 -v '0.3.11'. I have OS X Mountain Lion, rails ... /mysql2/gem_make.out Thanks for your help. See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags