Recent questions tagged MySql

0 votes

1.0k views

1 answer

Here is the table definition CREATE TABLE `dt_prdtime` ( `TCompany` varchar(3) NOT NULL DEFAULT '', ` ... something wrong with dt_prdtime table? See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

mysql - Drop muli-column unique key without dropping foreign key?

I am trying to delete a multi-column unique key from a table that also has a foreign key. I keep ... without dropping the foreign key first? See Question&Answers more detail:os...

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

0 votes

1.3k views

1 answer

mysql - PHP Check if string contains a letter

I am creating a login and want to allow my users to login either by username or email. How would I check if ... I use strstr or strpos? Thanks! See Question&Answers more detail:os...

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

0 votes

937 views

1 answer

mysql - How can I update a specific record without SELECT permission?

I want to execute something like this: UPDATE grades SET status="pass" WHERE recno=123; However, I want the ... in a specific record" problem. See Question&Answers more detail:os...

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

0 votes

996 views

1 answer

mysql - PHP, get data from the database

I want to retrieve data from a database with PHP and show it on a website. This code does not work ... data from the database with PHP? See Question&Answers more detail:os...

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

0 votes

1.4k views

1 answer

mysql - Get Max value and corresponding column

How can I get corresponding columns from a max query in mysql? I want find out how many wins a player has. I will find ... 432 4 | 2 | 2 | 298 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 "LOAD DATA LOCAL INFILE" in Java

I have a cvs file which schema is, every field is surrounded with ", and seperated by , and every tuple is a ... if you can help me. Thanks 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 achieve unique auto-incremented id for rows across multiple tables?

I've got several tables in a database, let's say they're called table1, table 2, etc. All tables have ... to the mysql configuration? Thank you See Question&Answers more detail:os...

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

0 votes

1.5k views

1 answer

mysql - How do I add conditions in sub-sub child models in sequelize which should impact my parent Model in findAndCountAll?

In sequelize, I want to add a condition in findAndCountAll call in sub-sub child models. If the condition is false, it should ... , ], }, ], }); See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

mysql - Best way to read CSV in Ruby. FasterCSV?

I have a CSV file that I want to read with Ruby and create Ruby objects to insert into a MySQL database with ... guess I should use that one? See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

mysql - Why is the result of `select 'a'=0;` 1?

mysql> SELECT 'a'='b'='c'; +-------------+ | 'a'='b'='c' | +-------------+ | 1 | +---------- ... ----+---------+ Why does 'a' equals 0 in MySQL? 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 select random unique records on each execution of the SQL Query

I have a table "masterurls" it has morethan 1 million records. I want to fetch random records each time the ... and randomizes it each time. 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 HAVING max(count()) return zero rows

I'm trying to get class rooms with overlap course schedule, my tables: courses: COURSE_ID NAME 11 matematika 22 logika ... to get what I need? See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

mysql - Trailing Sum Query

I am looking to summarize date and need to find a way of doing a 3 day trailing sum, sum of the ... or suggestions would be greatly appreciated. See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

mysql - Delete Using Multiple Tables and repeat table in the subquery

I want fire all employees from the department with lower sales Schema and Sql fiddle CREATE TABLE Employee ( ... correct syntaxis or workaround? See Question&Answers more detail:os...

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

0 votes

1.0k views

1 answer

mysql - Meaning of id = LAST_INSERT_ID(id)

Supposing I have a table: CREATE TABLE files ( id_prod INT UNSIGNED NOT NULL DEFAULT PRIMARY KEY AUTO_INCREMENT, id_rel ... it's supposed to do? See Question&Answers more detail:os...

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

0 votes

1.0k views

1 answer

mysql - Connecting multiple database and join query across database in php

Using php i wants to make a join query across 2 database. This is my first connection. $conn = ... . print_r(mysql_fetch_array($result)); See Question&Answers more detail:os...

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

0 votes

1.5k views

1 answer

mysql - How to find unique pairs from two columns in SQL?

i have a table"Dummy" with columns "col1 and col2". How do i find unique pairs from(col1,col2). For example in ... missed out the pair (d,c). See Question&Answers more detail:os...

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

0 votes

1.6k views

1 answer

mysql - Cx-Freeze : Showwarning AttributeError: 'NoneType' object has no attribute 'write'

Scripts works fine on source file with using Anaconda alongside with Python 3.4. When i cxfreeze (v 4.3.4) it ... on my system or on server. See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

mysql - Locking rows for select query?

I have a mysql table (table-A) that contains a list of unique product ids. The app which utilizes this table ... it and instead picks row-2. See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

mysql - proper way of inserting data with id as auto-increment in mysqli

can someone please verify the proper way of inserting data using MYSQLI? i need to insert comment data into the table ... "; $db->query($query); 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 do I order by multiple columns in a SELECT query?

I have a table of records like below int_record_id int_category_id str_name int_order bit_active 1 1 test1 2 1 2 1 ... exact sql query for this. See Question&Answers more detail:os...

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

0 votes

1.3k views

1 answer

mysql - Is this possible to join tables in doctrine ORM without using relations?

Suppose there are two tables. Table X-- Columns: id x_value Table Y-- Columns: id x_id ... .php on line 290 See Question&Answers more detail:os...

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

0 votes

970 views

1 answer

mysql - Select from table if record found in another table

I need to select some rows from Table 1 lets say if a value is found in Table 2. So I want to check if ... for value within one table. Any idea? See Question&Answers more detail:os...

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

0 votes

964 views

1 answer

mysql - Java PreparedStatement complaining about SQL syntax on execute()

This is driving me nuts... What am I doing wrong here? ArrayList<String> toAdd = new ArrayList<String>(); toAdd. ... : 0 What am I doing wrong? See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

mysql - What is second level SQL Injection

What is all about the second level SQL Injection.. This is with reference to the question Use of parameters for ... answers had this term... See Question&Answers more detail:os...

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

0 votes

1.0k views

1 answer

mysql - Select records by month in where clause

My query to get data by month $this->db->select('vehicle_make_and_model'); $this->db->join(' ... http://awesomescreenshot.com/0424q72ne5 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 change Column Collation without losing or changing data?

I have been using mysql version 5.5.41 and have run into an issue. I change the collation of a ... SET hebrew COLLATE hebrew_bin NOT NULL; See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags