Webmaster2020.com

Hi,

does anyone know how to get the last characters of a string?
in bash.

Thanks

The simple answer :

REPAIR TABLE tablename

if you want more information:
https://dev.mysql.com/doc/refman/8.0/en ... table.html
or
http://dev.mysql.com/doc/refman/5.0/en/ ... epair.html

Yes it possible.
Separate the emails with comas.

Edit the file /etc/postfix/vmail_aliases

Code: Select all

group@domain.com bob@domain.com,alice@domain.com

Found the solution:

Apache/php now create a directory in /imp which hold the /tmp/file.tmp

Code: Select all

/tmp/systemd-private-9b5e7c68bxxx45faa1a812b5df02f1ab-apache2.service-5ExxRI/tmp/

So it doesn't write directly to /tmp.
Makes it more difficult to read it by another script

I have a php script that writes to /tmp directory

Code: Select all

file_put_contents('/tmp/file.tmp',$value);

But it doesn't write, I can't find the files.
I also don't get errors (php or in apache)

Anyone got any ideas ?

Yes, you can with update:

here is an example:

Code: Select all

UPDATE update_table AS a, source_table AS b SET a.update_column=b.source_table WHERE a.id=b.id;

You can use CSS and set inline-block ( with fixed width )
It will set the Li-element next to each other,
and with fixed-width it will look like columns.

li {display: inline-block; width:200px;}

You can also play with the following in CSS,
but the support depends on browser.

columns: 2 ...

The foreign key is actually on another table;
Use this command to find it:
SELECT * FROM information_schema.table_constraints WHERE constraint_schema = 'DATABASE_NAME' AND constraint_type = 'FOREIGN KEY' ;

Once you find it, you can remove it on that table:
ALTER TABLE other_table DROP FOREIGN ...

Thanks that is what I was looking for

You can use

Code: Select all

VARIABLE="test 556";

VARIABLE=${VARIABLE//[0-9]/};

But this will remove all digits not only at the end.

Better is to use sed

Code: Select all

VARIABLE=`echo $VARIABLE | sed -e 's/[0-9]*$//g'`;

Webmaster2020.com

Search found 212 matches

Bash last char of a string

Re: mysql table is marked as crashed and should be repaired

Re: postfix forward mail to multiple recipients

Re: PHP file_put_contents not writing to /tmp

SOLVED: PHP file_put_contents not writing to /tmp

Re: update query update from another table

Re: HTML CSS show li items in multiple columns

Re: Drop table fails

Re: Bash remove trailing digits

Re: Bash remove trailing digits