All Questions
48
questions
0
votes
1
answer
185
views
MySQL search for the string "space" does not return a result
I have a table with a string column name. It contains values, several of them contain the string "space", e.g. Spaceship, Myspace. When I run this query I get no result:
SELECT * FROM izz_services ...
- 266
0
votes
2
answers
1k
views
Json to mariadb triples in storage size
I am trying to move my file based organizing json files to mariadb. Approximately there are 2,000,000 json files where in my file based system are zipped. The total storage space for the zipped json ...
4
votes
2
answers
201
views
SQL Is there a way to link two tables with the same value but different formats?
So I have two columns from two different databases that I would like to link.
Problem is that my first column outputs the numbers with this format "1 789 987" and my second column outputs the data "...
- 101
0
votes
0
answers
32
views
Searching a string that contains space or a full stop (eg "txt 1" or "txt.1"), using PHP, returns no records
I am facing the following problem.
I have a table with a column (CHAR 10) that contains keywords that some of them have a space or a full stop in them.
eg:
sessionid
SES1
SES2
SES2 1 <--
SES2 1 &...
3
votes
1
answer
222
views
MySQL select compare numbers from space separated string
I have a Resolution column in a table where the resolution is space separted, eg: 1024 768.
I want to select all rows that have the width (first number) between A and B.
How can I write something ...
- 28.1k
0
votes
1
answer
112
views
SQL: Remove spaces in all tables
I want to remove all spaces in front and after the entries in all my columns in all my tables. For one column I use UPDATE table_name SET column_name= LTRIM(RTRIM(column_name)) which works well. ...
- 603
0
votes
1
answer
170
views
C# Mysql create a table name with spaces
I have searched quite a bit for this without luck, my question is simple, I have a class that looks like this:
public static void Mysql_CreateTable(string tableSegment, string ConString)
{
...
- 439
0
votes
0
answers
147
views
Storing Unity3d string with white spaces into VARCHAR field in MYSQL
I'm working on something with Unity3d MySQL Db. I am passing values through $_GET PHP method but I'm having trouble with strings with white spaces when I store them into the assigned tables.
Let's ...
- 79
2
votes
2
answers
985
views
How to prevent entering text containing spaces in mySQL
It happens occasionally that users erroneously enter text with a trailing space in a text column, which is hard to spot visually. This can later cause problems when this text field has to be matched ...
- 69
0
votes
1
answer
283
views
Mysql And php Select only show first word
Hello Friends I have a problem with my php page and Mysql, I run this setence for example "Select name from articles" and it´s work ok but when a name of one article has the following structure it ...
- 169
0
votes
1
answer
46
views
Check to see if tables are present in a database - stored procedure - MySQL
I want the user to input whatever database they want to check and whatever tables they want to check. For example the call would look like this:
call tableCheck('MyDatabase', 'table1 table20 table3')...
- 27
1
vote
1
answer
6k
views
How can I turn off mysql audit log while server is running?
I do have a highly active server and can't restart it. Long back I have activated the audit log but due to space issue I need to turn it off. Below are my variables;
audit_log_buffer_size | ...
- 127
1
vote
2
answers
329
views
Disk usage for optimizing a partitioned MySQL-Table
I have a large MyISAM table with 3 million rows that has a size of 31 GB due to a 10KB blob in each row. The table has already 30 partitions. I want to optimize the table since I am going to remove ...
- 1,360
-3
votes
1
answer
60
views
how to echo data as it is in the DB the same format?
I am developing web application the data in the database is like this
"
10 Functions
Touch Control
LCD display
Electric programmer with:
Minute minder,
automatic start
Automatic end of ...
- 29
-1
votes
1
answer
98
views
Cannot see the whole information from my database in a text field if i have a space in my text
I have problem in my site, to be more specific in my edit pages and especially in my edit textfields it does not shows the whole information in the textfields.
As you can see in the images, in the ...
- 644