Recent questions tagged mySQL

0 votes

597 views

1 answer

mysql - How to use GROUP BY in a query while using variables

I'm using MySql V5.7. I have a table PatientAppointment. I need to GROUP BY CDRId which is a column in the ... to your MySQL server v... See Question&Answers more detail:os...

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

0 votes

532 views

1 answer

mysql - Writing an SQL query to SELECT item from the following table

I am having a really hard time writing a SELECT query to get a hold of the data in the following table... ... trouble SELECT'ing it... Thanks See Question&Answers more detail:os...

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

0 votes

553 views

1 answer

mysql - Database design to create tables on the fly

I need to create dynamic tables in the database on the fly. For example, in the database I will have ... any free database software. Thanks See Question&Answers more detail:os...

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

0 votes

709 views

1 answer

mysql - Create Date object in PHP for dates before 1970 in certain format

I have date witch is formatted d-m-y like 22-10-49 I want to convert it to Date object to save it in my ... 10-15 to be 1915 rather than 2015. See Question&Answers more detail:os...

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

0 votes

661 views

1 answer

mysql - "INSERT INTO .. ON DUPLICATE KEY UPDATE" Only inserts new entries rather than replace?

I have a table, say table1, which has 3 columns: id, number, and name. id is auto_incremented. I ... the auto_incrementing primary key? thanks See Question&Answers more detail:os...

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

0 votes

573 views

1 answer

mysql - Incrementing value in PHP script not working

I have the following PHP script to update the blog view in my database, <?php include('header.php'); ?> <? ... field , why is this happening ?? See Question&Answers more detail:os...

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

0 votes

597 views

1 answer

mysql - Table relationship for subtypes

I have a parent table called 'Website' which holds records about websites. I have a child table called ' ... way to model this data? See Question&Answers more detail:os...

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

0 votes

709 views

1 answer

mysql - Displaying zero valued months with SQL

The following query returns values for months with sales but not for months where sales are zero: SELECT ... you in advance, Orville See Question&Answers more detail:os...

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

0 votes

659 views

1 answer

mysql - random numbers in java

I have the following table created using java as the front end and mysql as the backend. mysql> select * ... occuring most number of times. See Question&Answers more detail:os...

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

0 votes

664 views

1 answer

mysql - Looping through mysql_fetch_array in PHP

So I have the following: $i = 0; $records = mysql_num_rows($sections_query); $row_sections = mysql_fetch_array( ... for the help! See Question&Answers more detail:os...

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

0 votes

606 views

1 answer

mysql - Rails - gmaps4rails gem on postgres

I successfully use the gmaps4rails gem on my local MySQL machine. However, when I deploy to PG on Heroku, I get ... Any idea what's going on? See Question&Answers more detail:os...

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

0 votes

781 views

1 answer

mysql - Fatal error: Call to undefined function mb_detect_encoding() in C:apachehtdocsphpmyadminlibrariesphp-gettextgettext.inc on line 177

So I'm trying to get phpmyadmin running on windows 7, and I've gone through and installed all the proper programs ... .didn't work. Please help! See Question&Answers more detail:os...

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

0 votes

817 views

1 answer

mysql - Count the frequency of each word

I've been trolling the internet and realize that MySQL is not the best way to get at this but I'm asking anyway. What ... | 2 love | 1 hate | 1 See Question&Answers more detail:os...

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

0 votes

678 views

1 answer

mysql - How to normalize comma separated values within column of table and then run query

Let's say I have a table with the following structure: | column1 | column2 | |------------|------ ... and run this query in MySQL? Thanks. See Question&Answers more detail:os...

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

0 votes

610 views

1 answer

mysql - Help with SQL query to find next available date for a reservation system

I am attempting to write an SQL query for a reservations system to find the earliest available rental date for ... works. Questions are welcome. See Question&Answers more detail:os...

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

0 votes

830 views

1 answer

mysql - How to log SQL queries to a log file with CakePHP

I have a CakePHP 1.2 application that makes a number of AJAX calls using the AjaxHelper object. The AjaxHelper ... a log file. Any suggestions? See Question&Answers more detail:os...

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

0 votes

692 views

1 answer

mysql - SELECT INTO not working

I'd like to test a situation, but I need to add a dummy row of data to test the hypothesis. So, according to ... 't obvious to me why - help? See Question&Answers more detail:os...

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

0 votes

672 views

1 answer

mysql with comma separated values

I'm having a problem in MySQL query. I need MySQL query to display the following output and I also need to take ... , ravi 2 ravi 3 ravi, raja See Question&Answers more detail:os...

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

0 votes

634 views

1 answer

mysql - Wordpress Query order by custom field missing posts

This is my current query: query_posts(array_merge(array('tag' => $pagetag,'meta_key'=>priority,'orderby' => ... well? Thanks in advance! See Question&Answers more detail:os...

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

0 votes

606 views

1 answer

mysql - myisam place table-lock on table even when dealing with 'select' query?

i am reading the book High Performance MySQL, it mentions: performing one query per table uses table locks more ... explain a little bit? See Question&Answers more detail:os...

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

0 votes

937 views

1 answer

mysql - PHP/PDO: Prepared statements don't work when creating a table?

When I am using a PDO prepared statement, and use it to plug in a table name to the query it fails, a quick ... What on earth am I missing here? See Question&Answers more detail:os...

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

0 votes

660 views

1 answer

mysql - Counting word occurrences in a table column

I have a table with a varchar(255) field. I want to get (via a query, function, or SP) the number of occurences ... idea? I am using MySQL 5.2. See Question&Answers more detail:os...

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

0 votes

732 views

1 answer

mysql - SQL: Get Products from a category but also must be in another set of categories

I am currently stuck in a situation. The scenario is this. I have products who may be associated with ... will be greatly appreciated. See Question&Answers more detail:os...

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

0 votes

877 views

1 answer

mysql - ERROR 1452: Cannot add or update a child row: a foreign key constraint fails

I have created two tables in MySQL 5.6.11 as shown below by means of MySQL Workbench 5.2.47. The ... OneToOne relationship. What am I missing? See Question&Answers more detail:os...

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

0 votes

455 views

1 answer

mysql - Selected columns dont have compatiable type, even it has same type

I am creating FOREIGN KEY on Table1(propType) from Table2 with groupName. But i am facing below error. selected ... know what i am missing. See Question&Answers more detail:os...

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

0 votes

643 views

1 answer

mysql - Querying a string from int column?

I have a table: CREATE TABLE `ids` ( id int(11) not null auto_increment, PRIMARY KEY (id) ); It ... a strict comparison modifier in MySQL? See Question&Answers more detail:os...

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

0 votes

745 views

1 answer

mysql - Escaping values in SQL queries (C# with SQL connector)

I know I can use the parameters, but what is the right way to escape string sequences? The query could be ... . parameters cannot be used here! See Question&Answers more detail:os...

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

0 votes

673 views

1 answer

mysql - How do I add a total as the last row in my sql?

I'm trying to display a row, 'Total', that will do a sum of the Count column. The following code will ... proper syntax to do this? Thanks! See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags